Oracle Cloud Infrastructure 2019 Cloud Operations Associate — Question 15

Which statement is true about Database Schema Service and Database as a Service in Oracle Public Cloud?

Answer options

• A. Database as a Service (DBaaS) requires no database administrators to administer the database.
• B. Database Schema Service requires a database administrator to administer the schemas.
• C. Database as a Service (DBaaS) provides complete dedicated database instances with full administrative control for a subscriber.
• D. Database Schema Service provides database schemas with full administrative control for a subscriber.

Correct answer: D

Explanation

Option D is correct because Database Schema Service indeed provides database schemas with full administrative control for the subscriber. Option A is incorrect because while DBaaS may reduce the need for database administrators, it does not eliminate them entirely. Option B is wrong as it suggests a requirement for a DBA where schemas can be managed by the user in many cases. Option C misrepresents DBaaS as it does not necessarily provide full administrative control in all scenarios.