Answer Posted / santhoshkavi

its a process of analysing the given relation schems based
on their functional dependencies and primary key to achieve
the properties
1.minimizing redundancy
2.minimizing insertion, deletion and update anamolies
types:
1NF
2NF
3NF

What is meant by a deadlock situation?

1109

---

is there a tool to trace queries, like profiler for sql server?

1141

---

Which is better Oracle or MS SQL? Why?

6386

---

Why does oracle 9i treat an empty string as null?

1056

---

What is a package ? What are the advantages of package ?

1091

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2970

---

Explain rename?

980

---

How can windows applications connect to oracle servers?

1057

---

State the difference between a primary key and foreign key?

935

---

How to assign data of the deleted row to variables?

1075

---

How do I spool to a csv formatted file using sqlplus?

1033

---

What is parameterized cursor in oracle?

1150

---

How do I find the database name in oracle?

1037

---

How to view the tablespaces in the current database?

978

---

Is java required for oracle client?

999

---