You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database.  Which is the most effective method to access this data in your database（）

You are working on a database that must be functioning 24 hours a day， 7 days a week. The databaseis configured in ARCHIVELOG mode.  Which two options do you have for performing user-managed backups（）

多选题查看答案

You need to rename a data file of a tablespace. How would you perform this？（）

单选题查看答案

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 have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space.  You can use Segment Advisor to （）

单选题查看答案

Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you.  Which two statements are true in this scenario？（）

多选题查看答案

You have a production instance running on your server. UNDO_RETENTION is not long enough to satisfy read-consistency requirements. How do you change the UNDO_RETENTION value？（）

单选题查看答案

You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately， you have an automated cross-check script that also does a delete expired backupset command. You have restored all the backup set pieces from tape.  What command would you use to get those backup set pieces registered in the recovery catalog and the control file of the database again？（）  

单选题查看答案

You are maintaining the SALES database. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity.  Which parameter should you specify to control the speed of the rebalancing activity？（）

单选题查看答案

You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a redundancy-based retention policy：   CONFIGURE RETENTION POLICY TO REDUNDANCY 3；   Which statement is true？（）  

单选题查看答案

You work as a database administrator for Certkiller .com. In your Oracle database10g installation you have set ORACLE_BASE to /u01/app/oracle.  Which objective will be achieved by this setting？（）

单选题查看答案