单项选择题
To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?()
A. From the Advisor Central home page,select the tuning task from the Advisor Tasks section
B. From Advisor Central,choose SQL Advisors,SQL Tuning Advisors,Manual Tuning Task Results
C. From Advisor Central,choose SQL Advisors,Manual SQL Tuning Advisors,Tuning Task Results
D. Either B or C
相关考题
-
单项选择题
You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation. The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system. How would you create these jobs?()
A. Create both jobs by using events raised by the scheduler
B. Create both jobs by using events raised by the application
C. Create a job to rebuild indexes by using events arised by the application and then create another job to perform bulk load by using events raised by the scheduler
D. Create a job to rebuild indexes by using events arised by the Scheduller and then create another job to perform bulk load by using events raised by the application -
单项选择题
WhencreatingaSQLtuningset,whichofthefollowingstepsallowstheDBAtoreducethesizeoftheSQLsetbyselectingspecificoperatorsandvalues?()
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
