---

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（）
A:It fails to delete the records because the records are locked in SHARE mode.
B:It deletes the rows successfully because the table is locked in SHARE mode
C:It fails to delete the records because the table is locked in EXCLUSIVE mode.
D:It deletes the rows successfully because the table is locked in SHARE ROW EXCLUSIVE mode.

---

出自：Oracle认证

显示答案