Oracle Cloud Infrastructure 2020 Architect Associate — Question 23

For someone that is not a service administrator to use SQL Developer Web, what package would you need to use to give them access? (Choose the best answer.)

Answer options

• A. ORDS_ADMIN.GRANT_SCHEMA
• B. ORDS_ADMIN.ENABLE_SCHEMA
• C. SQLDEV_ADMIN.GRANT_SCHEMA
• D. ORDS_PRIV.ENABLE_SCHEMA

Correct answer: B

Explanation

The correct answer is B, ORDS_ADMIN.ENABLE_SCHEMA, which allows the enabling of a schema for SQL Developer Web access. The other options either grant permissions or are related to different functionalities that do not specifically enable access to SQL Developer Web for non-administrative users.