Question No 1

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 Choices:

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.

Create a database user with the default privileges.

Create a database user with connect, resource, and object privileges.

Create an IDCS user. Create a database user with connect, resource, and object privileges.

Question No 2

What is the correct way to list all files in the default data pump directory?

Choose the Choices:

By executing select * from DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');

You cannot list files in the default data pump directory from Autonomous Data Warehouse (ADW).

Log onto ADW server and issue is - al on the command line.

By executing select * from utl_file . list ( ‘DATA_PUMP_DIR ' ) ;

Question No 3

What REST verb is used to create an Autonomous Database service using REST APIs?

Choose the Choices:

Question No 4

When using Data Pump to migrate your Oracle database to Autonomous Database, which two objects are imported?

Choose the Choices:

Question No 5

What are two differentiators of Oracle Autonomous Database Dedicated Infrastructure?

Choose the Choices:

Users have OS access to the database machine.

Users can customize the maintenance schedule.

It offers greater control and isolation starting at the Exadata cloud infrastructure level.

Users have SYS privileges in the database.

Users can customize the OS stack and add additional packages

Practice Oracle 1Z0-931-20 Exam Questions

Question No 1

Question No 2

Question No 3

Question No 4

Question No 5

1Z0-931-20 Exam Features

1Z0-931-20 PDF Dumps