---

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 with a "Resource Busy" error.
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认证

显示答案