单项选择题
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 -
单项选择题
ToviewtheresultsofthemostrecentAutomaticSQLTuningAdvisortask，whichsequenceshouldyoufollow？（）
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
