违法和不良信息举报 联系客服
免费注册 登录

Your alert log f

题目

Your alert log file has the following information： Tue May 25 17：43：38 2004  ORA-00060： Deadlock detected. More info in file  /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc.  What would you do to ensure that database is still running correctly？（）

  • A、examine the trace file and kill the session that caused the deadlock
  • B、examine the trace file and kill both the sessions responsible for the deadlock
  • C、examine the trace file for details and ask the user who caused the deadlock to roll back the transaction
  • D、examine the trace file for details and remember that deadlocks are resolved automatically by Oracle database
  • E、examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock
参考答案和解析
正确答案:D
如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第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题：

Your archive-log destination directory runs out of space. What is the impact of this on the database？（）  

  • A、 None. The database will switch over to the stand-by archive-log destination directory.
  • B、 A warning message will be written to the alert log of the database，but no adverse impacts to the database will be experienced.
  • C、 The database will shut down，and will not restart until you correct the out-of-space situation.
  • D、 The database will continue to try to write to the archive-log destination directory for one hour. After one hour，the database will shut down normally.
  • E、 Once Oracle has cycled through all online redo logs，it will stop processing any DML or DDL until the out-of-space condition is corrected.

正确答案:E

第3题：

View the Exhibit and note the contents of V$DIAG_INFO. Which statement is true about the ADR?()

A. The text alert log file will be available in Diag Trace

B. A copy alert log file will be kept in Diag Incident for every incident.

C. The XML version of the alert log file will be available in Diag Trace.

D. An Automatic Database Diagnostic Management (ADDM) report is generated and stored in the Health Monitor whenever an incident occurs.


参考答案：A

第4题：

You are working on the Certkiller database.  What is the default name of the alert log file in this database？（）

  • A、alert_ Certkiller .log
  • B、alertlog_ Certkiller .log
  • C、alert_log_ Certkiller .log
  • D、Certkiller _alert_log.log
  • E、log_alert_： Certkiller .log
  • F、trace_alert_ Certkiller .log

正确答案:A

第5题：

在网页页面上输出"HelloWorld"的正确Javascript语法是（）。

  • A、alert（"HelloWorld"）
  • B、console.log（"HelloWorld"）
  • C、document.log（"HelloWorld"）
  • D、document.write（"HelloWorld"）

正确答案:D

第6题：

YouareworkingontheCertkillerdatabase.Whatisthedefaultnameofthealertlogfileinthisdatabase?()

A.alert_Certkiller.log

B.alertlog_Certkiller.log

C.alert_log_Certkiller.log

D.Certkiller_alert_log.log

E.log_alert_：Certkiller.log

F.trace_alert_Certkiller.log


参考答案：A

第7题：

在JavaScript中，输出不到网页的是（）。

  • A、document.write（）
  • B、console.log（）
  • C、alert（）
  • D、document.log（）

正确答案:B,C,D

第8题：

YouworkasadatabaseadministratorforSupportcenter.cn.Youdeterminethatarchivingwasnotsuccessfulinoneofthedestinators.Youwanttocheckthealertlogfileformoreinformationonthis.Whichinitializationparametergivesyouthelocationofthealertlogfile？（）

A.USER_DUMP_DEST

B.CORE_DUMP_DEST

C.ALERT_LOG_DEST

D.ALERT_DUMP_DEST

E.TRACE_DUMP_DEST

F.BACKGROUND_DUMP_DEST


参考答案：F

第9题：

A junior level Database Administrator erroneously deleted the database alert log while users were accessing the database. Which action should you take to recover the alert log？（）  

  • A、 Do nothing.
  • B、 Restart the database.
  • C、 Perform recovery on the database.
  • D、 Restore the alert log from the last backup.

正确答案:A

第10题：

You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

  • A、 online redo log files
  • B、 alert log files
  • C、 control file
  • D、 datafiles associated with the SYSTEM tablespace

正确答案:C

更多相关问题
相关内容