index's are used to retrive the data with in the required time.there

What is an index and types of indexes. How many number of
indexes can be used per table ?

Question Posted / naresh

Answer Posted / naresh

index's are used to retrive the data with in the required
time.there are two types of indexes we have

1.bitmap index
2.B-tree index

Is This Answer Correct ?

16 Yes

17 No

Please Help Members By Posting Answers For Below Questions

Can you have a foreign key without a primary key?

963

Is subquery faster than join?

1019

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7374

Inline the values in PL/SQL, what does it mean.?

1238

How to disable a trigger name update_salary?

1275

How can we implement rollback or commit statement in a trigger?

1043

Which function is used to return remainder in a division operator in sql?

1152

What are the types pl/sql code blocks?

1143

What is the purpose of a secondary key?

982

What does sign mean sql?

1125

Why commit is not used in triggers?

1050

What is over () in sql?

973

Determine if oracle date is on a weekend?

1052

Are subqueries better than joins?

983

Explain ttitle and btitle.

1125