nerdexam
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)
  • A
    4% (2)
  • B
    15% (8)
  • C
    11% (6)
  • D
    71% (39)

Community Discussion

No community discussion yet for this question.

Full 1Z0-047 Practice