单项选择题
You want to create a tablespace to contain objects with block size 16 KB. But while configuring thestorage you find that the block size that you can provide is only 8 KB.
Which configuration could have enabled the block selection of 16 KB（）
A.choosing the extent allocation type to uniform
B.choosing the Segment Space Management option to manual
C.setting autoextension on for the data file mentioned for the tablespace
D.setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value
相关考题
-
多项选择题
IdentifythreesituationsinwhichyouwouldNOTbeabletodropatablespace.（）
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.
