Oracle Exam 1Z0-062 Topic 11 Question 47 Discussion

Actual exam question for Oracle's 1Z0-062 exam

Question #: 47
Topic #: 11

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?

AIt allows only 80% of space to be occupied in all data blocks of this table.

BIt minimizes row chaining during row insertion.

CIt minimizes row migration during existing row data updation.

DIt automatically coalesces free space of a data block when it reaches 20% of available space.

Show Suggested Answer

Suggested Answer: A

by Weldon at May 10, 2022, 12:25 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!