Oracle
1Z0-052 · Question #35
1Z0-052 Question #35: Real Exam Question with Answer & Explanation
The correct answer is C: It fails to delete the records because the table is locked in EXCLUSIVE mode. See the full explanation below for the reasoning.
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
Community Discussion
No community discussion yet for this question.