Oracle Cloud Infrastructure 2023 Architect Associate — Question 11

Which two are ways Oracle Database can optimally access data in Object Storage? (Choose two.)

Answer options

• A. Scan avoidance using partitioned external tables
• B. Optimized data archive using partitioned external tables
• C. Optimized data archive using hybrid partitioned tables
• D. Scan avoidance using columnar pruning for .csv files

Correct answer: A, C

Explanation

The correct answers are A and C because scan avoidance through partitioned external tables allows for more efficient data retrieval by minimizing the amount of data processed. Option B is incorrect as it focuses on data archiving rather than access methods, and option D is also incorrect since columnar pruning applies to data organization rather than direct access methods in Object Storage.