Question

Which statement is true regarding external tables?

(a) The default REJECT LIMIT for external tables is UNLIMITED

(b) The data and metadata for an external table are stored outside the database

(c) ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table

(d) The CREATE TABLE AS SELECT statement can be used to unload data into regular table in the database from an external table

The question was posed to me in final exam.

The query is from Implementation of Isolation Levels topic in section Transactions of Database Management

Answer 1

Correct answer is (d) The CREATE TABLE AS SELECT statement can be used to unload data into regular table in the database from an external table

For explanation: This will replicate the table as in the select statement.