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

Oracle认证考试

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

User A executes the following command to update the TRANS table)  SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’;  Before user A issues a COMMIT or ROLLBACK command, user B executes the following command on the TRANS table:   SQl> ALTER TABLE trans MODIFY (tr_type VARCHAR2 (3));  What would happen in this scenario?()

  • A、The transaction for user A is rolled back.
  • B、The ALTER TABLE command modifies the column successfully.
  • C、The ALTER TABLE command fails due to the resource being busy.
  • D、The ALTER TABLE command waits until user A ends the transaction.
正确答案:C
答案解析:
进入题库查看解析

微信扫一扫手机做题