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.
正确答案:C
答案解析:有

微信扫一扫手机做题