单项选择题

You execute a command to resize a data file， sales.dbf，……

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.

<上一题目录下一题>

热门试题

单项选择题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.

单项选择题Your database is configured in shared server mode. However， your senior DBA asks you to modifythe value of the PRIVATE_SGA limit in the profile of the users. What could be the reason for this（）

A.to limit the User Global Area （UGA） memory allocated to a session from the SGA
B.to limit the amount of memory to be used for the dispatcher queue of a session in SGA
C.to limit the amount of memory to be used for the request pool in System Global Area （SGA）
D.to control the amount of memory allocated in SGA for the local variables for each shared server process