Interested to Buy Any Domain ? << Click Here >> for more details...
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
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
How to start instance with a minimal initialization parameter file?
What are the attributes that are found in a cursor?
What is connection pooling in oracle?
What are oracle functions?
Explain what are the different type of segments?
Explain an extent?
How to build data dictionary view an new database?
What is the difference between view and materialized view in Oracle?
Briefly explain what is literal? Give an example where it can be used?
How do I escape a reserved word in oracle?
What is materialized view in Oracle?
How to use existing values in update statements using oracle?
how to handle exceptions in post production
How many types of database triggers exist?
