Oracle Cloud Infrastructure 2019 Architect Associate — Question 7

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

Answer options

• 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: B, C, E

Explanation

The correct options B, C, and E accurately describe the functionalities of the DBMS_CLOUD procedures. Option A is incorrect because the DBMS_CLOUD.PUT_OBJECT procedure does not copy files into the Autonomous Data Warehouse; it is used for uploading files. Option D is incorrect as the DBMS_CLOUD.DELETE_FILE procedure does not deal with credential files but rather with actual files in Cloud Object Storage.