Oracle
1Z0-034 · Question #58
1Z0-034 Question #58: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-034 to reveal the answer and full explanation for question #58. The question stem and answer options stay visible for context.
Question
SQL> SELECT blocks FROM user_segments WHERE segment_name=,ALTBT; BLOCKS ---------------- SQL> ALTER TABLE altb SHRINK SPACE COMPACT; Table altered. SQL> SELECT blocks FROM user_segments WHERE segment_name=ALTB; BLOCKS ------------------------- View the Exhibit and examine the output and commands executed on the ALTB table. Why does the number of blocks for the table remain the same after the shrink operation?
Options
- Abecause the table did not contain migrated or chained rows
- Bbecause the row IDs remain the same for all rows during the shrink operation
- Cbecause the progress of the shrink operation is not saved in the bitmap blocks of the table
- Dbecause the high-water mark (HWM) did not move due to the compact option that is used in the
Unlock 1Z0-034 to see the answer
You've previewed enough free 1Z0-034 questions. Unlock 1Z0-034 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.