多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

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
答案解析:
进入题库查看解析

微信扫一扫手机做题