Oracle Database SQL — Question 161

Which two are true about external tables that use the ORACLE_DATAPUMP access driver? (Choose two.)

Answer options

• A. When creating an external table, data can be selected only from a table whose rows are stored in database blocks.
• B. Creating an external table creates a directory object.
• C. When creating an external table, data can be selected from another external table or from a table whose rows are stored in database blocks.
• D. Creating an external table creates a dump file that can be used by an external table in the same or a different database.
• E. Creating an external table creates a dump file that can be used only by an external table in the same database.

Correct answer: C, D

Explanation

The correct answers are C and D. Option C is true because external tables can source data from both other external tables and tables with rows stored in database blocks. Option D is also correct as creating an external table with the ORACLE_DATAPUMP access driver allows the generated dump file to be used across different databases, unlike option E which incorrectly states that it's limited to the same database.