（多选题）
The session of user SCOTT receives the following error after executing an UPDATE command onthe EMP table： ERROR at line 1： ORA-00060： deadlock detected while waiting for resource On investigation， you find that a session opened by user JIM has a transaction that caused the deadlock. two statements are true regarding the session of SCOTT in this scenario（）
AThe session is terminated after receiving the error and JIM can continue with his transaction.
BSCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
CThe session is rolled back after receiving the error and JIM can continue with his transaction.
DSCOTT has to reexecute the last command in the transaction after he commits the transaction.
正确答案
答案解析
略
相似试题
（单选题）
You discover an out-of-space condition in the database. You decide to suspend a session for five minutes. You issue the following command to suspend the session： ALTER SESSION ENABLE RESUMABLE； Which command could you issue to enable the resumable space allocation feature at the session level？（）
（单选题）
You execute the following command to enable a session in resumable mode： SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60； What is the impact of a timeout on the statements being suspended？（）
（单选题）
You execute the following command to enable a session in resumable mode： SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60； What is the impact of a timeout on the statements being suspended？（）
（单选题）
You executed the following commands in an RMAN session for your database instance that has failures： RMAN> LIST FAILURE； After some time， you executed the following command in the same session： RMAN> ADVISE FAILURE； But there are new failures recorded in the Automatic Diagnostic Repository （ADR） after the execution ofthe last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario（）
（单选题）
Given： What creates the appropriate DateFormat object and adds a day to the Date object？（）
（单选题）
Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command： LSNRCTL> STOP What would happen to the sessions that are presently connected to the database instance？（）
（单选题）
Your database is open and users are connected using the LISTENER listener. The new DBA of the system stops the listener by using the following command： LSNRCTL> STOP What would happen to the sessions that are presently connected to the database instance？（）
（单选题）
Which statement is true regarding the effect of this command on the transaction in Scott’s session（）
（多选题）
Given： Which two statements are true about the result if the default locale is Locale.US？（）
（单选题）
You created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL> DROP PROFILE app_user； Which statement describes the result（）
