Answer Posted / sahaja mallarapu
A View is a data base object also called as virtual table
which is created on a select statement.
A view can be created using multiple tables.
A view is stored in a temporary memory.
An index is also a DB Object which is used to increase
query performance and index is created based on columns of
a table.
An index is created on multiple columns but on a single
table.
Index is maintained by Oracle Server itself.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
How do I spool in oracle?
Explain a segment?
What is open database communication (odbc) in oracle?
Who developed oracle & when?
What is dual table oracle?
What do you mean by cdb and pdb in oracle 12c?
Will you be able to store pictures in the database?
What suggestions do you have to reduce the network traffic?
How to recover a dropped table in oracle?
How many types of table in Oracle?
What is a sub query? What are its various types?
What happens if you lost a data file?
How to retrieve values from data fields in record variables?
What are the differences between char and varchar2 in oracle?
What is bulk collect in oracle?