可学答题网 > 问答 > 1Z0-052题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

View the Exhibit and&e


View the Exhibit and examine the parameters. User A executes the following command to update the TRANStable: SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’; Before user A issues a COMMIT orROLLBACK 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()

  • AThe ALTER TABLE command modifies the column successfully.
  • BThe DDL operation gets higher priority and transaction for user A is rolled back.
  • CThe ALTER TABLE command waits indefinitely until user A ends the transaction.
  • DThe ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy
参考答案
参考解析:
分类:1Z0-052题库
相关推荐

1、View the Exhibit and&e

View the Exhibit and examine the Flashback SCNs. A user has inserted wrong department data&ensp...

2、View the Exhibit and&e

View the Exhibit and examine the parameters.User A executes the following command to update the...

3、View the Exhibit and&e

View the Exhibit and examine the properties of the TT tablespace. Using Database Control, you&...

4、View the Exhibit and&e

View the Exhibit and examine the structure of the ORDERS table.Which task would require subquer...

5、View the Exhibit and&e

View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the&...

6、View the Exhibit and&e

View the Exhibit and examine the structure of the EMP table.You executed the following command&...