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?

Question

Accepted Answer

A. It allows only 80% of space to be occupied in all data blocks of this table. The `PCTFREE 20` parameter dictates that once a data block's available space for new rows drops below 20%, Oracle stops inserting new rows into that block. This effectively means that for initial row insertions, only 80% of the block's space will be occupied, reserving the remaining 20% for updates to existing rows in that block.

Answer

B. It minimizes row chaining during row insertion. `PCTFREE` reserves space for future updates to existing rows to prevent row migration, not to primarily minimize row chaining during initial row insertion.

Answer

C. It minimizes row migration during existing row data updation. Minimizing row migration during existing row data updates is the *purpose* and *benefit* of `PCTFREE`, but choice A describes the direct influence on data storage itself.

Answer

D. It automatically coalesces free space of a data block when it reaches 20% of available space. `PCTFREE` does not automatically coalesce free space; it simply controls the threshold for new row insertions into a block.

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…

Question

Options

How the community answered

Why each option

Topics

Community Discussion