Oracle 1z0-182 Question Answer
Which two are benefits of external tables?
They support DELETEs, which transparently deletes records in the file system as if they were table rows.
They can be queried while the database is in the MOUNT state like dynamic performance views.
They support UPDATEs, which transparently updates records in the file system as if they were table rows.
They can be queried, transformed, and joined with other tables without having to load the data first.
The results of a complex join or aggregating function or both can be unloaded to a file for transportation to other systems.
A.False. External tables are read-only; no DELETE.
B.False. Require OPEN state, unlike V$ views.
C.False. No UPDATE support; read-only.
D.True. Queryable like regular tables without loading.
E.True. Data Pump can unload query results to files.
TESTED 16 Jul 2025
Copyright © 2014-2025 ACE4Sure. All Rights Reserved