Google

www.google.com

Interview Question

Oracle Database Administrator Interview New York, NY

External tables. Can they have indexes

Answer

Interview Answer

2 Answers

0

I said yes. Though I mentioned that I hadn't worked with external tables extensively

Interview Candidate on Jun 11, 2013
0

External Tables doesn't reside in the database and you can select, join or sort external table data and also you can create views and synonyms on it but you can neither perform DML operations nor you can have indexes for EXTERNAL TABLES.

Sunney on Aug 28, 2013

Add Answers or Comments

To comment on this, Sign In or Sign Up.