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、ex

题目

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

相似考题
更多“Your alert log f”相关问题
  • 第1题:

    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

  • 第2题:

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

    • A、alert("HelloWorld")
    • B、console.log("HelloWorld")
    • C、document.log("HelloWorld")
    • D、document.write("HelloWorld")

    正确答案:D

  • 第3题:

    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

  • 第4题:

    When you try to open your database, you receive the following error:  ORA-00205: error in identifying control file   Where would you find the details required to resolve this error?()

    • A、audit trail
    • B、alert log file
    • C、user trace file
    • D、online trace file
    • E、background trace file
    • F、operating system event viewer

    正确答案:B

  • 第5题:

    In your database, the Log Writer (LGWR) process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database?()

    • A、The database instance aborts.
    • B、The database operation temporarily halts till the member becomes available.
    • C、Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.
    • D、The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.
    • E、The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.

    正确答案:C,D

  • 第6题:

    You work as a database administrator for Supportcenter.cn. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this.Which initialization parameter gives you the location of the alert log file?()

    • 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

  • 第7题:

    单选题
    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.


    正确答案: C
    解析: 暂无解析

  • 第8题:

    单选题
    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
    解析: 暂无解析

  • 第9题:

    单选题
    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


    正确答案: A
    解析: 暂无解析

  • 第10题:

    单选题
    You work as a database administrator for Supportcenter.cn. You determine that archiving was not successful in one of thedestinators. You want to check the alert log file for more information on this.Which initialization parameter gives you the location of the alert log file?()
    A

    USER_DUMP_DEST

    B

    CORE_DUMP_DEST

    C

    ALERT_LOG_DEST

    D

    ALERT_DUMP_DEST

    E

    TRACE_DUMP_DEST

    F

    BACKGROUND_DUMP_DEST


    正确答案: D
    解析: 暂无解析

  • 第11题:

    单选题
    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.


    正确答案: D
    解析: 暂无解析

  • 第12题:

    单选题
    You are one of the network administrators for your company. All network servers run Windows Server 2003. Your company operates a total of four offices. The office where you work has 15 servers. You are responsible for supporting and maintaining all of these servers. You need to design a monitoring plan that will achieve the following goals: Track all performance changes on the servers. Record performance data to anticipate the need for future upgrades. What should you do? ()
    A

    On each server in your office, use Performance Logs and Alers to create a baseline log. Configure the log to collect data every five minutes for one day. Use the same counters for each server to create a log file. Schedule the log to run weekly.

    B

    From a monitoring computer, use Performance Logs and Alerts to create a baseline log for each server in your office. Configure the log to collect data every five minutes for one day. Use the same counters for each server to create a log file. Schedule the log to run weekly.

    C

    On each server in your office, use Performance Logs and Alerts to create threshold-based alerts. Configure the alerts to send a message to your monitoring computer when they are triggered. Set each alert to start a new scan when the alert finishes.

    D

    From a monitoring computer use Performance Logs and Alerts to create a new counter set in System Monitor. Configure the counters to run continuously.


    正确答案: B
    解析: 暂无解析

  • 第13题:

    在JavaScript中,输出不到网页的是()。

    • A、document.write()
    • B、console.log()
    • C、alert()
    • D、document.log()

    正确答案:B,C,D

  • 第14题:

    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

  • 第15题:

    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

  • 第16题:

    Examine the values for the following initialization parameters: FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database()

    • A、The SGA advisor will be disabled.
    • B、The MTTR advisor will be disabled.
    • C、Automatic checkpoint tuning will be disabled.
    • D、Checkpoint information will not be written to the alert log file.

    正确答案:B,C

  • 第17题:

    You are working on a database, where you have three redo log groups. When the database is down for a backup, an operating system (OS) user deletes all the redo log files in a group. What will happen when you open your database?()

    • A、 The instance starts, the database is mounted, but efforts to open the database fail, and an error about the missing redo log group is displayed.
    • B、 Before the instance starts, you receive an error about the missing redo log files of a group.
    • C、 The instance starts and the database opens with an error message written to the alert log file.
    • D、 The instance starts and the database opens because two redo log groups still exist.
    • E、 The instance starts and the database opens, but every attempt to write to redo log files fails with an error.

    正确答案:A

  • 第18题:

    You are one of the network administrators for All network servers run Windows Server 2003. TestKing operates a total of four offices. The office where you work has 15 servers. You are responsible for supporting and maintaining all of these servers. You need to design a monitoring plan that will achieve the following goals: 1. Track all performance changes on the servers. 2. Record performance data to anticipate the need for future upgrades. What should you do?()

    • A、On each server in your office, use Performance Logs and Alerts to create a baseline log. Configure the log to collect data every five minutes for one day. Use the same counters for each server to create a log file. Schedule the log to run weekly.
    • B、From a monitoring computer, use Performance Logs and Alerts to create a baseline log for each server in your office. Configure the log to collect data every five minutes for one day. Use the same counters for each server to create a log file. Schedule the log to run weekly.
    • C、On each server in your office, use Performance Logs and Alerts to create threshold-based alerts. Configure the alerts to send a message to your monitoring computer when they are triggered. Set each alert to start a new scan when the alert finishes.
    • D、From a monitoring computer use Performance Logs and Alerts to create a new counter set in System Monitor. Configure the counters to run continuously.

    正确答案:B

  • 第19题:

    单选题
    You are working on a database, where you have three redo log groups. When the database is down for a backup, an operating system (OS) user deletes all the redo log files in a group. What will happen when you open your database?()
    A

     The instance starts, the database is mounted, but efforts to open the database fail, and an error about the missing redo log group is displayed.

    B

     Before the instance starts, you receive an error about the missing redo log files of a group.

    C

     The instance starts and the database opens with an error message written to the alert log file.

    D

     The instance starts and the database opens because two redo log groups still exist.

    E

     The instance starts and the database opens, but every attempt to write to redo log files fails with an error.


    正确答案: C
    解析: 暂无解析

  • 第20题:

    单选题
    What is the implication of setting the initialization parameter FAST_START_MTTR_TARGET to 0 in your database?()
    A

    MTTR Advisor would be disabled.

    B

    Redo Log Advisor would be disabled.

    C

    Automatic tuning of checkpoint would be disabled.

    D

    Checkpoint information would not be written to the alert log file.


    正确答案: A
    解析: 暂无解析

  • 第21题:

    多选题
    Examine the values for the following initialization parameters: FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database()
    A

    The SGA advisor will be disabled.

    B

    The MTTR advisor will be disabled.

    C

    Automatic checkpoint tuning will be disabled.

    D

    Checkpoint information will not be written to the alert log file.


    正确答案: B,C
    解析: 暂无解析

  • 第22题:

    单选题
    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.


    正确答案: D
    解析: 暂无解析

  • 第23题:

    单选题
    You configured the Flash Recovery Area for your database. The database instance has been startedin ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set.  What will be the implications on the archiving and the location of archive redo log files()
    A

    Archiving will be disabled because the destination for the redo log files is missing.

    B

    The database instance will shut down and the error details will be logged in the alert log file.

    C

    Archiving will be enabled and the destination for the archived redo log file will be set to the FlashRecovery Area implicitly.

    D

    Archiving will be enabled and the location for the archive redo log file will be created in the defaultlocation $ORACLE_HOME/log.


    正确答案: A
    解析: 暂无解析

  • 第24题:

    多选题
    In your database, the Log Writer (LGWR) process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database?()
    A

    The database instance aborts.

    B

    The database operation temporarily halts till the member becomes available.

    C

    Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.

    D

    The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.

    E

    The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.


    正确答案: B,C
    解析: 暂无解析