多选题What are three purposes of the RMAN “FROM” clause?（）Ato support PUSH-based active database duplicationBto support synchronization of a standby database with the primary database in a Data environmentCTo support PULL-based active database duplicationDTo

第1题：

第2题：

To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?（）

• A、EM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning Advisor.
• B、EM Database home page, Software and Support, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.
• C、EM Database home page, Software and Support, Support Workbench, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.
• D、Either B or C
• E、All of the above

第3题：

第4题：

What type of protection is implemented when the DBA issues the ALTER DATABASE SET STANDBY DATABASE PROTECTED； command？（）

• A、The standby database is protected against write operations. 
• B、The primary database is protected against write operations. 
• C、The primary database is protected against data loss and data divergence. 
• D、The standby database is protected against data loss and data divergence. 

第5题：

In RMAN， when the RESYNC CATALOG command is issued， in which two situations does the command file actually perform synchronization？（）

• A、After the COPY command.
• B、After adding a data file in the target database.
• C、After adding a tablespace in the target database.
• D、After adding a tablespace in the catalog database.
• E、After dropping a data file in the catalog database.
• F、After running SQL Loader to load a large amount of data.

第6题：

Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database？ （）

• A、SYNC or ASYNC to identify the network transmission mode. 
• B、LGWR or ARCH to identify the primary database process responsible for sending redo information to the standby. 
• C、AFFIRM or NOAFFIRM to control whether log archiving disk write operations are to be performed synchronously or asynchronously. 
• D、PROTECTED or UNPROTECTED to control the degree of divergence and data loss at the standby database.

第7题：

The list below displays four steps that you need to execute in order to switch from the primary database role to the standby database role. Choose the correct order of execution for the steps.（）  1. Shot down and start up the former primary instance without mounting the instance.  2. Issue the ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL  STANDBY command.  3. Issue the ALTER DATABASE MOUNTS STANDBY DATABASE command.  4. End read or update activity on the former primary and standby database.

• A、1，2，3，4
• B、3，2，4，1
• C、4，2，1，3
• D、4，3，2，1

第8题：

第9题：

Which three tasks can be performed using a duplicate database? （）(Choose three.)

• A、Testing the backup and recovery procedures
• B、Testing the upgrade of an Oracle database to a new release
• C、Testing the effect of an application changes on database performance
• D、Continuously updating archive log files from the target database to support failover

第10题：

You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task？（）

• A、 Enable Flashback Data Archive for the tables.
• B、 Specify undo retention guarantee for the database.
• C、 Enable supplemental logging for the database.
• D、 Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo  tablespace for that size.
• E、 Create Flashback Data Archive on the tablespace on which the tables are stored.