Oracle
1Z0-052 · Question #35
User A executes the following command to drop a large table in your database: SQL> DROP TABLE trans; While the drop table operation is in progress; user B executes the following command on the same ta
Sign in or unlock 1Z0-052 to reveal the answer and full explanation for question #35. The question stem and answer options stay visible for context.
Managing Data and Concurrency
Question
User A executes the following command to drop a large table in your database:
SQL> DROP TABLE trans; While the drop table operation is in progress; user B executes the following command on the same table; SQL> DELETE FROM trans WHERE tr_type='SL'; Which statement is true regarding the DELETE command?
Options
- AIt fails to delete the records because the records are locked in the SHARE mode
- BIt deletes the rows successfully because the table is locked in the SHARE mod
- CIt fails to delete the records because the table is locked in EXCLUSIVE mode
- DIt deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode
Unlock 1Z0-052 to see the answer
You've previewed enough free 1Z0-052 questions. Unlock 1Z0-052 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
#DDL locks#EXCLUSIVE lock#DROP TABLE concurrency#lock conflicts