Which three statements are true about procedures in the DBMS_CLOUD package?

The DBMSCLOUD package provides a suite of procedures to interact with cloud object storage services directly from an Oracle Autonomous Database. The CREATECREDENTIAL procedure is the first step, securely storing access credentials within the database. Subsequently, CREATEEXTERNALTABLE uses these credentials to create a metadata-only table that points to files in object storage, allowing them to be queried directly. The VALIDATEEXTERNALTABLE procedure is a utility to test the source files against the external table definition, identifying and logging any rows that would cause errors during a query, which is crucial for data validation before processing.

B: The DBMSCLOUD.DELETEFILE procedure removes a file from the cloud object store, not a credential from the database. The correct procedure to remove credentials is DBMSCLOUD.DELETECREDENTIAL. E: The DBMSCLOUD.PUTOBJECT procedure copies a file from the Autonomous Database to cloud object storage. The option incorrectly describes the data flow in the opposite direction.

1. Oracle Cloud Infrastructure Documentation

DBMSCLOUD Package Subprograms:

For A (CREATEEXTERNALTABLE): "The CREATEEXTERNALTABLE procedure creates an external table on files in the cloud. After you create the external table you can run queries on the external data." (Section: CREATEEXTERNALTABLE Procedure)

For C (CREATECREDENTIAL): "The CREATECREDENTIAL procedure stores Cloud Object Storage credentials in the Autonomous Database." (Section: CREATECREDENTIAL Procedure)

For D (VALIDATEEXTERNALTABLE): "The VALIDATEEXTERNALTABLE procedure validates the source files for an external table... Rows that do not match the specified format options are logged... you can specify parameters to store the rows that do not match the format options in a bad file or in a bad table." (Section: VALIDATEEXTERNALTABLE Procedure)

For B (DELETEFILE): "The DELETEFILE procedure deletes a file from the specified Cloud Object Storage." (Section: DELETEFILE Procedure)

For E (PUTOBJECT): "The PUTOBJECT procedure copies a file from a directory in the Autonomous Database to the specified Cloud Object Storage." (Section: PUTOBJECT Procedure)