1Z0-071 practice question 6 of 35

Which two are true about external tables that use the ORACLE _DATAPUMP access driver?

Full set: 326 questions
Answer options
A: Creating an external table creates a directory object.
B: When creating an external table, data can be selected only from a table whose rows are stored in database blocks.
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. Correct answer
D: Creating an external table creates a dump file that can be used by an external table in the same or a different database. Correct answer
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. 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.
Explanation

External tables with ORACLEDATAPUMP driver can select data from both regular database tables and other external tables during creation using CREATE TABLE AS SELECT. The process generates a platform-independent dump file in the specified directory. This dump file follows Oracle's portable format and can be read by external tables in the same database or transported to different databases, making it useful for data movement between systems.

Why Incorrect

A. Creating an external table requires a pre-existing directory object; it doesn't create one.
B. Data can be selected from multiple sources including other external tables, not just regular tables.
E. DATAPUMP files are portable and can be used across different databases, not limited to the same database.

References

1. Oracle Database SQL Language Reference 19c, "CREATE TABLE" section, External Table Subclauses

2. Oracle Database Utilities 19c, Chapter 15 "The ORACLEDATAPUMP Access Driver", Section 15.3

3. Oracle Database Administrator's Guide 19c, "Managing External Tables", Section 20.4.2

4. Oracle Database Data Warehousing Guide 19c, "Using External Tables", Chapter 12, Section 12.2.3

5. Greenwald, R. et al. (2013). "Oracle Essentials: Oracle Database 12c" O'Reilly Media, Chapter 13, pp. 287-290

Scroll to Top