Oracle Database SQL — Question 68

Which three statements are true about external tables? (Choose three.)

Answer options

• A. They can be temporary tables.
• B. DML statements can modify them.
• C. They can be used in queries containing joins.
• D. They can be used in queries containing sorts.
• E. They can be indexed.
• F. Their metadata is stored in the database.

Correct answer: C, D, F

Explanation

The correct answers C, D, and F highlight that external tables can be utilized in join and sort operations and that their metadata is maintained in the database. Options A, B, and E are incorrect as external tables are not designed to be temporary, cannot be modified by DML statements, and cannot be indexed.