单选题Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）A The database is in mount state.B One of the tablespaces is offline.C One of the tablespaces is read only.D

第1题：

第2题：

You are using a recovery catalog to maintain Recovery Manager （RMAN） backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups.  Identify two options for completing this task.（）

• A、 Reregistering the target database in recovery catalog
• B、 Transporting the new tablespaces to the recovery catalog database
• C、 Syncronizing the recovery catalog with the target database control file
• D、 Performing a fresh backup of the target database to include the new data files in the catalog database

第3题：

第4题：

You are managing a 24*7 database. The backup strategy for the database is to perform user-managedbackups.Identify two prerequisites to perform the backups. (Choose two.)（）

• A、The database must be opened in restricted mode.
• B、The database must be configured to run in ARCHIVELOG mode.
• C、The tablespaces are required to be in backup mode before taking the backup.
• D、The tablespaces are required to be in read-only mode before taking the backup

第5题：

While planning to manage more than one database in your system， you perform the following activities：  1. Organize different categories of files into independent subdirectories.  2. Use consistent naming convention for database files.  3. Separate administrative information pertaining to each database.  Which option corresponds to the type of activities performed by you？（）

• A、Oracle Managed Files
• B、Oracle Grid Architecture
• C、Optimal Flexible Architecture
• D、Oracle database architecture

第6题：

Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

• A、The database is in mount state.
• B、One of the tablespaces is offline.
• C、One of the tablespaces is read only.
• D、The database operates in ARCHIEVELOG mode. 
• E、The database operates in NOARCHIEVELOG mode.

第7题：

Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）

• A、 open the database with the RESTRICTED option
• B、 open the database with the RESETLOGS option
• C、 recover to the required SCN only that data file in which the error occurred
• D、 recover all the data files to the same system change number （SCN）

第8题：

第9题：

If you create your database using Oracle Managed Files （OMF）， what is true？（）

• A、You must use Oracle predefined names to identify raw partitions that will hold OMF structures. 
• B、You must define directories for two online redo log groups and three copies of the control file. 
• C、If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically. 
• D、You must use only OMF data files when adding new tablespaces or data files to your database in the future.

第10题：

Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）

• A、You can perform online whole database backups.
• B、You can performofflinewhole database backups.
• C、You cannot perform schema-level export/import operations.
• D、You can perform the backup of only the SYSTEM tablespace when the database is open.