网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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 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 deadlockB examine the trace file and kill both the sessions responsible for the deadlockC examine the trace file for details and ask the user who caused the deadlock to roll back the transactionD examine the trace file for details and remember that deadlocks are resolved automatically by Oracle databaseE examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock” 相关考题
考题 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.

考题 Which two statements are true regarding trace options on Junos devices?()A、You can see the contents of the log file by entering the show log filename commandB、Trace options will send information to your screen automaticallyC、Trace options are limited to one protocol at a timeD、The file name and set of flags may be specified when enabling trace options

考题 Where do you find information about a missing redo log file?()A、trace fileB、audit trailC、control fileD、alert log fileE、event viewer

考题 An administrator suspects someone is modifying a sensitive file, and wants to log access information for this file. Which of the following AIX component accomplishes this?()A、auditB、syslogC、TCBD、sysck

考题 Which two statements are true regarding trace options on Junos devices?()A、You can see the contents of the log file by entering the show log filename command.B、Trace options will send information to your screen automatically.C、Trace options are limited to one protocol at a time.D、The file name and a set of flags may be specified when enabling traceoptions.

考题 You are working on the Certkiller database.  What is the default name of the alert log file in this database?()A、alert_ Certkiller .logB、alertlog_ Certkiller .logC、alert_log_ Certkiller .logD、Certkiller _alert_log.logE、log_alert_: Certkiller .logF、trace_alert_ Certkiller .log

考题 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 filesB、 alert log filesC、 control fileD、 datafiles associated with the SYSTEM tablespace

考题 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 trailB、alert log fileC、user trace fileD、online trace fileE、background trace fileF、operating system event viewer

考题 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.

考题 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.

考题 You received the following error:   ORA-01578: ORACLE data block corrupted   (file # %s, block # %s)   Which file will you check to view additional information regarding the cause of this error?()A、the alert log file and the trace filesB、 the redo log filesC、 the control fileD、 the change tracking file

考题 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_DESTB、CORE_DUMP_DESTC、ALERT_LOG_DESTD、ALERT_DUMP_DESTE、TRACE_DUMP_DESTF、BACKGROUND_DUMP_DEST

考题 What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File?() A、The filename format. B、Information stored inside a data dictionary table. C、Information stored in the ALERT.LOG file for the corresponding instance. D、Information stored inside the corresponding initialization parameter file for the instance.

考题 单选题You are working on the Certkiller database.  What is the default name of the alert log file in this database?()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 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.

考题 单选题You received the following error:   ORA-01578: ORACLE data block corrupted   (file # %s, block # %s)   Which file will you check to view additional information regarding the cause of this error?()A the alert log file and the trace filesB  the redo log filesC  the control fileD  the change tracking file

考题 单选题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 filesB  alert log filesC  control fileD  datafiles associated with the SYSTEM tablespace

考题 多选题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()AThe SGA advisor will be disabled.BThe MTTR advisor will be disabled.CAutomatic checkpoint tuning will be disabled.DCheckpoint information will not be written to the alert log file.

考题 单选题When you are allowing RMAN to backup your archived redo log files,how does RMAN know which archived redo logs to back up from your archive log destination?()A RMAN keeps a list of archive logs in a text file.B The DBA must manually tell RMAN which archive logs to backup.C RMAN has access to target control file and/or catalog information.D RMAN looks at the ARCHIVE_LOG_DEST parameter of your target database and backs up all archive logs found.

考题 多选题Which two statements are true regarding trace options on Junos devices?()AYou can see the contents of the log file by entering the show log filename commandBTrace options will send information to your screen automaticallyCTrace options are limited to one protocol at a timeDThe file name and set of flags may be specified when enabling trace options

考题 单选题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 deadlockB examine the trace file and kill both the sessions responsible for the deadlockC examine the trace file for details and ask the user who caused the deadlock to roll back the transactionD examine the trace file for details and remember that deadlocks are resolved automatically by Oracle databaseE examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock

考题 单选题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_DESTB CORE_DUMP_DESTC ALERT_LOG_DESTD ALERT_DUMP_DESTE TRACE_DUMP_DESTF BACKGROUND_DUMP_DEST

考题 多选题Which two statements are true regarding trace options on Junos devices?()AYou can see the contents of the log file by entering the show log filename command.BTrace options will send information to your screen automatically.CTrace options are limited to one protocol at a time.DThe file name and a set of flags may be specified when enabling traceoptions.

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

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

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

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

考题 多选题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?()AThe database instance aborts.BThe database operation temporarily halts till the member becomes available.CWriting proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.DThe member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.EThe status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.