Question 1

Which two options are available to restore an Autonomous Data Warehouse? (Choose two.)

Options :

A : Backup and recovery must be done using Recovery Manager(RMAN).

B : Select the snapshot of the backup.

C : Select the archived redo logs.

D : Select the backup from which restore needs to be done.

E : Specify the point in time (timestamp) to restore.

Answer: A,D

Question 2

Which Oracle package is used to load data to an Autonomous Database from object storage?

Options :

A : DBMS_RPC

B : DBMS_LOAD

C : DBMS_MIGRATE

D : DBMS_CLOUD

Answer: D

Question 3

On which two infrastructure classes can the Autonomous Database service be deployed?

Options :

A : Shared Exadata Infrastructure

B : Dedicated Exadata Infrastructure

C : Exadata Cloud Service

D : Oracle Cloud Infrastructure Virtual Machines

Answer: A,B

Question 4

What is the number of concurrent statements that can be handled by the medium database service name?

Options :

A : 1-25 X OCPU

B : OS

C : unlimited

D : 20 X OCPU

Answer: A

Question 5

Which two statements are true when running DBMS_CLOUD.COPY_DATA? (Choose two.)

Options :

A : The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.

B : The source files can reside in Oracle Object Storage, Amazon S3 Object Storage, or Azure Blob Storage.

C : The target table will be created in Autonomous Database if it does not already exist.

D : The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.

E : A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.

Answer: B,E

Free 1Z0-931-26 Mock Exam – Practice Online Confidently