View the Exhibit and examine the parameters. 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 onthe TRANS table:  SQL> ALTER TABLE trans MODIFY (tr_type VARCHAR2(3));  What would happen in this scenario()

A、 The ALTER TABLE command modifies the column successfully.

B、 The DDL operation gets higher priority and transaction for user a is rolled back.

C、 The ALTER TABLE command waits indefinitely until user a ends the transaction.

D、 The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy.

查看答案

相关问题推荐

  • 软件商标权的保护对象是指()。

    A、商业软件

    B、软件商标

    C、软件注册商标

    D、已使用的软件商标

    查看答案
  • 下列选项中不受我国著作权法保护的作品是()。

    A、计算机程序

    B、Flash软件制作的动画

    C、计算机文档

    D、计算机软件保护条例

    查看答案
  • Evaluate these two SQL statements: SELECT last_name, salary, hire_dateFROM EMPLOYEES ORDRE BY salary DESC; SELECT last_name, salary, hire_dateFROM EMPOLYEES ORDER BY 2 DESC; What is true about them? ()

    A、The two statements produce identical results.

    B、The second statement returns a syntax error.

    C、There is no need to specify DESC because the results are sorted in descending order by default.

    D、The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.

    查看答案
  •  You are creating tablespaces in Oracle. Which of the following keywords or clauses permits the datafiles of a database to grow automatically in order to accommodate data growth?()

    A、DEFAULT STORAGE 

    B、EXTENT MANAGEMENT 

    C、AUTOEXTEND 

    D、DATAFILE

    查看答案
  • Which of the following devices would allow a technician to utilize a single mouse, keyboard, and display to control numerous desktop PCs?()

    A、Port replicator

    B、Docking station

    C、USB hub

    D、KVM switch

    查看答案
  • 下列哪种疾病可引起呕吐伴右上腹痛、发热、黄疸()

    A.急性胃炎

    B.急性胰腺炎

    C.急性腹膜炎

    D.急性胆囊炎

    E.急性肾盂肾炎
    查看答案
  • Is there a French word that is the exact ____ of the English word “home”?
    A.
    balance
    B.
    match
    C.
    equipment
    D.
    equivalent
    查看答案
  • 小儿肥胖症的预防措施不包括()

    A.控制低出生体重儿的生后肥胖B.改变不良生活方式C.提高对危险人群的识别与监督指导D.使用配方奶喂养
    查看答案
  • 新能源汽车与传统汽车的安全性是否存在差异
    查看答案
  • 新媒体营销和传统营销有什么区别
    查看答案