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.

Show how functions and procedures are called in a pl/sql block.

766

---

How many sql statements are used?

743

---

What are triggers and its uses?

786

---

How delete a row in sql?

717

---

How will you distinguish a global variable with a local variable in pl/sql?

839

---

---

What is graph sql?

721

---

What does subquery mean in sql?

739

---

Cite the differences between execution of triggers and stored procedures?

824

---

what are the disadvantages of mysql? : Sql dba

761

---

what is foreign key? : Sql dba

750

---

Is sqlexception checked or unchecked?

723

---

Explain what is an index?

759

---

How to sort the rows in sql.

810

---

what is the syntax for using sql_variant_property? : Transact sql

704

---

How do I remove all records from a table?

764

---