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 find out the current date and time in oracle?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What is the difference between substr and instr?
What is system global area (sga) in oracle?
What are the different types of trigger and explain its various uses and functions?
Explain the use of parfile option in exp command.
How do you tell what your machine name is and what is its IP address?
What is the purpose of save points in oracle database?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
Explain the use of compress option in exp command.
How to create a new tablespace in oracle?
State all possible different index configurations a table can possibly have?
What is oracle analytical function?
What do you mean by redo log file mirroring?