多項(xiàng)選擇題

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.

你可能感興趣的試題

多項(xiàng)選擇題

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.

單項(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.

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

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

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

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