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? (Choose the best answer)
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.
Explanation:
A
C
PCTFREE default value is 10. Increasing PCTFREE can help to avoid migrated rows.
A
A
PCTFREE is a block storage parameter used to specify how much space should be left in a database block for future updates. For example, for PCTFREE=20, Oracle will keep on adding new rows to a block until it is 80% full. This leaves 20% for future updates (row expansion).
@mmm C? definitely not C
A!!!!