Oracle Cloud Infrastructure 2019 Architect Associate — Question 12

Which Autonomous Database Cloud service ignores hints in SQL Statements by default?

Answer options

• A. Autonomous Transaction Processing.
• B. Autonomous Data Warehouse.
• C. Neither service ignores hints by default.
• D. Both services ignore hints by default.

Correct answer: B

Explanation

The Autonomous Data Warehouse service does not consider hints in SQL statements unless explicitly instructed to do so, making it the correct answer. Autonomous Transaction Processing, in contrast, does take hints into account, which rules it out as the correct choice. The other options incorrectly state the behavior of the services regarding hints.