Which two tasks can be performed on an external table?

The correct answer is D. creating a public synonym E. creating a view. You can, for example, select, join, or sort external table data. You can also create views and synonyms for external tables. However, no DML operations (UPDATE, INSERT, or DELETE) are possible, and no indexes can be created, on external tables.

Managing Schema Objects

Question

Options

Apartitioning the table
Bcreating an invisible index
Cupdating the table by using an update statement
Dcreating a public synonym
Ecreating a view

How the community answered

(61 responses)

A
2% (1)
B
5% (3)
C
2% (1)
D
92% (56)

Explanation

You can, for example, select, join, or sort external table data. You can also create views and synonyms for external tables. However, no DML operations (UPDATE, INSERT, or DELETE) are possible, and no indexes can be created, on external tables.

Topics

#external tables#synonyms#views#data manipulation limitations

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice