Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / suresh somayajula
Index is used to solve some query fast.
we have 2 types of cursors.
1 Bitmap Index ( used only on Low cardinality columns)
2. Btree Index ( used only for High Cardinality of
columns)
| Is This Answer Correct ? | 8 Yes | 18 No |
Post New Answer View All Answers
How to create a new view in oracle?
What is a synonym? What are its various types?
How to create a single index for multiple columns?
Explain the use of compress option in exp command.
Can the query output be sorted by multiple columns in oracle?
Is there a combination of "like" and "in" in sql?
What is Data Dictionary Cache in Oracle?
How do we get field detail of a table?
How to delete a column in an existing table?
What is execute immediate in oracle?
Can we write dml statement in function in oracle?
Is there any function in oracle similar like group_concat of mysql?
State and explain about oracle instance?
Why does for update in oracle 8 cause an ora-01002 error?
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
