單項(xiàng)選擇題

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.

你可能感興趣的試題

多項(xiàng)選擇題

Which two statements about bigfile tablespaces are true？（）

A.The bigfile tablespace have only one data file.
B.The segment space management is automatic.
C.The extent management is dictionary managed.
D.The database can have only one bigfile tablespace.
E.The bigfile tablespace can be converted to a smallfile tablespace.

單項(xiàng)選擇題

Which statement is true about the loss of system-critical data files in ARCHIVELOG mode？（）

A.The data files can be recovered till the last committed transaction.
B.The data files can be recovered without shutting down the database.
C.The data file is taken offline automatically； the database remains open.
D.The data files can be recovered to the time of the most recent backup.

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

你可能感興趣的試題

Which two statements about bigfile tablespaces are true？ （）

Which statement is true about the loss of system-critical data files in ARCHIVELOG mode？（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

Which two statements about bigfile tablespaces are true？（）

Which statement is true about the loss of system-critical data files in ARCHIVELOG mode？（）