OCP-1Z0-052-V8.02-149题

149. You executed the following command to create a tablespace called SALES_DATA:

SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M

SEGMENT SPACE MANAGEMENT AUTO;

Which two statements are true about the SALES_DATA tablespace? (Choose two.)

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 in bitmap blocks. 

E.The space utilization description of the data blocks in segments is managed through free lists.  MANUAL

Answer: AD  

答案解析：

segment_management_clause

The segment_management_clause is relevant only for permanent, locally managed tablespaces. It lets you specify whether Oracle Database should track the used and free space in the segments in the tablespace using free lists or bitmaps. This clause is not valid for a temporary tablespace.

这条语句仅仅和permanent，locally managed tablespace相关。

它允许你指定oracle数据库是否应该在段表空间中使用free list或者bitmaps来跟踪使用和空闲空间。

这条语句对临时表空间无效

AUTO Specify AUTO if you want the database to manage the free space of segments in the tablespace using a bitmap. If you specify AUTO, then the database ignores any specification for PCTUSED, FREELIST, and FREELIST GROUPS in subsequent storage specifications for objects in this tablespace. This setting is called automatic segment-space management and is the default.

To determine the segment management of an existing tablespace, query the SEGMENT_SPACE_MANAGEMENT column of the DBA_TABLESPACES or USER_TABLESPACES data dictionary view.

要确定一个现有的表空间的分类管理，查询SEGMENT_SPACE_MANAGEMENT列的的DBA_TABLESPACES或USER_TABLESPACES的数据字典视图。