Oracle Cloud Infrastructure 2020 Architect Associate — Question 48

You are the admin user of an Autonomous Database (ADB) instance. A new business analyst has joined the team and would like to explore ADB tables using
SQL Developer Web.
What steps do you need to take? (Choose the best answer.)

Answer options

• A. Create an IDCS user. Create a database user with connect, resource, and object privileges.
• B. Create a database user with the default privileges.
• C. Create a database user with connect, resource, and object privileges.
• D. Create a database user (with connect, resource, object privileges), enable the schema to use SQL Developer and provide the user with the user-specific modified URL.

Correct answer: D

Explanation

The correct answer is D because it not only creates a database user with the necessary privileges but also enables the schema for SQL Developer and provides the user with a customized URL for access. Options A and C lack the specific requirements for SQL Developer access, while option B does not provide sufficient privileges for the user to perform their tasks.