单选题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？（）Aexamine the trace file and kill the session that caused the deadlockBexamine the trace file and kill both the sessions responsible for the deadlockCexamine the trace file for details and ask the user who caused the deadlock to roll back the transactionDexamine the trace file for details and remember that deadlocks are resolved automatically by Oracle databaseEexamine 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 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
参考解析
解析：
暂无解析
相关考题：
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？（）Aalert_ Certkiller .logBalertlog_ Certkiller .logCalert_log_ Certkiller .logDCertkiller _alert_log.logElog_alert_： Certkiller .logFtrace_alert_ Certkiller .log
单选题What is the implication of setting the initialization parameter FAST_START_MTTR_TARGET to 0 in your database？（）AMTTR Advisor would be disabled.BRedo Log Advisor would be disabled.CAutomatic tuning of checkpoint would be disabled.DCheckpoint 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？（）Athe 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？（）ARMAN keeps a list of archive logs in a text file.BThe DBA must manually tell RMAN which archive logs to backup.CRMAN has access to target control file and/or catalog information.DRMAN 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
单选题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？（）AUSER_DUMP_DESTBCORE_DUMP_DESTCALERT_LOG_DESTDALERT_DUMP_DESTETRACE_DUMP_DESTFBACKGROUND_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?（）AOnly the data definition language (DDL) commands that resulted in errors are logged in the alert log file.BAll DDL commands are logged in the alert log file.CAll DDL commands are logged in a different log file that contains DDL statements and their execution dates.DOnly DDL commands that resulted in the creation of new segments are logged.EAll 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?（）ANone of the data definition language (DDL) statements are logged in the trace file.BOnly DDL commands that resulted in errors are logged in the alert log file.CA new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.DOnly 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（）AArchiving will be disabled because the destination for the redo log files is missing.BThe database instance will shut down and the error details will be logged in the alert log file.CArchiving will be enabled and the destination for the archived redo log file will be set to the FlashRecovery Area implicitly.DArchiving 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? （）AOn 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.BFrom 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.COn 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.DFrom 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.