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（）
- AIt fails to delete the records because the records are locked in SHARE mode.
- BIt deletes the rows successfully because the table is locked in SHARE mode
- 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.