Answer Posted / mohan

Normalization is The process of decomposing tables to eliminate data redundancy is called Normalization.

How to see the table columns used in an index?

1070

---

How to sort the query output in oracle?

1072

---

In what script is snap$ created? In what script is the scott/tiger schema created?

2758

---

Explain about integrity constraint?

1176

---

What is different types of joins?

1078

---

Explain the use of Merge statement in oracle 11g

1074

---

State all possible different index configurations a table can possibly have?

1096

---

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

2005

---

What is the difference between Delete, Truncate and Drop in Oracle?

1180

---

Can I create users through internet explorer in oracle 10g?

1154

---

What are temporal data types in oracle?

1164

---

What privilege is needed for a user to create indexes in oracle?

1078

---

Can sub procedure/function be called recursively?

1045

---

What is tns entry?

1234

---

What are a collation and state the different types of collation sensitivity?

1233

---