Oracle
1Z0-062 · Question #335
1Z0-062 Question #335: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #335. The question stem and answer options stay visible for context.
Managing Schema Objects
Question
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?
Options
- 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.
Unlock 1Z0-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#PCTFREE#Data Blocks#Table Storage#Automatic Segment Space Management