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

How many rows can sqlite handle?

0 Answers  

---

How many types of normalization are there?

0 Answers  

---

how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

5 Answers   Honeywell, Interact,

---

how can we find the number of rows in a table using mysql? : Sql dba

0 Answers  

---

If I have a table T with 4 rows & 2 columns A & B. A has values 1,2,3,4. and B has 10,20,30,40. Write an Update SQL query which can Swap the values of A & B for all records. (Do not use a sub-query)

5 Answers  

---

Explain commit, rollback and savepoint.

0 Answers  

---

What are the possible values that can be stored in a boolean data field?

0 Answers  

---

How packaged procedures and functions are called from the following?

2 Answers  

---

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 Answers  

---

What is substitution variable?

0 Answers  

---

What are the types of subqueries?

0 Answers  

---

what is auto increment? : Sql dba

0 Answers  

---