1z0-071 Exam QuestionsBrowse all questions from this exam

1z0-071 Exam - Question 46


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

Show Answer
Correct Answer: CD

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

2 comments
Sign in to comment
TheOracleWasTakenOptions: CD
Aug 2, 2023

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

MIGHTYSTUNNERSOptions: BD
May 1, 2024

BD IS CORRET FOR SURE

yanoolthecool
Jun 13, 2024

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