Identify two situations in which the alert log file is updated.() A. Running a query on a table returns ORA-600: Internal Error.B. Inserting a value into a table returns ORA-01722: invalid number.C. Creating a table returns ORA-00955: name us already in used by an existing objects.D. Inserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated.E. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.

Identify two situations in which the alert log file is updated.()

A. Running a query on a table returns ORA-600: Internal Error.

B. Inserting a value into a table returns ORA-01722: invalid number.

C. Creating a table returns ORA-00955: name us already in used by an existing objects.

D. Inserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated.

E. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.


相关考题:

Whenperformingadatabaseduplication,whichduplicatedatabaseparameterwouldyousettoensurethattheonlineredologsarecreatedinthecorrectlocation?() A.log_file_name_convertB.convert_log_file_nameC.file_name_convert_logD.redo_log_file_name_convertE.logfile_convert_directory

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?() A. LOG_HISTORYB. JOB_LOG_RETENTIONC. WINDOW_LOG_RETENTIOND. WHICH_LOGE. LOG_NAME

YouworkasadatabaseadministratorforSupportcenter.cn.Youdeterminethatarchivingwasnotsuccessfulinoneofthedestinators.Youwanttocheckthealertlogfileformoreinformationonthis.Whichinitializationparametergivesyouthelocationofthealertlogfile?()A.USER_DUMP_DESTB.CORE_DUMP_DESTC.ALERT_LOG_DESTD.ALERT_DUMP_DESTE.TRACE_DUMP_DESTF.BACKGROUND_DUMP_DEST

Youdecidedtoconfiguretheflashrecoveryareainyourdatabasetocentralizethestorageofalltherecoveryfilesinacertainlocationondisk.Whichtwoparameterswillyouspecifyintheinit.orafile?() A.DB_CREATE_FILE_DESTB.DB_RECOVERY_FILE_DESTC.DB_RECOVERY_FILE_DEST_SIZED.DB_ONLINE_LOG_DEST_n

YouworkasadatabaseadministratorforCertkiller.com.Youdeterminethatarchivingwasnotsuccessfulinoneofthedestinators.Youwanttocheckthealertlogfileformoreinformationonthis.Whichinitializationparametergivesyouthelocationofthealertlogfile?()A.USER_DUMP_DESTB.CORE_DUMP_DESTC.ALERT_LOG_DESTD.ALERT_DUMP_DESTE.TRACE_DUMP_DESTF.BACKGROUND_DUMP_DEST

YouareworkingontheCertkillerdatabase.Whatisthedefaultnameofthealertlogfileinthisdatabase?() A.alert_Certkiller.logB.alertlog_Certkiller.logC.alert_log_Certkiller.logD.Certkiller_alert_log.logE.log_alert_:Certkiller.logF.trace_alert_Certkiller.log

What is the primary syslog file?() A./var/syslog-fileB./var/syslogC./var/log/messagesD./log-file

Examinethefollowingparametersettingsfromaninitialization(init.ora)file:DB_CREATE_FILE_DEST=’/u01/oradata/’DB_CREATE_ONLINE_LOG_DEST_1=’/u02/oradata/’DB_CREATE_ONLINE_LOG_DEST_2=’/u03/oradata/’IfyoucreateanOracleManagedFiles(OMF)databaseusingthesesettings,whatistheresult?()A.AB.BC.CD.D

WhichthreeinitializationparametersarenolongerneededwhenFAST_START_MTTR_TARGETisdefined?() A.TARGET_REDO_BLKSB.FAST_START_IO_TARGETC.LOG_CHECKPOINT_TIMEOUTD.RECOVERY_ESTIMATED_IOSE.LOG_FILE_SIZE_REDO_BLKSF.LOG_CHECKPOINT_INTERVAL