You want to enable the user， Scott， to change to the GRP1 consumer group by issuing the following code：        SQL> EXEC DBMS_SESSION.SWITCH_CURRENT_CONSUMER_GROUP  （’SCOTT’，       ’GRP1’， FALSE）；   How will you grant the switch privilege to the user， Scott？（）  

You want to drop the TBS1 tablespace from your database.  You also want to delete the corresponding data files automatically， and not have to do it manually.  What should you do？（）

单选题查看答案

Your boss at Certkiller .com wants you to clarify Oracle 10g. What statement about the Shared Server configuration is valid？（）

单选题查看答案

You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database.  What action would you take to achieve this？（）

单选题查看答案

You want to configure and schedule offline database backups to run automatically.  Which tool or utilitywould you use to achieve this（）

单选题查看答案

You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically.  Which tool or utility would you use to achieve this？ （）

单选题查看答案

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 are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure.  Which configuration will you do to accomplish the 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？（）

单选题查看答案

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 use RMAN to create compressed backups.  Which statement is true about the compression algorithms that RMAN can use？（）

单选题查看答案