Q. 1. Which of the following types of database objects is required in order to utilize an external table?
a. An index
b. A PL/SQL package
c. A directory object
d. A partitioned table
Q. 2. Your applications make use of an external table. Which of the following types of statements could be executed against it?
a. SELECT
b. DELETE
c. CREATE INDEX
d. UPDATE
Q. 3. In which type of scenario would you be best served using an external table?
a. The source data resides in a Data Pump dump file.
b. The source data resides on a remote database.
c. The source data resides in a CSV and is too large to load directly into the database.
d. The source data contains a number of anomalies and poor structure.
Q. 4. Which of the following is correct regarding the load paths available with SQL*Loader?
a. A direct path load generates redo and undo data in the same way as DML statements.
b. Foreign keys must first be disabled when using a conventional path load.
c. A direct path load affects user performance...