To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used?()A. LOG_HISTORYB. JOB_LOG_RETENTIONC. WINDOW_LOG_RETENTIOND. WHICH_LOGE. LOG_NAME

题目

To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used?()

A. LOG_HISTORY

B. JOB_LOG_RETENTION

C. WINDOW_LOG_RETENTION

D. WHICH_LOG

E. LOG_NAME

更多“To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used?() ”相关问题

第1题

Youarecreatingajobclass.Youwantaccesstothedetailedinformationforalltherunsofeachjobintheclassandeveryoperationperformedoneveryjobintheclass.WhichsettingwillyouusefortheLOGGING_LEVELparameter?()A.LOGGING_OFFB.LOGGING_RUNSC.LOGGING_FULLD.LOGGING_NULL

点击查看答案
第2题

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’）；

点击查看答案
第3题

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.

点击查看答案
第4题

When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?()A. SET_JOB_ARGUMENT_VALUEB. SET_JOB_VALUE_ANYDATAC. SET_JOB_ANYDATA_VALUED. SET_SPECIAL_JOB_VALUEE. SET_JOB_ANYTYPE_VALUE

点击查看答案
第5题

Examine the following command;ALTER SYSTEM SET enable_ddl_logging = TRUE;Which statement is true?()A. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.B. All DDL commands are logged in the alert log file.C. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.D. Only DDL commands that resulted in the creation of new segments are logged.E. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.

点击查看答案
第6题

Examine the following query output:You issue the following command to import tables into the hr schema:$ > impdp hr/hr directory = dumpdir dumpfile = hr_new.dmp schemas=hrTRANSFORM=DISABLE_ARCHIVE_LOGGING: YWhich statement is true?（）A. All database operations performed by the impdp command are logged.B. Only CREATE INDEX and CREATE TABLE statements generated by the import are logged.C. Only CREATE TABLE and ALTER TABLE statements generated by the import are logged.D. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

点击查看答案
第7题

Examine the following command:ALTER SYSTEM SET enable_ddl_logging=FALSE;Which statement is true?()A. None of the data definition language (DDL) statements are logged in the trace file.B. Only DDL commands that resulted in errors are logged in the alert log file.C. A new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.D. Only DDL commands that resulted in the creation of new database files are logged.

点击查看答案

To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used?()

题目

更多“To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure need to be used?() ”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容