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 is SAVE POINT ?

5 Answers  

---

how to i write the query 'NISHI' TO N I S H I

4 Answers   Attra, Metric Stream,

---

Explain do view contain data?

0 Answers  

---

How to write a query with an inner join in oracle?

0 Answers  

---

How to get a list of all background sessions in the database?

0 Answers  

---

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

1 Answers   MasterCard,

---

How to load data through external tables?

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  

---

Explain the use of tables option in exp command.

0 Answers  

---

What is user managed backup in Oracle?

0 Answers   MCN Solutions,

---

what is the syntax of SELECT command?

6 Answers  

---

Difference between NO DATA FOUND and %NOTFOUND?

1 Answers  

---