what are indexes..how many types of index's are there and
what are they?
Answer Posted / rudrab123
An index is a listing of keywords accompanied by the
information of location of the subject.
in a SQL statement, if there is no Where clause then there
is no index.
In Oracle 8i,
there are 4 types of indexes .They are:-
1.B-Tree Index
2.Bitmap Index
3.Unique index
4.Function based index.
Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
Explain the use of record option in exp command.
Where do we use decode and case statements?
How to update a table row with a record?
How do I find my oracle client driver version?
What is a nvl function?
How would you begin to troubleshoot an ORA-3113 error?
Can we store images in oracle database?
What is the difference between translate and replace?
What is the parameter mode that can be passed to a procedure?
What do you mean by a deadlock?
query optmization techniques and quwry analyser+projects+ppts
Can a formula column be obtained through a select statement ?
Explain what are the characteristics of data files?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How to start a new transaction in oracle?