None of the SYSAUX occupants can be relocated.
The USERS tablespace is a bigfile tablespace (BFT).
The united Job Scheduler occupant cannot be relocated.
The SYSAUX occupants can be relocated to the SYSTEM tablespace only.
第1题:
Youarecreatingajobclass.Youhaveissuedthefollowingcommandtocreatethejobclass:SQL>BEGINDBMS_SCHEDULER.CREATE_JOB_CLASS(JOB_CLASS_NAME=>’LOW_PRIORITY_CLASS’,RESOURCE_CONSUMER_GROUP=>’LOW_GROUP’,LOGGING_LEVEL=>DBMS_SCHEDULER.LOGGING_FULL,LOG_HISTORY=>1200,COMMENTS=>’LOWJOBPRIORITYCLASS’);END;SQL>/Whatwillbetheresultoftheabovecommand?()
A.Thecommandwillbeexecutedsuccessfully.
B.ThecommandwillfailbecauseRESOURCE_CONSUMER_GROUPisaninvalidparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.
C.ThecommandwillfailbecauseLOGGING_LEVELisaninvalidparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.
D.ThecommandwillfailbecauseLOG_HISTORYisaninvalidparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.
E.Thecommandwillfailbecause1200isaninvalidvaluefortheLOG_HISTORYparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.
第2题:
You notice that the elapsed time for an important database scheduler Job is unacceptably long.The job belongs to a scheduler job class and window.Which two actions would reduce the job‘s elapsed time?()
A. Increasing the priority of the job class to which the job belongs
B. Increasing the job‘s relative priority within the Job class to which it belongs
C. Increasing the resource allocation for the consumer group mapped to the scheduler job‘s job class within the plan mapped to the scheduler window
D. Moving the job to an existing higher priority scheduler window with the same schedule and duration
E. Increasing the value of the JOB_QUEUE_PROCESSES parameter
F. Increasing the priority of the scheduler window to which the job belongs
第3题:
A.DBA_SCHEDULER_JOB_RUN_DETAILS
B.DBA_SCHEDULER_RUNNING_JOBS
C.DBA_SCHEDULER_JOBS
D.DBA_SCHEDULER_JOB_LOG
第4题:
Which view will you use to view information regarding the jobs that are currently running in a database?()
第5题:
While creating a job class using the DBMS_SCHEDULER package, you set the logging level to LOGGING_RUNS. What would be the impact of this setting?()
第6题:
A.DBA_SCHEDULER_RUNNING_JOBS
B.DBA_SCHEDULER_JOB_RUN_DETAILS
C.DBA_SCHEDULER_JOBS
D.DBA_SCHEDULER_JOB_LOG
第7题:
You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is stored as a local package on the server. The package exports data from an online transaction processing (OLTP) database system to an online analytical processing (OLAP) database system that is located on a second SQL Server 2000 computer.
You want the package to execute automatically each evening at 8:00 P.M. What should you do?
A.Use SQL Server Enterprise Manager to create a new job Create a CmdExec job step that runs the dtsrun utility Schedule the job to run each night at 8:00 P.M.
B.Use SQL Server Enterprise Manager to create a new job Create a Transact-SQL job step to query data from the OLTP database Create a second Transact-SQL job step to launch the DTS package Schedule the job to run each night at 8:00 P.M.
C.Create a batch file that runs the dtsrun utility Use the Microsoft Windows Task Scheduler to run the job each night at 8:00 P.M. Configure the Windows Task Scheduler to use the local system account
D.Move the DTS package to the repository Configure the SQLServerAgent service on the OLAP database server to update the package each night at 8:00 P.M.
第8题:
A.EXECUTEDBMS_SCHEDULER.PURGE_LOG(log_history=>5,job_name=>’JOB1’);
B.EXECUTEDBMS_SCHEDULER.PURGE_LOG(log_history=>5,job_name=>’JOB_LOG’);
C.EXECUTEDBMS_SCHEDULER.PURGE_LOG(log_history=>5,which_log=>’JOB1’);
D.EXECUTEDBMS_SCHEDULER.PURGE_LOG(log_history=>5,which_log=>’JOB_LOG’);
第9题:
You want to purge job entries older than 5 days from the job log. You do not want to purge window log entries. Which command will you use to accomplish this task?()
第10题:
You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically. Which tool or utility would you use to achieve this? ()