Oracle
1Z0-071 · Question #397
Which three statements are true about external tables? (Choose three.)
The correct answer is C. They can be used in queries containing joins. E. They can be used in queries containing sorts. F. Their metadata is stored in the database. https://oracle-base.com/articles/9i/external-tables-9i https://docs.oracle.com/html/E25494_01/tables013.htm
Managing Schema Objects
Question
Which three statements are true about external tables? (Choose three.)
Options
- ADML statements can modify them.
- BThey can be temporary tables.
- CThey can be used in queries containing joins.
- DThey can be indexed.
- EThey can be used in queries containing sorts.
- FTheir metadata is stored in the database.
How the community answered
(43 responses)- A9% (4)
- B2% (1)
- C74% (32)
- D14% (6)
Explanation
https://oracle-base.com/articles/9i/external-tables-9i https://docs.oracle.com/html/E25494_01/tables013.htm
Topics
#external tables#DML restrictions#metadata storage#query capabilities
Community Discussion
No community discussion yet for this question.