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
How to fetch the row which has the max value for a column?
What is truncate oracle?
What is Library Cache in Oracle?
What are the set operators union, union all, minus & intersect meant to do?
Why does oracle 9i treat an empty string as null?
Explain about your project and its relation to the current job position you are applying to?
How do I limit the number of rows returned by an oracle query after ordering?
What is oracle open database communication (odbc)?
what's query optimization and without use of IN AND Exist can we get another way data from query
How to use "in out" parameter properly?
How to pass parameters to procedures in oracle?
How to use group functions in the select clause using oracle?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
How to check the server version in oracle?
What is the recommended interval at which to run statspack snapshots, and why?
