In Oracle Autonomous Database, the DBMS_CLOUD package provides tools to interact with cloud storage and directory operations, including listing files in the default Data Pump directory (DATA_PUMP_DIR).
Correct Answer (A): The statement SELECT * FROM DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR'); is the officially supported method to list files in the DATA_PUMP_DIR. This function returns a result set with details about files in the specified directory, tailored for the managed environment of Autonomous Database.
Incorrect Options:
B: This is false; you can list files in DATA_PUMP_DIR using DBMS_CLOUD.LIST_FILES, as it is designed for this purpose in ADW.
C: The UTL_FILE package is not recommended for Autonomous Database due to its limitations in a cloud-managed environment. DBMS_CLOUD is the preferred utility for such operations. Additionally, the syntax UTL_FILE.LIST is incorrect; the proper procedure would be UTL_FILE.FGETATTR or similar, but it’s still not applicable here.
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit