单项选择题
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.
相关考题
-
多项选择题
Whichtwostatementsaboutbigfiletablespacesaretrue？（）
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. -
单项选择题
Whichstatementistrueaboutthelossofsystem-criticaldatafilesinARCHIVELOGmode？（）
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. -
单项选择题
You executed the following command to start the database： SQL> STARTUP ORACLE instance started. Total System Global Area 281018368 bytes Fixed Size 789000 bytes Variable Size 229635576 bytes Database Buffers 50331648 bytes Redo Buffers 262144 bytes ORA-00205： error in identifying controlfile， check alert log for more info Which view would you query at this stage to investigate this missing control file？（）
A.V$INSTANCE
B.V$CONTROLFILE
C.DBA_CONTROL_FILES
D.V$DATABASE_PROPERTIES
E.V$CONTROLFILE_RECORD_SECTION
