单选题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题：

You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?（）

• A、Writes buffers to disk 
• B、Writes current redo log number to datafile headers 
• C、Writes redo log information to disk 
• D、Reads information into memory for users

第2题：

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？（）

• A、 The log sequence is reset to 0.
• B、 All the online redo logs are deleted.
• C、 All the archived redo logs from a previous incarnation become useless.
• D、 The full database backup taken from a previous incarnation can be used in future.
• E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

第3题：

You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）

• A、 Flashback logs are not archived.
• B、 Flashback logs are maintained in redo log files.
• C、 Flashback logs are maintained in the Flash Recovery Area.
• D、 Flashback logs are used to maintain Flashback Database related errors.
• E、 Flashback logs need to be cleared manually after you disable Flashback Database.

第4题：

Because of hardware failure， you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file？（）

• A、 The redo log file should belong to an active group.
• B、 The redo log file should belong to an inactive group.
• C、 The redo log file should belong to the current group.
• D、 The redo log file can be dropped only if all the transactions are stopped.
• E、 Before a redo log file is dropped， it should be deleted from the operating system （OS）.

第5题：

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

第6题：

You are using Oracle Database 10g. You performed an  incomplete recovery of your database and opened the database with the RESETLOGS option.  What is the effect of opening the database with the RESETLOGS option？（）

• A、This operation resets the SCN for the database.
• B、This operation creates a new incarnation of the database.
• C、This operation moves all the redo log files to a different location.
• D、This operation deletes the old redo log files and creates new redo log files.
• E、This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.

第7题：

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.

第8题：

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？（）

• A、 recycle buffer cache
• B、 large pool
• C、 streams pool
• D、 keep buffer cache
• E、 redo log buffer

第9题：

You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

• A、 online redo log files
• B、 alert log files
• C、 control file
• D、 datafiles associated with the SYSTEM tablespace

第10题：

You have configured the flash recovery area to store online redo log files， control files， archived redo logs and RMAN backups. Which of the following files can you successfully delete from the flash recovery area if you want to reclaim the space within it？（）

• A、 multiplexed control files
• B、 RMAN obsolete backups
• C、 multiplexed online redo log files
• D、 archived redo logs that have not been copied to tape