1Z0-071 practice question 6 of 35
Which two are true about external tables that use the ORACLE _DATAPUMP access driver?
Full set: 326 questionsExternal 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.
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.
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
Keep practicing
Take the free 1Z0-071 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-071 practice questions
- Question 2Which three statements are true about single row functions?
- Question 3Which statement executes successfully?
- Question 4Which two are true about transactions in the Oracle Database?
- Question 9Which statement will execute successfully?
- Question 10Examine this statement: CREATE TABTE orders (sarial_no NUMBER UNIQUE, order_id NUMBER PRI…
- Question 11You have the privileges to create any type of synonym. Which stalement will create a syno…
