1Z0-931 Free Exam Questions & Answers (Updated 2026)

Question No 1

What are two advantages of using Data Pump to migrate your Oracle Databases to Autonomous Database? (Choose two.)

Choose the Choices:

Data Pump can exclude migration of objects like indexes and materialized views that are not needed by Autonomous Database.

Data Pump is platform independent - it can migrate Oracle Databases running on any platform.

Data Pump is faster to migrate database than using RMAN.

Data Pump creates the tablespaces used by your Autonomous Database.

Question No 2

The default eight - day retention period for Autonomous Database performance data can be modified using which DBMS_WORKLOAD_REPOSITORY subprogram procedure?

Choose the Choices:

Question No 3

Which task is NOT automatically performed by the Oracle Autonomous Database?

Choose the Choices:

Question No 4

Which three statements are true about procedures in the DBMS_CLOUD package? (Choose three.)

Choose the Choices:

The DBMS_CLOUD.PUT_OBJECT procedure copies a file from Cloud Object Storage to the Autonomous Data Warehouse.

The DBMS_CLOUD.CREATE_CREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Data Warehouse database.

The DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE procedure validates the source files for an external table, generates log information, and stores the rows that do not match the format options specified for the external table in a badfile table on Autonomous Data Warehouse.

The DBMS_CLOUD.DELETE_FILE procedure removes the credentials file from the Autonomous Data Warehouse database.

The DBMS_CLOUD.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud. You can run queries on external data from the Autonomous Data Warehouse.

Question No 5

Which of these database features is NOT part of the Autonomous Database?

Choose the Choices:

Next Question

Oracle 1Z0-931 Free Exam Questions (Updated 2026)

PDF Questions

Bundle Pack

Online Engine

Question No 1

Question No 2

Question No 3

Question No 4

Question No 5