nerdexam
Oracle

1Z0-931-20 · Question #12

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…

The correct answer is A. Create a database user (with connect, resource, object privileges), enable the schema to use SQL. Explanation/Reference:

Developing with Autonomous Database

Question

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?

Options

  • ACreate a database user (with connect, resource, object privileges), enable the schema to use SQL
  • BCreate a database user with the default privileges.
  • CCreate a database user with connect, resource, and object privileges.
  • DCreate an IDCS user. Create a database user with connect, resource, and object privileges.

How the community answered

(60 responses)
  • A
    78% (47)
  • B
    3% (2)
  • C
    13% (8)
  • D
    5% (3)

Explanation

Explanation/Reference:

Topics

#SQL Developer Web#user privileges#schema enablement#database user creation

Community Discussion

No community discussion yet for this question.

Full 1Z0-931-20 Practice