How many different types of indexes we have in oracle?

Answers were Sorted based on User's Feedback



How many different types of indexes we have in oracle?..

Answer / sathish

B TREE INDEX
FUNCTION BASED INDEX
REVERSE KEY INDEX
BIT MAP INDEX

Is This Answer Correct ?    1 Yes 0 No

How many different types of indexes we have in oracle?..

Answer / rohit

In Oracle there are two types of SQL index namely, implicit and explicit.
Implicit Indexes:
They are created when a column is explicity defined with PRIMARY KEY, UNIQUE KEY Constraint.
Explicit Indexes:
They are created using the "create index.. " syntax.
NOTE:
1) Even though sql indexes are created to access the rows in the table quickly, they slow down DML operations like INSERT, UPDATE, DELETE on the table, because the indexes and tables both are updated along when a DML operation is performed. So use indexes only on columns which are used to search the table frequently.
2) Is is not required to create indexes on table which have less data.
3) In oracle database you can define up to sixteen (16) columns in an INDEX.

Is This Answer Correct ?    1 Yes 0 No

How many different types of indexes we have in oracle?..

Answer / shankar

1.B-tree indexes:
B-tree indexes have the following subtypes:
Index-organized tables
Reverse key indexes
Descending indexes
B-tree cluster indexes
2.Bitmap and bitmap join indexes
3.Function-based indexes
4.Application domain indexes

Is This Answer Correct ?    0 Yes 0 No

How many different types of indexes we have in oracle?..

Answer / subrahmanayam

6

Is This Answer Correct ?    18 Yes 25 No

Post New Answer

More Oracle General Interview Questions

What is Oracle table?

1 Answers  


Write a syntax for update query in oracle?

0 Answers  


What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

0 Answers   MCN Solutions,


What do you know about normalization? Explain in detail?

0 Answers  


select statement does not retrieve any records. what exception is raised?

2 Answers  


How can you merge two tables in oracle?

0 Answers  


What is the fastest query method to fetch data from the table?

0 Answers  


Define 'view' advantage ?

2 Answers   AZTEC, TCS,


What a SELECT FOR UPDATE cursor represent.?

1 Answers  


What privilege is needed for a user to delete rows from tables in another schema?

0 Answers  


Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks

2 Answers  


How do I manually create a database in oracle?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1808)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)