Oracle Cloud Infrastructure 2019 Developer Associate — Question 13

Which two options are true for Autonomous Transaction Processing (ATP) database? (Choose two.)

Answer options

• A. You can add/remove Diskgroup in ATP
• B. You can scale storage up or down in ATP
• C. You can scale CPU up or down in ATP
• D. You can add more Pluggable Databases for consolidating multiple databases in ATP
• E. You can add new ORACLE_HOME for bringing older versions of on-premises databases to ATP

Correct answer: B, D

Explanation

Option B is correct because Autonomous Transaction Processing allows for dynamic scaling of storage based on demand. Option D is also correct as users can add more Pluggable Databases to manage multiple databases within ATP. Options A, C, and E are incorrect because ATP does not support adding or removing Diskgroups, the scaling of CPU is typically handled differently, and bringing older versions of databases is not a supported feature in ATP.