单选题You are unable to move the Unified Job Scheduler occupant from the SYSAUX tablespace to the USERS tablespace. What could be the reason？（）ANone of the SYSAUX occupants can be relocated.BThe USERS tablespace is a bigfile tablespace （BFT）.CThe united Job Scheduler occupant cannot be relocated.DThe SYSAUX occupants can be relocated to the SYSTEM tablespace only.
单选题
You are unable to move the Unified Job Scheduler occupant from the SYSAUX tablespace to the USERS tablespace. What could be the reason？（）
A
None of the SYSAUX occupants can be relocated.
B
The USERS tablespace is a bigfile tablespace （BFT）.
C
The united Job Scheduler occupant cannot be relocated.
D
The SYSAUX occupants can be relocated to the SYSTEM tablespace only.
参考解析
解析：
暂无解析
相关考题：
Youwanttoviewthenameofaprogramassociatedwithajobformakingsomechangestotheprogram.Whichviewwillyouquerytofindthenameoftheprogramassociatedwiththejob?() A.DBA_SCHEDULER_JOB_RUN_DETAILSB.DBA_SCHEDULER_RUNNING_JOBSC.DBA_SCHEDULER_JOBSD.DBA_SCHEDULER_JOB_LOG
Youwanttopurgejobentriesolderthan5daysfromthejoblog.Youdonotwanttopurgewindowlogentries.Whichcommandwillyouusetoaccomplishthistask?() 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’）；
Youarecreatingajobclass.Youhaveissuedthefollowingcommandtocreatethejobclass：SQLBEGINDBMS_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.
Whichviewwillyouusetoviewinformationregardingthejobsthatarecurrentlyrunninginadatabase?() A.DBA_SCHEDULER_RUNNING_JOBSB.DBA_SCHEDULER_JOB_RUN_DETAILSC.DBA_SCHEDULER_JOBSD.DBA_SCHEDULER_JOB_LOG
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 belongsB. Increasing the job‘s relative priority within the Job class to which it belongsC. Increasing the resource allocation for the consumer group mapped to the scheduler job‘s job class within the plan mapped to the scheduler windowD. Moving the job to an existing higher priority scheduler window with the same schedule and durationE. Increasing the value of the JOB_QUEUE_PROCESSES parameterF. Increasing the priority of the scheduler window to which the job belongs
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 accountD．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.
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？（）A、 Oracle Scheduler would write detailed information to the job log for each run of each job in the job class.B、 Oracle Scheduler would write detailed information to the job log for the first run of each job in the job class.C、 Oracle Scheduler would write detailed information to the job log for each run of only the first job in the job class.D、 Oracle Scheduler would write detailed information for all operations performed on all jobs in the job class.
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？（） A、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（log_history = 5， job_name = ’JOB1’）；B、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history = 5， job_name = ’JOB_LOG’）；C、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history = 5， which_log = ’JOB1’）；D、 EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history = 5， which_log =’JOB_LOG’）；
Which view will you use to view information regarding the jobs that are currently running in a database？（）A、DBA_SCHEDULER_RUNNING_JOBSB、DBA_SCHEDULER_JOB_RUN_DETAILSC、DBA_SCHEDULER_JOBSD、DBA_SCHEDULER_JOB_LOG
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？ （）A、The DBMS_JOB packageB、The BACKUP_JOB packageC、The DBMS_BACKUP_RESTORE packageD、The calendar tool in the Operating System （OS）E、The backup scheduler in Enterprise Manager （EM）F、The DBMS_BACKUP_SCHEDULER packager inline mode
You are unable to move the Unified Job Scheduler occupant from the SYSAUX tablespace to the USERS tablespace. What could be the reason？（）A、None of the SYSAUX occupants can be relocated.B、The USERS tablespace is a bigfile tablespace （BFT）.C、The united Job Scheduler occupant cannot be relocated.D、The SYSAUX occupants can be relocated to the SYSTEM tablespace only.
You are creating a job class. You have issued the following command to create the job class： SQL BEGIN DBMS_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 = ’LOW JOB PRIORITY CLASS’）； END； SQL / What will be the result of the above command？（）A、 The command will be executed successfully.B、 The command will fail because RESOURCE_CONSUMER_GROUP is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.C、 The command will fail because LOGGING_LEVEL is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.D、 The command will fail because LOG_HISTORY is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.E、 The command will fail because 1200 is an invalid value for the LOG_HISTORY parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）A、 DBA_SCHEDULER_JOB_RUN_DETAILSB、 DBA_SCHEDULER_RUNNING_JOBSC、 DBA_SCHEDULER_JOBSD、 DBA_SCHEDULER_JOB_LOG
Which Scheduler view（s） can be queried to see which jobs are currently executing？（）A、 DBA_SCHEDULER_JOB_RUN_DETAILSB、 DBA_SCHEDULER_RUNNING_JOBSC、 DBA_SCHEDULER_CURRENT_JOBSD、 DBA_SCHEDULER_JOBSE、 DBA_SCHEDULER_EXECUTING_JOBS
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 belongsB、Increasing the job's relative priority within the Job class to which it belongsC、Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler windowD、Moving the job to an existing higher priority scheduler window with the same schedule and durationE、Increasing the value of the JOB_QUEUE_PROCESSES parameterF、Increasing the priority of the scheduler window to which the job belongs
多选题Which Scheduler view(s) can be queried to see which jobs are currently executing? （）ADBA_SCHEDULER_JOB_RUN_DETAILSBDBA_SCHEDULER_RUNNING_JOBS DBACDBA_SCHEDULER_CURRENT_JOBSDDBA_SCHEDULER_JOBS DBAEDBA_SCHEDULER_EXECUTING_JOBS
单选题You are creating a job class. You have issued the following command to create the job class： SQL BEGIN DBMS_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 = ’LOW JOB PRIORITY CLASS’）； END； SQL / What will be the result of the above command？（）A The command will be executed successfully.B The command will fail because RESOURCE_CONSUMER_GROUP is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.C The command will fail because LOGGING_LEVEL is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.D The command will fail because LOG_HISTORY is an invalid parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.E The command will fail because 1200 is an invalid value for the LOG_HISTORY parameter in the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure.
单选题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？（）A EXECUTE DBMS_SCHEDULER.PURGE_LOG（log_history = 5， job_name = ’JOB1’）；B EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history = 5， job_name = ’JOB_LOG’）；C EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history = 5， which_log = ’JOB1’）；D EXECUTE DBMS_SCHEDULER.PURGE_LOG（ log_history = 5， which_log =’JOB_LOG’）；
单选题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？（）A Oracle Scheduler would write detailed information to the job log for each run of each job in the job class.B Oracle Scheduler would write detailed information to the job log for the first run of each job in the job class.C Oracle Scheduler would write detailed information to the job log for each run of only the first job in the job class.D Oracle Scheduler would write detailed information for all operations performed on all jobs in the job class.
单选题You work as a database administrator for Supportcenter.cn. You want to configure database backups to be run automatically. Which tool or utility would you use to achieve this？（）AThe DBMS_JOB packageBThe BACKUP_JOB packageCThe DBMS_BACKUP_RESTORE packageDThe calendar tool in the Operating System （OS）EThe backup scheduler in Enterprise Manager （EM）FThe DBMS_BACKUP_SCHEDULER packager inline mode
多选题Which Scheduler view（s） can be queried to see which jobs are currently executing？（）ADBA_SCHEDULER_JOB_RUN_DETAILSBDBA_SCHEDULER_RUNNING_JOBSCDBA_SCHEDULER_CURRENT_JOBSDDBA_SCHEDULER_JOBSEDBA_SCHEDULER_EXECUTING_JOBS
单选题You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job？（）A DBA_SCHEDULER_JOB_RUN_DETAILSB DBA_SCHEDULER_RUNNING_JOBSC DBA_SCHEDULER_JOBSD DBA_SCHEDULER_JOB_LOG
单选题You can change your job, you can move house, but friendship is meant to be ______ life.AofBonCtoDfor
多选题Identify four uses of the Oracle Scheduler.（）Aenables Oracle database to schedule which processes execute on which processors in a multiple CPU environmentBenables Oracle database to do patches according to a DBA-defined scheduleCenables you to schedule the execution of jobs based on timeDenables you to execute jobs in a clustered environmentEenables you to periodically execute operating systemscript files located on the same server as the databaseFenables you to create a job that makes use of saved programs and schedulesGenables you to automate the management of the jobs that are created using the DBMS_JOB package
单选题You are the network administrator for You manage a Windows Server 2003 computer named TestKing1. There are multiple scheduled tasks configure on TestKing1. One task is a scheduled backup job. You need to temporarily disable the backup job from running so that you can troubleshoot a problem. You must not interfere with any other scheduled tasks. You need to disable the scheduled backup job. You want to achieve this goal by using the minimum amount of administrative effort. What should you do?（）APause the Task Scheduler service.BDelete the scheduled backup job. Re-create the backup after you finish troubleshooting.CModify the properties of the scheduled backup job and clear the Enabled check box.DRun the ntbackup /p command on the server.
单选题Which view will you use to view information regarding the jobs that are currently running in a database？（）ADBA_SCHEDULER_RUNNING_JOBSBDBA_SCHEDULER_JOB_RUN_DETAILSCDBA_SCHEDULER_JOBSDDBA_SCHEDULER_JOB_LOG
多选题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?（）AIncreasing the priority of the job class to which the job belongsBIncreasing the job's relative priority within the Job class to which it belongsCIncreasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler windowDMoving the job to an existing higher priority scheduler window with the same schedule and durationEIncreasing the value of the JOB_QUEUE_PROCESSES parameterFIncreasing the priority of the scheduler window to which the job belongs