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

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

微信扫一扫手机做题