Oracle Autonomous Database Cloud | DBMS_CLOUD.COPY_DATA | Exam 1Z0-931-20

DBMS_CLOUD.COPY_DATA

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

COPY_DATA procedure finishes successfully.The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store.

Prev Question Next Question

Question

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

Answers

A. The source file will be automatically removed after the DBMS_CLOU.

B. COPY_DATA procedure finishes successfully.

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

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

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

F. A valid credential must be created prior to running the DBMS_CLOU.

G. COPY_DATA procedure.

Show Answer

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D. E. F. G.

BE.

DBMS_CLOUD.COPY_DATA is a procedure provided by Oracle Database to transfer data from a data file to a database table. Here are the details regarding the given statements:

A. The source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully. This statement is false. DBMS_CLOUD.COPY_DATA does not remove the source file after the transfer is complete. It is the responsibility of the user to delete the file manually.

B. COPY_DATA procedure finishes successfully. This statement is also false. DBMS_CLOUD.COPY_DATA will raise an exception if the file transfer fails. It is the responsibility of the user to handle the exception appropriately.

C. The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage. This statement is true. DBMS_CLOUD.COPY_DATA supports data files stored in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.

D. The target table will be created in Autonomous Database if it does not already exist. This statement is true. DBMS_CLOUD.COPY_DATA can create the target table automatically if it does not exist. However, the user must have the appropriate privileges to create tables.

E. The source file can be in either Oracle Standard Storage or Oracle Archive Storage bucket in the Object Store. This statement is false. DBMS_CLOUD.COPY_DATA supports data files stored in Oracle Object Storage but not in Oracle Standard Storage or Oracle Archive Storage.

F. A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure. This statement is true. To use DBMS_CLOUD.COPY_DATA, a valid credential must be created and provided as input to the procedure. The credential must have the necessary permissions to access the data file and the target database.

G. COPY_DATA procedure. This statement is incomplete and does not provide any useful information.

In summary, the correct statements regarding DBMS_CLOUD.COPY_DATA are:

The source files can reside in Oracle Object Storage, Amazon S3 Object storage, or Azure Blob storage.
The target table will be created in Autonomous Database if it does not already exist.
A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.

Prev Question Next Question