Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Question 46

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

When creating an external table, data can be selected only from a table whose rows are stored in database blocks.

Creating an external table creates a directory object.

When creating an external table, data can be selected from another external table or from a table whose rows are stored in database blocks.

Creating an external table creates a dump file that can be used by an external table in the same or a different database.

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

When creating an external table using the ORACLE_DATAPUMP access driver, data can be selected from another external table or from a table whose rows are stored in database blocks. Additionally, creating an external table creates a dump file that can be used by an external table in the same or a different database.

Discussion

TheOracleWasTakenOptions: CD

https://www.examtopics.com/discussions/oracle/view/22606-exam-1z0-071-topic-2-question-60-discussion/

MIGHTYSTUNNERSOptions: BD

BD IS CORRET FOR SURE

yanoolthecool

uhh, no. 'You must create the directory object before you create the external table; otherwise, an error is generated' source: https://docs.oracle.com/en/database/oracle/oracle-database/23/sutil/oracle-external-tables-concepts.html#GUID-ACF1D3AA-1D61-4682-AEC5-42C944756E12