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
What is a cursor and what are the steps need to be taken?
What is a data lock in oracle?
What is Undo Management Advisor in Oracle?
What is the use of file param in imp command?
What is using clause and give example?
Difference between inner join vs where ?
Use of an integrity constraint is better to validate data. Explain
How to create a new user account in oracle?
What types of joins are used in writing subqueries?
How to set a transaction to be read only in oracle?
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
What to do if the binary spfile is wrong for the default instance?
What is raw datatype?
How to define default values for formal parameters?
Explain drop constraint oracle?
