Answer Posted / ron

Note:
1. data is normalized in oltp systems
( are of different forms :1NF, 2NF, 3NF, BCNF, 4NF,
5NF,DKNF,6NF)
2. when it comes to olap/datawarehouse/dss sytems data is
generally de-normalized. (N1NF, PNF).

there is always a trade-off to consider between data
redundancy vs performance

Give the different types of rollback segments.

1031

---

How to increment dates by 1 in oracle?

1093

---

What is query image?

985

---

How to create a single index for multiple columns?

1040

---

What are the types of partitions in oracle?

1038

---

What is an oracle data file?

1105

---

How to call a sub procedure?

1099

---

How to create tables for odbc connection testing?

1120

---

Is oracle the best database?

967

---

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4175

---

Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

2188

---

What is blob datatype?

1133

---

How to create a new view in oracle?

1078

---

How will you differentiate between varchar & varchar2?

1045

---

What is Java Pool in Oracle?

1174

---