Master Oracle 1z0-071 concepts! Learn about external table limitations like DML restrictions and external data storage. Ace your exam with expert insights.
Table of Contents
Question
Which two statements are true about external tables? (Choose two.)
A. DML statements cannot be used on them.
B. You can populate them from existing data in the database by using the CREATE TABLE AS SELECT command.
C. Their data can be retrieved by using only SQL or PL/SQL.
D. Indexes can be created on them.
E. Their metadata and actual data are both stored outside the database.
Answer
A. DML statements cannot be used on them.
E. Their metadata and actual data are both stored outside the database.
Explanation
External tables store data outside the database in flat files. They offer read-only access, prohibiting modifications (DML operations). Their structure and data reside externally, independent of the database.
Oracle 1z0-071 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Oracle 1z0-071 exam and earn Oracle 1z0-071 certification.