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
Why do we use coalesce function in oracle?
How to delete multiple rows from a table in oracle?
What is an index associated with a constraint?
How many memory layers are in the oracle shared pool?
How to pass parameters to procedures in oracle?
How to get execution statistics reports on query statements?
When system tablespace is created?
Which is better Oracle or MS SQL? Why?
How much memory your 10g xe server is using?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What are the ways tablespaces can be managed and how do they differ?
How to convert character types to numeric types?
How to Truncate Table in Oracle
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
Explain do view contain data?
