Answer Posted / hitendra yadav

If there is very less cardinality (i.e. 1% of total column
values) or distinct values in column then we have to create
BITMAP index for that column like GENDER column will always
have 2 values MALE or FEMALE.

Syntex:-

Create bitmap index index_name on table_name(column_name);

Is sqlite thread safe?

993

---

What is difference between procedure and trigger?

919

---

what is sql profiler? : Sql dba

997

---

What is the difference between between and in condition operators?

940

---

What is a behavioral trigger?

932

---

Which one is better subquery or joins?

1010

---

What are the different sql languages?

987

---

Does mysql support pl sql?

1099

---

Does sql*plus have a pl/sql engine?

997

---

How to sort the rows in sql.

1011

---

Why is there a need for sqlcode and sqlerrm variables?

999

---

What types of commands can be executed in sql*plus?

1051

---

how to write date and time literals? : Sql dba

915

---

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

1098

---

What are the advantages of sql?

1008

---