Examice

Exam 1z0-071 All QuestionsBrowse all questions from this exam

Go to Exam

Question 185

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

They can be temporary tables.

DML statements can modify them.

They can be used in queries containing joins.

They can be used in queries containing sorts.

They can be indexed.

Their metadata is stored in the database.

Correct Answer: C, D, F

External tables can be used in queries containing joins and sorts, and their metadata is stored in the database. They cannot be temporary tables, cannot be modified using DML statements, and cannot be indexed.

Discussion

alic_alexOptions: CDF

C,D,F correct https://docs.oracle.com/cd/E18283_01/server.112/e17120/tables013.htm

SantiBZ_07032022_1744Options: CDF

I think C, D, F.

McromeoOptions: CDF

Index cannot be created on external table

dilshodOptions: CDF

CDF are true

lucemqyOptions: CDE

CDF are true