1Z0-042
单选题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
examine the trace file and kill both the sessions responsible for the deadlock
examine the trace file for details and ask the user who caused the deadlock to roll back the transaction
examine the trace file for details and remember that deadlocks are resolved automatically by Oracle database
examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock
相似问题和答案
第1题：
The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping command executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following command:SQL >CONNECT scott/tiger@orcl What could be the reason for this?（）
A. The listener is not running on the database node.
B. The TNS_ADMIN environment variable is set to the wrong value.
C. The orcl.oracle.com database service is not registered with the listener.
D. The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.
E. The listener is running on a different port.
第2题：
Your database is open and running in ARCHIVELOG mode. You take RMAN full backups every Sunday night. On Monday morning， while querying the user1.employees table， you receive the following error message： 01578： ORACLE data block corrupted （file # 5， block # 51） ORA-01110： data file 5： ’/u01/app/oracle/oradata/orcl/example01.dbf’ You need to rectify the corruption while ensuring the following： The data file should remain online. The mean time to recover （MTTR） should be minimal. You are not using a backup control file， and all the archived logs are accessible. Which option would you choose？（）
- A、flash back the corrupted blocks
- B、use the DBMS_REPAIR package
- C、use the RMAN TSPITR command
- D、use the RMAN BLOCKRECOVER command
- E、use the RESTORE DATABASE and RECOVER DATABASE commands
- F、investigate the time at which the corruption occurred and perform a point-in-time recovery
正确答案:D
第3题：
A. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the image copy
B. The ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file is recovered from the last incremental backup
C. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are updated with all changes up to incremental backup SCN. ‘/ u01/app/oracle/oradata/orcl/users01.dbf
D. Image copies of the ‘/u01/app/oracle/oradata/orcl/users01.dbf‘ data file are recovered using the above command if data file recovery fails
第4题：
You executed the following command： RMAN> RECOVER COPY OF DATAFILE ’/u01/app/oracle/oradata/orcl/users01.dbf’； Which statement regarding the above command is correct？（）
- A、 The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the image copy.
- B、 The ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file is recovered from the last incremental backup.
- C、 Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are updated with all changes up to incremental backup SCN.
- D、 Image copies of the ’/u01/app/oracle/oradata/orcl/users01.dbf’ data file are recovered using the above command if data file recovery fails.
正确答案:C
第5题：
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
第6题：
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch? （）(Choose two.)
- A、An entry is created in the alert log file and the database instance continues to function normally
- B、The log switch hangs occur for transactions until free space is available in the flash recovery area
- C、The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area
- D、The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented
正确答案:B,C
第7题：
You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning， while querying the user1.employeestable， you receive the following error message： 01578： ORACLE data block corrupted （file # 5， block # 51） ORA-01110： data file 5：’/u01/app/oracle/oradata/orcl/example01.dbf’ You need to rectify the corruption while ensuring the following： The data file should remain online. The mean time to recover （MTTR） should be minimal. You are not using a backup control file and all the archived logs are accessible. Which option would you choose？（）
- A、 flash back the corrupted blocks
- B、 use the DBMS_REPAIR package
- C、 use the RMAN TSPITR command
- D、 use the RMAN BLOCKRECOVER command
- E、 use the RESTORE DATABASE and RECOVER DATABASE commands
- F、 investigate the time at which the corruption occurred and perform a point-in-time recovery
正确答案:D
第8题：
Youralertlogfilehasthefollowinginformation：TueMay2517：43：382004ORA-00060：Deadlockdetected.Moreinfoinfile/u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc.Whatwouldyoudotoensurethatdatabaseisstillrunningcorrectly？（）
A.examinethetracefileandkillthesessionthatcausedthedeadlock
B.examinethetracefileandkillboththesessionsresponsibleforthedeadlock
C.examinethetracefilefordetailsandasktheuserwhocausedthedeadlocktorollbackthetransaction
D.examinethetracefilefordetailsandrememberthatdeadlocksareresolvedautomaticallybyOracledatabase
E.examinethetracefilefordetailsandusetheUndoAdvisortorollbackthetransactionthatcausedthedeadlock
第9题：
Your tnsnames.ora file has the following entry for the service alias ORCL： ORCL = （DESCRIPTION = （ADDRESS = （PROTOCOL = TCP） （HOST = 10.156.24.216） （PORT = 1521）） （CONNECT_DATA = （SERVER = DEDICATED） （SERVICE_NAME = orcl.oracle.com） ） ） The TNSPING command executes successfully when tested with ORCL but you are not able to connect to the database instance with the following command： SQL> CONNECT scott/tiger@orcl What could be the reason for this？（）
- A、The listener is not running at the server.
- B、The TNS_ADMIN environmental variable is set to a wrong value.
- C、The orcl.oracle.com database service is not registered with the listener.
- D、The DEFAULT_DOMAIN parameter is set to a wrong value in the SQLNET.ORA file.
正确答案:C
第10题：
You executed the following command: RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'; Which statement regarding the above command is correct?（）
- A、The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy
- B、The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backup
- C、 Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN. '/ u01/app/oracle/oradata/orcl/users01.dbf
- D、Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails
正确答案:C