单选题You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）A Shared pool B Control file C SGA D PGA

题目内容(请给出正确答案)

单选题

You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）

Shared pool

Control file

SGA

PGA

参考答案和解析

正确答案： B

解析：暂无解析

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

更多相关问题

第1题

单选题You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement： SQL>ALTER DATABASE OPEN RESETLOGS； Which of the following options is true about using the RESETLOGS option？（）AThe log sequence is reset to 0.BAll the online redo logs are deleted.CAll the archived redo logs from a previous incarnation become useless.DThe full database backup taken from a previous incarnation can be used in future.EOnly the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

点击查看答案
第2题

单选题You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database. After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’ DB_RECOVERY_FILE_DEST = ’LOCATION=d：/product/10.1.0/flash_recovery_area’ DB_RECOVERY_FILE_DEST_SIZE=10g Where are the archived redo logs stored for your database？（）AThe archived redo logs are stored in an operating system-dependent location.BThe archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.CThe archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.DThe archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and DB_RECOVERY_FILE_DEST.

点击查看答案
第3题

单选题You noticed that large memory allocations for the Oracle backup and restore operations are causing a performance overhead on the shared pool. Which memory structure would you configure to avoid this performance overhead？（）Arecycle buffer cacheBlarge poolCstreams poolDkeep buffer cacheEredo log buffer

点击查看答案
第4题

单选题You received the following error： ORA-01578： ORACLE data block corrupted （file # %s， block # %s） Which file will you check to view additional information regarding the cause of this error？（）A the alert log file and the trace filesBthe redo log filesCthe control fileDthe change tracking file

点击查看答案
第5题

单选题When you are allowing RMAN to backup your archived redo log files，how does RMAN know which archived redo logs to back up from your archive log destination？（）A RMAN keeps a list of archive logs in a text file.B The DBA must manually tell RMAN which archive logs to backup.C RMAN has access to target control file and/or catalog information.D RMAN looks at the ARCHIVE_LOG_DEST parameter of your target database and backs up all archive logs found.

点击查看答案
第6题

单选题You have lost all your online redo logs. As a result， your database has crashed. You have tried to restart the database and clear the online redo log files， but when you try to open the database you get the following error. SQL> startup ORACLE instance started. Total System Global Area 167395328 bytes Fixed Size 1298612 bytes Variable Size 142610252 bytes Database Buffers 20971520 bytes Redo Buffers 2514944 bytes Database mounted. ORA-00313： open failed for members of log group 2 of thread 1 ORA-00312： online log 2 thread 1：，，/oracle01/oradata/orcl/redo02a.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3 ORA-00312： online log 2 thread 1：，，/oracle01/oradata/orcl/redo02.log ORA-27037： unable to obtain file status Linux Error： 2： No such file or directory Additional information： 3 SQL> alter database clear logfile group 2； alter database clear logfile group 2 * ERROR at line 1： ORA-01624： log 2 needed for crash recovery of instance orcl （thread 1） ORA-00312： online log 2 thread 1：，，/oracle01/oradata/orcl/redo02.log ORA-00312： online log 2 thread 1：，，/oracle01/oradata/orcl/redo02a.log What steps must you take to resolve the error？（） a. Issue the recover database redo logs command. b. Issue the Startup Mount command to mount the database. c. Restore the last full database backup. d. Perform a point-in-time recovery， applying all archived redo logs that are available. e. Restore all archived redo logs generated during and after the last full database backup. f. Open the database using the alter database open resetlogs command. g. Issue the alter database open command.A b， a， fB e， b， a， fC e， b， a， gD b， a， gE c， e， b， d， f

点击查看答案
第7题

多选题You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？（）AFlashback logs are not archived.BFlashback logs are maintained in redo log files.CFlashback logs are maintained in the Flash Recovery Area.DFlashback logs are used to maintain Flashback Database related errors.EFlashback logs need to be cleared manually after you disable Flashback Database.

点击查看答案

单选题You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）A Shared pool B Control file C SGA D PGA

题目内容(请给出正确答案)

参考答案和解析

更多相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容