Q154 l Which two are benefits of external tables?

Q154 l Which two are benefits of external tables?

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