Oracle Fusion Middleware 12c: Oracle Service Bus Essentials — Question 5

Which two quarantine types can disable Smart Scan for multiple databases that offload SQL statements to a cell on an Exadata Database Machine? (Choose two.)

Answer options

• A. Cell Offload Quarantine
• B. Disk Region Quarantine
• C. SQL Plan Quarantine
• D. Database Quarantine
• E. Manually created Quarantine

Correct answer: A, C

Explanation

The correct answers, Cell Offload Quarantine and SQL Plan Quarantine, are specifically designed to manage and disable Smart Scan for offloaded SQL operations. The other options, while related to database management, do not directly affect the Smart Scan functionality in the same manner.