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

相似考题

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

2.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.

3.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

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

更多“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题：

    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.


    参考答案：B

  • 第2题：

    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.


    参考答案：A

  • 第3题：

    window对象包括location对象、history对象和document对象


    正确

  • 第4题：

    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.


    参考答案：A

  • 第5题：

    Whatkeywordsdoyouneedtotheaccess－listtoprovidetotheloggingmessagelikesourceaddressandsourcemacaddress?()

    A.Log

    B.Log-input

    C.Log-output

    D.Logging


    参考答案：B

相关内容