Oracle OCP Certification Exam Bank Analysis 052-3

QUESTION 3

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 statements is true about the Sales_data tablespace? (Choose)

A. The database automatically determines the extent-sizing policy for the tablespace.

B. The segments is automatically shrunk when the contents is 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 are recorded in bitmap blocks.

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

Correct Answer:ad

Explanation/reference: Segment Space management: The management of a segment space in a locally managed tablespace can be specified as: Automatic: Oracle DB uses bitmaps to manage free space in the segment. Bitmaps describe the state of each block of data in a segment, which is related to the amount of space in a block that can be inserted into a row. When there is more or less free space in the data block, the new state of the block is reflected in the bitmap. By using bitmaps, the Oracle DB You can increase the degree of automation in managing free space. Therefore, this type of space management is called "Automatic segment Space Management (ASSM)". Manual: This method specifies that you want to use an idle list to manage free space in a segment. A free list is a list of blocks of data that have space to insert rows. Because of this way of managing the space, you need to specify and optimize the pctused for the schema objects created in the table space. Freelists and freelist groups store parameters, so this approach is called "Manual segment Space Management". This method is supported for backwards compatibility and is recommended for use with ASSM. You can view partition and segment space management by Dba_tablespaces: [email protected]> select Tablespace_name,extent_management,segment_space_management from dba_tablespaces; tablespace_name Extent_man segmen ----------------             ----------        ------ SYSTEM                           local           manual SYSAUX                           local          Span style= "font-size:14px;font-family: ' The song Body '; >      auto TEMP                          &NBSP,   Span style= "font-size:14px;font-family: ' Courier New ';" > local                USERS                            local          auto EXAMPLE                       &NBSP,           auto UNDOTBS1 LOCAL MANUAL

for more questions, please follow: http://ke.qq.com/cgi-bin/courseDetail?course_id=36323

Oracle OCP Certification Exam Bank Analysis 052-3