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

What happens to the current transaction if the session is killed?

1033

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2165

---

What is the relation of a user account and a schema?

1173

---

How to define a variable of a specific record type?

1113

---

How to define an anonymous procedure with variables?

1236

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1436

---

What is the recommended interval at which to run statspack snapshots, and why?

2962

---

How to open and close an explicit cursor in oracle?

1094

---

What is java oracle used for?

1075

---

what is dynamic SGA and static SGA

4482

---

How can we create the complete backup of data in the oracle.

2199

---

Is there an oracle sql query that aggregates multiple rows into one row?

1021

---

Explain mutating triggers.

1088

---

how to do daily transactions with out sql* loader control file regesterd in apps?

1727

---

if you ctreate table identity

2427

---