Answer Posted / kannan

Defination : Normalization is the process of efficiently
organizing data in a database. There are two goals of the
normalization process: eliminating redundant data (for
example, storing the same data in more than one table) and
ensuring data dependencies make sense (only storing related
data in a table). Both of these are worthy goals as they
reduce the amount of space a database consumes and ensure
that data is logically stored. There are several benefits
for using Normalization in Database.

Benefits :

Eliminate data redundancy
Improve performance
Query optimization
Faster update due to less number of columns in one table
Index improvement

What is integrity and what is constraint??Explain with example

2280

---

what is insert all statement in sql

6512

---

What are the differences between primary key and unique key?

1008

---

Is insert autocommit in oracle?

1066

---

How to create a stored program unit?

1224

---

How to bring a tablespace online?

1076

---

What is a view and how is it different from a table?

1044

---

How to use existing values in update statements using oracle?

1065

---

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2270

---

What are the various types of snapshots ?

1027

---

What is catalog in Oracle?

1362

---

How to define an explicit cursor in oracle?

1034

---

What is memory advisor in Oracle?

1077

---

How to download oracle database 10g xe?

1016

---

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2310

---