多項選擇題

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.

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

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

你可能感興趣的試題

Which two statements are true regarding the MRKT tablespace（）

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（）

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（）