How many different types of indexes we have in oracle?

Answer Posted / nimisha

Implicit index and Explicit index.

Is This Answer Correct ?    63 Yes 29 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the disadvantage of User defind function?

2037


Please explain joins in oracle?

813


How to establish administrator authentication to the server?

783


what is port in oracle? how is it related to database application.

1698


List out the types of joins.

852


What is data type in oracle?

780


What the is the diff between local index and global index. give some example.

1379


Explain about achiever in sql?

802


What is oracle and what are its different editions?

793


A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

4910


What is system global area (sga) in oracle?

779


How to connect to oracle using service name instead of sid?

786


Can a formula column be obtained through a select statement ?

2101


How do you find out from the RMAN catalog if a particular archive log has been backed-up?

1880


What is the maximum number of triggers that can be applied to a single table?

779