Oracle Cloud Infrastructure 2023 Architect Associate — Question 35

Which two methods can you use to create database users and grant roles in Autonomous Database services?

Answer options

• A. DBMS_CLOUD_ADMIN package
• B. SQL*Plus
• C. Oracle Cloud Infrastructure (OCI) service console
• D. SQL Developer

Correct answer: A, D

Explanation

The DBMS_CLOUD_ADMIN package is specifically designed for managing cloud database users and roles, making it a suitable choice. SQL Developer also provides a graphical interface to create users and grant roles effectively. However, SQL*Plus and the OCI service console are not primarily used for this purpose, which makes them incorrect options.