单选题You want to move all objects of the APPS user in the test database to the DB_USER schema of the productiondatabase.  Which option of IMPDP would you use to accomplish this task（）A FULLB SCHEMASC TRANSFORMD REMAP_SCHEMAE REMAP_TABLESPACE

第1题：

Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）

• A、Perform Export before TSPITR and Import after TSPITR
• B、Move objects to another schema that has the same tablespace assigned
• C、Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
• D、Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

第2题：

You want to convert your existing non-ASM files to ASM files for the database PROD.  Which method or command would you use to accomplish this task？（）  

• A、 Data Pump Export and Import
• B、 conventional export and import
• C、 the CONVERT command of RMAN
• D、 the BACKUP AS COPY. command of RMAN

第3题：

In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5：00 p.m. CALC_STAT updates the optimizer statistics for the objects owned by the APPS schema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task. Which component of Oracle Scheduler must you define to achieve this？（）

• A、Window
• B、Program
• C、Job class
• D、Window group

第4题：

On Tuesday， a junior DBA dropped an important application user account， whose schema has important tables. You are asked to recover all the objects in the schema. On investigation， you find that the user account was dropped at 11：00 a.m. and Sunday’s backup is the most recent backup. Which flashback feature would you use？（）

• A、Flashback Drop
• B、Flashback Table
• C、Flashback Database
• D、Flashback Version Query
• E、Flashback Transaction Query

第5题：

You want to move all objects of the APPS user in the test database to the DB_USER schema of the productiondatabase.  Which option of IMPDP would you use to accomplish this task（）

• A、FULL
• B、SCHEMAS
• C、TRANSFORM
• D、REMAP_SCHEMA
• E、REMAP_TABLESPACE

第6题：

You want to administer your PROD database from a remote host machine using a Web-enabled interface. Which Oracle tool would you use to accomplish this task efficiently without using command-line interfaces？（）

• A、SQL*Plus
• B、iSQL*Plus
• C、Management Server
• D、Management Repository
• E、Oracle Enterprise Manager 10g Database Control

第7题：

You want to move all the objects of the APPS user in the test database to the DB_USER schema of the production database. Which option of IMPDP would you use to accomplish this task？（）

• A、FULL
• B、SCHEMAS
• C、REMAP_SCHEMA
• D、REMAP_DATAFILES
• E、REMAP_TABLESPACE

第8题：

You want to migrate your application from the development environment to the production environment. While doing the task， you want the database objects owned by the user DEVUSER in the development environment to be moved to the user APPS in the production environment. Which option of Oracle Data Pump Import would you use to achieve this objective？（）

• A、owner
• B、touser
• C、include
• D、schemas
• E、fromuser
• F、transform
• G、remap_schema
• H、remap_datafile
• I、reuse_datafiles
• J、remap_tablespace

第9题：

The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump.  Which option of Data Pump Import would you use to accomplish this？（）  

• A、 owner
• B、 touser
• C、 attach
• D、 remap_schema

第10题：

You want to migrate your existing non-ASM files to ASM files for the database PROD. Which method  or command would you use to accomplish this task？（）

• A、the CONVERT command of RMAN
• B、Data Pump Export and Import into the same database
• C、conventional export and import into the same database
• D、the BACKUP DATABASE and RESTORE DATABASE commands of RMAN
• E、the BACKUP AS COPY DATABASE and SWITCH DATABASE TO COPY command of RMAN