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 scalar functions in sql?

1 Answers  

---

Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.

5 Answers   Thomson,

---

How many joins can you have in sql?

1 Answers  

---

what is sql.

7 Answers   Ericsson, Hewitt,

---

select 10 from dual; y its showing all the rows with 10?

1 Answers  

---

What is the purpose of the partition table?

1 Answers  

---

Explain the concept of normalization.

3 Answers  

---

How to start the command-line sql*plus?

1 Answers  

---

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

1 Answers  

---

What are instead of triggers?

1 Answers  

---

Explain table and field in sql?

1 Answers  

---

What is trigger explain it?

1 Answers  

---