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
Design database draw er diagram for a certain scenario ?
How to write a left outer join with the where clause in oracle?
What is oracle latest version?
How to select all columns of all rows from a table in oracle?
How to start an oracle instance?
How to use values from other tables in update statements using oracle?
How to put more than 1000 values into an oracle in clause?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
