Answer Posted / satendra

Bit map Indexes are used with the columns having low
cardianality like Gender(M/F),Marital Status.The benefit of
it is that it requires a small space comapred to the case
if a B-Tree index is created on the same column of the
table.
Bit map Indexes are useful in the systems where data is not
getting updated frequently.

Why triggers are used?

995

---

What do we need to check in database testing?

1029

---

What is cursor status?

1193

---

Why is sql*loader direct path so fast?

1112

---

Which are the different character-manipulation functions in sql?

1075

---

How to place comments in pl/sql?

1170

---

What is write ahead logging in sql server?

1059

---

Can we update views in sql?

943

---

What is serial sql?

985

---

What is 19 null in sql?

979

---

What do you mean by rowid?

987

---

Mention what is the use of function "module procedure" in pl/sql?

1056

---

What is difference between inner join and cross join?

978

---

How do I view tables in mysql?

989

---

what are the 'mysql' command line options? : Sql dba

1079

---