多项选择题
You executed the following command to create a tablespace called SALES_DATA：
> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO；
Which two statements are true about the SALES_DATA tablespace （）
A.The database automatically determines the extent-sizing policy for the tablespace.
B.The segments are automatically shrunk when the contents are removed from them.
C.The allocation of extents within the tablespace is managed through the dictionary tables.
D.The space utilization description of the data blocks in segments is recorded inbitmapblocks.
E.The space utilization description of the data blocks in segments is managed through free lists.MANUAL
相关考题
-
多项选择题
Which statements are true regarding the USERS tablespace（）
A.A bitmap is used to record free extents.
B.Free extents information is managed within the tablespace.
C.Free extents information is managed in the SYSAUX tablespace.
D.The data dictionary tables are updated when extents are allocated or deallocated -
单项选择题
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
