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.

Can select statements be used on views in oracle?

1082

---

What is format trigger?

2116

---

What is Java Pool in Oracle?

1234

---

what is the difference between substr and instr function in oracle?

1138

---

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

1980

---

Explain what are the uses of rollback segment?

1064

---

What is data block in Oracle?

1148

---

How to assign data of the deleted row to variables?

1112

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2143

---

How to export several tables together?

1103

---

Explain cascading triggers.

1118

---

How to delete a column in an existing table in oracle?

1123

---

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2258

---

What are the differences between date and timestamp in oracle?

1092

---

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2110

---