Answer / guest

A.OLTP
B.DSS
C.Where clause has functions
D.Tables that have only one record

Answer / 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);

what are different types of keys in sql?

0 Answers  

---

I need a exceptoin in pl/sql block so that if any errors occur in the block then no exception should errors should raise?

1 Answers  

---

Why are sql stored procedures used?

0 Answers  

---

How do you create an update query?

0 Answers  

---

What are the two types of exceptions.

0 Answers  

---

If an unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?

4 Answers  

---

define sql delete statement ? : Sql dba

0 Answers  

---

Is sql a backend language?

0 Answers  

---

How to create a view on a table which does not exists

4 Answers   Oracle, TCS,

---

Can you have a foreign key without a primary key?

0 Answers  

---

Why do we use cursors?

0 Answers  

---

How the execution will be done in exceptions?

2 Answers  

---