Which two tasks can be performed on an external table? (Choose two.)
- A.partitioning the table
- B.creating an invisible index
- C.updating the table by using an update statement
- D.creating a public synonym
- E.creating a view
oracle · 1z0-062 · Q603 · multiple_response · topic_1
Which two tasks can be performed on an external table? (Choose two.)
Explanation
http://docs.oracle.com/cd/B28359_01/server.111/b28310/tables013.htm#ADMIN01507
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.
Reference: examtopics_answer_description
Practice with progress tracking
Sign in to track wrong answers, get spaced-repetition reminders, and run timed exam mode.