單項(xiàng)選擇題

You execute a command to resize a data file， sales.dbf， of size 200 MB in your database： ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M；
Which statement is true about this command（）

A.The command must be issued in MOUNT state.
B.The command succeeds only if the data file is offline.
C.The command must be issued when the database is in the archivelog mode.
D.The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.

你可能感興趣的試題

單項(xiàng)選擇題

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.

多項(xiàng)選擇題

Which tablespaces are mandatory in an Oracle database for it to be operational（）

A.Undo tablespace
B.USERS tablespace
C.SYSAUX tablespace
D.SYSTEM tablespace
E.Temporary tablespace

无码高清视频|成人自拍视频|欧美成人午夜无码A片秀色直播|草美女视频网站|美女被操网站在线观看

You execute a command to resize a data file， sales.dbf， of size 200 MB in your database： ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M； Which statement is true about this command（）

你可能感興趣的試題

Which statement is true regarding the effect of this command on the transaction in Scott’s session（）

Which tablespaces are mandatory in an Oracle database for it to be operational（）

You execute a command to resize a data file， sales.dbf， of size 200 MB in your database： ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M；
Which statement is true about this command（）