单项选择题

When creating a SQL tuning set，which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values？（）

A. Filter versions
B. Filter loads
C. Filter tasks
D. Filter options

点击查看答案

上一题目录下一题

相关考题

单项选择题

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

A. Implement job classes
B. Implement Scheduler windows
C. Implement the mapping rule for the consumer groups
D. Set the SWITCH_TIME resource plan directive for both the resource plans

单项选择题

To view the results of the most recent Automatic SQL Tuning Advisor task，which sequence should you follow？（）

A. EM Database home page，Software and Support，SQL Advisors，Automatic SQL Tuning Advisor
B. EM Database home page，Software and Support，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor
C. EM Database home page，Software and Support，Support Workbench，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor
D. Either B or C
E. All of the above

单项选择题

You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped.
On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that.
So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted the database.
Identify the next set of commands that are required to accomplish the task?（）

A.A
B.B
C.C
D.D