Oracle Database 12c: Installation and Administration — Question 147

You create a locally managed tablespace ORDERS_TBS with automatic segment management.
You then create the table DAILY_ORDS_LST in the ORDERS_TBS tablespace using the command.
CREATE TABLE daily_ords_1st(ordno NUMBER, ord_date DATE) PCTFREE 20;
How does the PCTFREE storage parameter influence data storage for this table?

Answer options

• A. It allows only 80% of space to be occupied in all data blocks of this table.
• B. It minimizes row chaining during row insertion.
• C. It minimizes row migration during existing row data updation.
• D. It automatically coalesces free space of a data block when it reaches 20% of available space.

Correct answer: A

Explanation

The correct answer is A because the PCTFREE parameter specifies the percentage of space in each data block that should remain free for future updates, allowing only 80% of the block to be filled. Options B and C are incorrect as they relate to row chaining and migration, which are not directly addressed by PCTFREE. Option D is also incorrect since PCTFREE does not automatically coalesce free space; it simply reserves space for future growth.