Answer Posted / lakshmi

Database normalization is a technique for designing
relational database tables to minimize duplication of
information and, in so doing, to safeguard the database
against certain types of logical or structural problems,
namely data anomalies.

For example, when multiple instances of a given piece of
information occur in a table, the possibility exists that
these instances will not be kept consistent when the data
within the table is updated, leading to a loss of data
integrity. A table that is sufficiently normalized is less
vulnerable to problems of this kind, because its structure
reflects the basic assumptions for when multiple instances
of the same information should be represented by a single
instance only.

How to define a record variable to store a table row?

1002

---

What is oracle data type?

901

---

What is the difference between sharding and replication?

954

---

How would you change old and new values in an insert, delete and update triggers?

950

---

How to run the anonymous block again?

1065

---

Can group functions be mixed with non-group selection fields?

954

---

What is oracle update statement with inner join ?

992

---

How to find out what oracle odbc drivers are installed?

977

---

How to change user password in oracle?

973

---

What is oracle rownum?

886

---

What is the data pump export utility?

1021

---

Is insert autocommit in oracle?

1016

---

What is a read write transaction in oracle?

1030

---

 What are the oracle DML commands possible through an update strategy?

1004

---

What are data pump export and import modes?

1015

---