Question 7
Which two tasks can be performed on an external table? (Choose two.)
creating an invisible index
updating the table by using an update statement
creating a public synonym
Correct answer: DE
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. 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.
http://docs.oracle.com/cd/B28359_01/server.111/b28310/tables013.htm#ADMIN01507