Answer / sathish

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

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.

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

Answer / subrahmanayam

6

What are the general rules on data consistency?

0 Answers  

---

What is a heap related to database ?

1 Answers   TCS, University of Edinburgh,

---

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

2 Answers  

---

How to create an initialization parameter file?

0 Answers  

---

What is tns service name?

0 Answers  

---

Define Normalization with example?

1 Answers  

---

How to delete a column in an existing table?

0 Answers  

---

if you ctreate table identity

0 Answers  

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

0 Answers  

---

How many types of auditing in Oracle?

0 Answers   MCN Solutions,

---

What are the type of Synonyms?

1 Answers  

---

types of indexes and the rationale behind choosing a particular index for a situation.

0 Answers  

---