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 can we force the database to use the user specified rollback segment?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What is the difference between a user and a schema in oracle?
Can group functions be used in the order by clause in oracle?
How to write text literals in oracle?
How can you use check constraints for self referential integrity?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
How translate command is different from replace?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How to assign a table row to a record variable?
What is the difference between PFILE and SPFILE in Oracle?
What privilege is needed for a user to connect to oracle server?
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
What is materialized view in Oracle?
How to convert a date to char in oracle? Give one example.
