A. Schedule objects
B. Program arguments
C. Job classes
D. Job arguments
E. All of the above
第1题:
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’);
第2题:
A.DBA_SCHEDULER_RUNNING_JOBS
B.DBA_SCHEDULER_JOB_RUN_DETAILS
C.DBA_SCHEDULER_JOBS
D.DBA_SCHEDULER_JOB_LOG
第3题:
A. DBA_SCHEDULER_JOB_RUN_DETAILS
B. DBA_SCHEDULER_RUNNING_JOBS DBA
C. DBA_SCHEDULER_CURRENT_JOBS
D. DBA_SCHEDULER_JOBS DBA
E. DBA_SCHEDULER_EXECUTING_JOBS
第4题:
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.
第5题:
A. LOG_HISTORY
B. JOB_LOG_RETENTION
C. WINDOW_LOG_RETENTION
D. WHICH_LOG
E. LOG_NAME
第6题:
A.Compilationfails.
B.Anexceptionisthrownatruntime.
C.Thevariablefirstissettonull.
D.Thevariablefirstissettoelements[0].