单选题By default, checkpoints happen at least as often as（）.A Redo log switches. B UPDATE statements are issued against the database. C The SYSTEM tablespace is accessed. D SMON coalesces free space in a tablespase.

第1题：

During regular database operation, which background process will take smaller blocks of free space in a dictionary-managed tablespace and move things around to make bigger pieces of free space?（）

• A、DBW0 
• B、LGWR 
• C、ARCH 
• D、SMON 
• E、PMON

第2题：

You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?（）

• A、ALTER DATABASE 
• B、ALTER SYSTEM 
• C、ALTER USER 
• D、ALTER REDO LOG

第3题：

Evaluate the following command and its output：   SQL>SELECT * FROM dba_temp_free_space；  TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE  LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output？（）

• A、 FREE_SPACE indicates only the space that is currently unallocated.
• B、 ALLOCATED_SPACE indicates only the space currently allocated and in use.
• C、 FREE_SPACE indicates only the space that is currently allocated and available for reuse.
• D、 ALLOCATED_SPACE indicates both the space currently allocated and used，and the space that is available for reuse.
• E、 FREE_SPACE indicates both the space that is currently allocated and available for reuse，and the space that is currently unallocated.

第4题：

You are attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one.  Which is it?（）

• A、Size of redo logs 
• B、Number of datafiles 
• C、LOG_CHECKPOINT_INTERVAL 
• D、LOG_CHECKPOINT_TIMEOUT

第5题：

Which two statements regarding the LOGGING clause of the CREATE TABLESPACE. .. statement are correct？（）

• A、This clause is not valid for a temporary or undo tablespace.
• B、If the tablespace is in the NOLOGGING mode， no operation on the tablespace will generate redo.
• C、The tablespace will be in the NOLOGGING mode by default， if not specified while creating a tablespace.
• D、The tablespace­level logging attribute can be overridden by logging specifications at the table， index， materialized view， materialized view log， and partition levels.

第6题：

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

第7题：

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）.

第8题：

Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct？（）

• A、This clause is not valid for a temporary or undo tablespace.
• B、If the tablespace is in the NOLOGGING mode，no operation on the tablespace will generate redo.
• C、The tablespace will be in the NOLOGGING mode by default，if not specified while creating a tablespace.
• D、The tablespace-level logging attribute can be overridden by logging specifications at the table，index， materialized view，materialized view log，and partition levels.

第9题：

You configured the Flash Recovery Area （FRA） for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.  Which two files are removed automaticallyif the space is required in the FRA as per the retention policy（）

• A、flashback log files
• B、backups that have become obsolete
• C、copies of the data files and control files
• D、archived redo log files that have multiple copies in a different archive location and not backed up

第10题：

By default, checkpoints happen at least as often as（）.

• A、Redo log switches. 
• B、UPDATE statements are issued against the database. 
• C、The SYSTEM tablespace is accessed. 
• D、SMON coalesces free space in a tablespase.