Oracle Database Administration 2022 Certified Professional — Question 22

Buffer cache access is too frequent when querying the SALES table.
Examine this command which executes successfully:
ALTER TABLE SALES SHRINK SPACE;
For which access method does query performance on SALES improve?

Answer options

• A. db file scattered read
• B. db file sequential read
• C. index full scan
• D. index range scan

Correct answer: B

Explanation

The command ALTER TABLE SALES SHRINK SPACE reduces the amount of space allocated to the table, which can lead to improved performance for sequential reads as the data becomes more contiguous. In contrast, db file scattered reads and index scans are less affected by this operation, as they deal more with accessing multiple data blocks or indices rather than reading data sequentially.