Oracle 1Z0-931-25 Exam - Topic 3 Question 18 Discussion

Actual exam question for Oracle's 1Z0-931-25 exam

Question #: 18
Topic #: 3

[All 1Z0-931-25 Questions]

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

AThe source file will be automatically removed after the DBMS_CLOUD.COPY_DATA procedure finishes successfully.

BThe source files can reside in Oracle Object Storage, Amazon S3 Object Storage, or Azure Blob Storage.

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

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

EA valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure.

Show Suggested Answer

Suggested Answer: B, E

DBMS_CLOUD.COPY_DATA loads data into Autonomous Database:

Correct Answer (B): ''The source files can reside in Oracle Object Storage, Amazon S3 Object Storage, or Azure Blob Storage'' is true. The procedure supports these cloud storage services with proper credentials.

Correct Answer (E): ''A valid credential must be created prior to running the DBMS_CLOUD.COPY_DATA procedure'' is true. Credentials (e.g., via DBMS_CLOUD.CREATE_CREDENTIAL) authenticate access to the source storage.

Incorrect Options:

A: Source files are not automatically removed; deletion requires separate action.

C: The target table must exist; COPY_DATA doesn't create it.

D: Archive Storage isn't supported; only Standard Storage is compatible.

This enables flexible data loading from cloud storage.

by Ahmed at Mar 08, 2026, 08:20 PM

Limited Time Offer

25%

Off

Get Premium 1Z0-931-25 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Peggie

4 hours ago

I remember a practice question about DBMS_CLOUD, and I think option E is also true because credentials are usually required for cloud operations.

upvoted 0 times

...

Abraham

5 days ago

I'm not so sure about option A; I feel like the source file might not be removed automatically.

upvoted 0 times

...

Kristeen

10 days ago

I think option B is definitely true since we discussed different cloud storage options in class.

upvoted 0 times

...