The session of user SCOTT receives the following error after executing an UPDATE command on the 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.
Which two statements are true regarding the session of SCOTT in this scenario? (Choose two.)

• A. SCOTT should perform a COMMIT or ROLLBACK to allow JIM to continue with his transaction.
• B. The session is terminated after receiving the error and JIM can continue with his transaction.
• C. The session is rolled back after receiving the error and JIM can continue with his transaction.
• D. SCOTT has to reexecute the last command in the transaction after he commits the transaction.

SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;
What is the effect of this command?

• A. One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session
• B. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users
• C. One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully
• D. One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT
• E. One audit record is created for every successful DROP TABLE command executed in the session of SCOTT

You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance failure.
Which statement is true in this situation?

• A. The uncommitted transaction is rolled back automatically at the next opening of the database
• B. The DBA has to perform the recovery on the database to recover the uncommitted transaction
• C. The online redo log files and archived redo log files are required to accomplish the recovery
• D. The uncommitted transaction will be committed at the next startup of the database instance

User SCOTT executes the following command on the EMP table but has not issued COMMIT, ROLLBACK, or any data definition language (DDL) command:
SQL> SELECT ename FROM emp
2 WHERE job='CLERK' FOR UPDATE OF empno;
SCOTT has opened another session to work with the database instance.
Which three operations would wait when issued in SCOTT's second session? (Choose three.)

• A. INSERT INTO emp(empno,ename) VALUES (1289,'Harry');
• B. LOCK TABLE emp IN EXCLUSIVE MODE;
• C. SELECT ename FROM emp WHERE job='CLERK' FOR UPDATE OF empno;
• D. LOCK TABLE emp IN SHARE MODE;
• E. UPDATE emp SET sal=sal*1.2 WHERE job='MANAGER'

Which two are true about consistent database backups? (Choose two.)

• A. They can only be taken if a NORMAL, TRANSACTIONAL, OR IMMEDIATE shutdown has been performed and the backup is taken before the database is reopened.
• B. They can only be taken by using RMAIN when the database is in MOUNT state.
• C. They can only be taken when a RECOVERY CATALOG is used.
• D. They can only be taken by using RMAN command.
• E. They can only be taken if the database is in ARCHIVELOG mode.

Explanation: Only visible for Actual4Labs members. You can sign-up / login (it's free).