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

Explain select statements in sql?

0 Answers  

---

Can you create a table with Primary Key not as the clustered index.

2 Answers   CGI,

---

How delete all records from table in sql?

0 Answers  

---

What is the most important ddl statements in sql are?

0 Answers  

---

Source is Sales Table: Sno Prod Sales Sales_Amount 1 A 10 2000 2 A 20 1000 3 C 10 3000 4 D 30 4000 5 A 20 1000 Target : Sales_Count T_Sales_Amt Sales_Count(A) T_Sales_Amt(A) 90 11000 50 4000 In single query, pls tell me.

5 Answers   CGI,

---

What is the difference between functions, procedures, and packages in pl/sql?

0 Answers  

---

What is difference between left and right outer join?

0 Answers  

---

What is scalar function?

0 Answers  

---

what are the drivers in mysql? : Sql dba

0 Answers  

---

Write a query to find the employees from EMP table those who have joined in Monday. (there is a column as hiredate which is a date column i.e values are like 03-DEC-81)

5 Answers  

---

Is clustered index a primary key?

0 Answers  

---

What is compiled query?

0 Answers  

---