Oracle Database SQL — Question 80

Which three actions can you perform by using the ORACLE_DATAPUMP access driver? (Choose three.)

Answer options

• A. Create a directory object for a flat file.
• B. Create a directory object for an external table.
• C. Read data from an external table and load it into a table in the database.
• D. Execute DML statements on an external table.
• E. Read data from a table in the database and insert it into an external table.
• F. Query data from an external table.

Correct answer: C, E, F

Explanation

The correct answers are C, E, and F because the ORACLE_DATAPUMP access driver is designed for data extraction and loading between external tables and database tables. Options A and B are incorrect as they pertain to creating directory objects, which are not actions performed by the driver itself.