Google Interview Question

External tables. Can they have indexes

Interview Answers

Anonymous

May 16, 2018

Actually you answered incorrectly. External tables in Oracle are read only and cannot have indexes built upon them. Their main use is a data source for more traditional Oracle table structures.

1

Anonymous

Jun 11, 2013

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