Oracle OCP Certification Exam Bank Analysis 052-3

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.