单选题
Aexamine the trace file and kill the session that caused the deadlock
Bexamine the trace file and kill both the sessions responsible for the deadlock
Cexamine the trace file for details and ask the user who caused the deadlock to roll back the transaction
Dexamine the trace file for details and remember that deadlocks are resolved automatically by Oracle database
Eexamine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock
正确答案
答案解析
略
相似试题
A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）
单选题查看答案
You have lost all your database control files. To recover them， you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery？（）
单选题查看答案
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？（）
单选题查看答案
In your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. What isthe impact of this setting（）
单选题查看答案
in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impactof this setting（）
单选题查看答案
You issued the following statement in your SQL*Plus session： SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600； Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）
单选题查看答案
Your database is running in NOARCHIVELOG mode. Every night there is a backup taken using RMAN. During your startup this morning you received en error regarding DISK 3 on your server. This is the location of your data file for the SYSTEM tablespace. Which option is open to you？（）
单选题查看答案
You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set. How will you migrate your database from UTF8 to AL16UTF16？（）
单选题查看答案
You issue the following command： RMAN>CONFIGURE BACKUP OPTIMIZATION ON； What is the result of this command on your backups？（）
单选题查看答案