多项选择题

Identify three situations in which you would NOT be able to drop a tablespace. （）

A.when the tablespace is online
B.when the tablespace has segments with data in it
C.when the tablespace is a default permanent tablespace for the database
D.when the tablespace contains a table that is currently being used by transactions
E.when the tablespace contains undo data that is needed to rollback an uncommitted transaction

<上一题目录下一题>

热门试题

多项选择题Which two statements are true regarding the MRKT tablespace（）

A.No more data files can be added to the tablespace.
B.Segment space is managed by free lists in the tablespace.
C.A user created without being assigned a default tablespace uses this tablespace.
D.The tablespace can be dropped with the current setting with segments present in it.

多项选择题You execute the following command to change the status of the SALES tablespace： SQL> ALTER TABLESPACE sales OFFLINE； Which statements describe the effect of the command（）

A.The tablespace would require recovery to go back online.
B.A checkpoint is taken on all data files that are associated with the SALES tablespace.
C.The sessions that subsequently try to access the objects in the SALES tablespace receive an error.
D.The new status of the SALES tablespace is recorded in the control file when the database instance is closed.

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