You create two resource plans，one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.  How would you achieve this？（）  

You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database.  What additional information is available to you when you enable tracing？（）

单选题查看答案

You want to create the Recovery Manager （RMAN） Virtual Private Catalog （VPC） to maintain a separation of responsibilities along with a consolidation of RMAN repository.  Which condition must be met before you create the VPC？（）  

单选题查看答案

You created a database by using the Database Configuration Assistant. What must you do to access a user account in the sample schemas？（）

单选题查看答案

You have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users.   Which step must be performed before you can start using the resource plan？（）

单选题查看答案

You work with a newly created database. Presently， there is no application load on the database instance. You want to create a baseline for tuning the application， so you decide to collect recommendations that can be implemented to improve application performance.  What action must you take to achieve this？（）  

单选题查看答案

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

单选题查看答案

View this parameter setting in your database：   DB_CREATE_FILE_DEST=’D:// /oracle/product/10.2.0/oradata/oracle’  You created a tablespace by using this command：   CREATE TABLESPACE USERS；  Which two statements are true about the USERS tablespace？（）

多选题查看答案

You want to use RMAN to create compressed backups.  Which statement is true about the compression algorithms that RMAN can use？（）

单选题查看答案

You work as a database administrator for Supportcenter.cn. While setting up the database for your production environment， you want to create a user according to the requirements in the exhibit. Which three options of the CREATE USER command would you use to achieve this objective？（）

多选题查看答案

You work as a database administrator for Certkiller .com. While setting up the database for your production environment， you want to create a user according to the requirements in the exhibit.  Which three options of the CREATE USER command would you use to achieve this objective？（）

多选题查看答案