Test your knowledge
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 ...
Get OCA Oracle Database 11g: Database Administration I: A Real-World Certification Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
