多选题In an environment that includes both a Master Domain Manager （MDM）  and Backup Master Domain Manger （BMDM），  which two options are  appropriate for the location of the database？ （）Alocal database installed on the MDM onlyBlive local database installed 

第1题：

In an environment that includes both a Master Domain Manager （MDM）  and Backup Master Domain Manger （BMDM），  which two options are  appropriate for the location of the database？ （）

• A、 local database installed on the MDM only
• B、 live local database installed on the BMDM only
• C、 single database on a clustered machine remote from the MDM and BMDM
• D、 live database installed on a single Fault Tolerant Agent within IBM  Tivoli Workload Scheduler network
• E、 live database on MDM and High Availability Disaster Recovery/Data  Guard standby database on BMDM

第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题：

Which two are characteristics of user-managed backup and recovery operations？（）

• A、Recovery is initiated using SQL*Plus.
• B、Database files are backed up using SQL commands.
• C、Database files are backed up with Recovery Manager.
• D、Database files are restored using Recovery Manager.
• E、Database files are backed up using operating system commands.

第5题：

Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups.  Which two backups would you be able to perform when the database is being accessed by users？（）

• A、backup of offline tablespaces
• B、backup of read­only tablespaces
• C、backup of system­critical tablespaces
• D、backup of online， locally managed tablespaces
• E、backup of read/write dictionary­managed tablespaces

第6题：

You need to replicate a table from a master to a slave. The master and slave copies of the table will have different number of columns. Which two conditions must be true?（）

• A、Each extra column in the copy with more columns must not have a default value
• B、Columns that are common to both versions of the table must be defined in the same order on the master and the slave
• C、The slave database cannot have more columns than the master. Only the master database can have more columns
• D、Columns that are common to both versions of the table must come first in the table definition, before any additional columns are additional columns are defined on either server
• E、The master database cannot have more columns than the slave. Only the slave deatbase can have more columns

第7题：

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process，you execute the following script：   SQL>@utlu111i.sql   Which statement about the execution of this script is true？（）

• A、 It must be executed from the Oracle Database 11g environment.
• B、 It must be executed only after the SYSAUX tablespace has been created.
• C、 It must be executed from the environment of the database that is being upgraded.
• D、 It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
• E、 It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

第8题：

第9题：

You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database. Which two statements are true about this backup operation? （）(Choose two.)

• A、Backup compression should be enabled
• B、Parallelism for the channel should be set to 2
• C、All the files must be backed up as backup sets
• D、The backup may be stored either on disk or on media with media manager

第10题：

You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction 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 youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)

• 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