Oracle Autonomous Database Cloud 2019 Specialist Exam Questions

Here you have the best Oracle 1z0-931 practice exam questions.

Some things you may want to keep in mind about this practice exam questions:

You have 60 total questions to study from
Each page has 5 questions, making a total of 12 pages
You can navigate through the pages using the buttons at the bottom
This questions were last updated on September 14, 2024

Question 1 of 60

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

A.

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

B.

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

C.

Data Pump is faster to migrate database than using RMAN.

D.

Data Pump creates the tablespaces used by your Autonomous Database.

Correct Answer: AB

Data Pump offers two clear advantages when migrating Oracle Databases to Autonomous Database. First, it allows excluding objects such as indexes and materialized views that are not necessary for the Autonomous Database, which helps streamline the migration process. Second, Data Pump is platform-independent, enabling the migration of Oracle Databases across different platforms without compatibility issues. These factors make options A and B the correct choices.

Question 2 of 60

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

A.

UPDATE_OBJECT_INFO

B.

MODIFY_SNAPSHOT_SETTINGS

C.

CREATE_BASELINE_TEMPLATE

D.

MODIFY_BASELINE_WINDOW_SIZE

Correct Answer: B

The default eight-day retention period for Autonomous Database performance data can be modified using the DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS subprogram procedure. This procedure allows configuring retention periods and other settings related to snapshot management in the Automatic Workload Repository.

Question 3 of 60

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

A.

Backing up the database.

B.

Mask your sensitive data.

C.

Patching the database.

D.

Automatically optimize the workload.

Correct Answer: B

Oracle Autonomous Database automatically takes care of tasks such as backing up the database, patching the database, and optimizing the workload. However, it does not automatically perform data masking, which is required to mask sensitive data.

Question 4 of 60

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

A.

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

B.

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

C.

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.

D.

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

E.

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.

Correct Answer: BCE

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.CREATE_EXTERNAL_TABLE procedure creates an external table on files in the cloud, allowing you to run queries on external data from the Autonomous Data Warehouse.

Question 5 of 60

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

A.

Online Indexing

B.

Flashback Database

C.

Real Application Clusters (RAC)

D.

Java in the Database

Correct Answer: C

Real Application Clusters (RAC) are not supported in the Autonomous Database. The Autonomous Database is designed to provide fault tolerance and high availability through different architecture and internal mechanisms, reducing the need for RAC to be included as part of its feature set.