You completed the development of a new application and want to create a new domain in a new environment for functional testing. You want to have the same settings for your new domain as your old domain, with the option of changing the configuration in the new target environment. Which two actions should you execute?（）

You have a database with the following tablespaces： SYSTEM， SYSAUX， UNDO， USERS， TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday.  Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task？（） 

多选题查看答案

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

多选题查看答案

You are configuring the data source for an Oracle database. You will need to specify a test table for WebLogic to test the status of the database. Which option should you choose?（）

单选题查看答案

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？（）  

单选题查看答案

You want to create a copy of the DEPARTMENTS table. When that is complete， you want to truncate the new DEPARTMENTS table， then restore the data with a direct-load insert from the old DEPARTMENTS table.  Which CREATE statement should you use？（）

单选题查看答案

Exhibit， error You work as a database administrator for Supportcenter.cn. When you try to connect to the database， you get an error （See exhibit）. What could be the possible reason for getting such an error？（）

单选题查看答案

You executed the following procedure to collect statistics regarding an index：       SQL>ANALYZE INDEX EMP_ID VALIDATE STRUCTURE；   Which view will you use to determine whether you need to rebuild the index or not？（） 

单选题查看答案

While selecting files during an interactive restore with ufsrestore， you are interrupted by a junior  administrator before you can complete the file selection process and start the restore. After answering the administrator’s question， you realize that you have forgotten which files you had already selected for the restore.  How can you determine which files are already marked for extraction and restore？ （）

单选题查看答案

You want to use the SQL Tuning Advisor to generate recommendations for badly written SQL statements in your development environment.   Which three sources can you select for the advisor to analyze？ （）

多选题查看答案