Oracle
1Z0-071 · Question #46
Which statement is true regarding external tables?
The correct answer is D. The CREATE TABLE AS SELECT statement can be used to unload data into regular table in the. https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables013.htm
Exadata Administration
Question
Which statement is true regarding external tables?
Options
- AThe default REJECT LIMIT for external tables is UNLIMITED.
- BThe data and metadata for an external table are stored outside the database.
- CORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used
- DThe CREATE TABLE AS SELECT statement can be used to unload data into regular table in the
How the community answered
(30 responses)- A17% (5)
- B3% (1)
- C7% (2)
- D73% (22)
Explanation
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables013.htm
Topics
#external tables#ORACLE_LOADER#ORACLE_DATAPUMP#metadata storage
Community Discussion
No community discussion yet for this question.