单项选择题
Which statement is true regarding the effect of this command on the transaction in Scott’s session（）
A.The command fails as a transaction is still pending.
B.The transaction in Scott’s session is rolled back and the tablespace becomes read-only.
C.The command waits and the user SCOTT can execute data manipulation language （DML） statements only as part of the current transaction.
D.The command hangsuntil all transactions on the objects in the tablespace commit or rollback， and then the tablespace is placed in read-only mode.
相关考题
-
多项选择题
WhichtablespacesaremandatoryinanOracledatabaseforittobeoperational（）
A.Undo tablespace
B.USERS tablespace
C.SYSAUX tablespace
D.SYSTEM tablespace
E.Temporary tablespace -
多项选择题
Identifytwosituationsinwhichtheblockheadergrowsinadatablock.（）
A.when row directories need more row entries
B.when there is row migration in the data block
C.when there is an increase in the PCTFREE value for the data block
D.when more transaction slots are required than are initially configured -
多项选择题
Whichtwostatementsaretrueregardingatablespace（）
A.It can span multiple databases.
B.It can consist of multiple data files.
C.It can contain blocks of different sizes.
D.It can contain segments of different sizes.
E.It can contain a part of a nonpartitioned segment.
