Oracle Database Administration I — Question 140

Which two are benefits of external tables? (Choose two.)

Answer options

• A. They support DELETES which transparently deletes records in the file system as if they were table rows.
• B. They can be queried, transformed, and joined with other tables without having to load the data first.
• C. They support UPDATES which transparently updates records in the file system as if they were table rows.
• D. The results of a complex join or aggregating function or both can be unloaded to a file for transportation to another database.
• E. They can be queried while the database is in the MOUNT state like dynamic performance views.

Correct answer: B, D

Explanation

Option B is correct because external tables allow querying and transforming data without prior loading. Option D is also correct as it enables the unloading of results to a file. Options A and C are incorrect because external tables do not support DELETES and UPDATES in the way described. Option E is incorrect since external tables cannot be queried while the database is in the MOUNT state.