You created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL> DROP PROFILE app_user；  Which statement describes the result（）

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 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 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 work as a database administrator for Certkiller .com. You want to create a new optimized database for your transactional production environment to be used by a financial application. While creating the database， you want the Oracle Software to take care of all basic settings to optimize the database performance.  Which method would you use to achieve this objective？（）

单选题查看答案

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

多选题查看答案

You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing.  What information is captured as part of this process？（）

多选题查看答案

As DBA for the Rebel Alliance you have decided that you need to facilitate some redundancy in your database. Using ASM， you want to create a disk group that will provide for the greatest amount of redundancy for your ASM data （you do not have advanced SAN mirroring technology available to you， unfortunately）.  Which of the following commands would create a disk group that would offer the maximum in data redundancy？（）

单选题查看答案

You work as a database administrator for Certkiller .com. You need to rename a data file of atablespace.  How would you perform this？（）

单选题查看答案