Oracle
1Z0-047 · Question #154
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 database. See the full explanation below for the reasoning.
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 with an
- DThe CREATE TABLE AS SELECT statement can be used to unload data into regular table in the database
How the community answered
(55 responses)- A4% (2)
- B15% (8)
- C11% (6)
- D71% (39)
Community Discussion
No community discussion yet for this question.