Oracle
1Z0-062 · Question #379
1Z0-062 Question #379: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #379. The question stem and answer options stay visible for context.
Managing Data and Concurrency
Question
Examine these statements: DESC emp INSERT INTO emp VALUES ( 101, 'John', 12000); 1 row created. SAVEPOINT after_insert; Savepoint created. UPDATE emp SET salary=16000 WHERE empno=101; 1 row updated. SAVEPOINT after_update; Savepoint created. DELETE FROM emp WHERE empno=101; 1 row deleted. SAVEPOINT after_delete; Savepoint created. ROLLBACK TO SAVEPOINT after_update; Rollback complete. INSERT INTO emp VALUES ( 102, 'Emma', 12000); ROLLBACK TO SAVEPOINT after_delete; Which is the result and effect of this ROLLBACK?
Exhibit
Options
- AThe ROLLBACK backs out all DMLS before after_delete.
- BThe ROLLBACK backs out all DMLS until after_delete.
- CThe ROLLBACK throws an error.
- DThe ROLLBACK executes successfully but does not back out any DMLS.
Unlock 1Z0-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#SAVEPOINT#ROLLBACK TO SAVEPOINT#DML#transactions