Which two tasks can be performed on an external table?
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
Explanation:
Which two tasks can be performed on an external table?
Which two tasks can be performed on an external table?
http://docs.oracle.com/cd/B28359_01/server.111/b28310/tables013.htm#ADMIN01507
Correct Answer will be D and E.
No DML is not allowed on External Table
No Index can be created on External Table
D,E
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.
D E
I think D – E are correct
D-E correct, I think
http://docs.oracle.com/database/121/ADMIN/tables.htm#i1007424
DE
Very handful of web sites that occur to be in depth below, from our point of view are undoubtedly effectively really worth checking out.
DE
D,E
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.