Answer Posted / rajaram gupta

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 would you begin to troubleshoot an ORA-3113 error?

2122

---

What are the components of logical database structure in oracle database?

1132

---

Give syntax for SQL and ORACLE joins.

1144

---

Explain the use of constraints option in exp command.

1079

---

How do I uninstall oracle client from windows?

1055

---

How to define an external table with a text file?

1122

---

What is the use of oracle?

1075

---

How to create an initialization parameter file?

1101

---

What is blob data type in oracle?

1203

---

What is the maximum number of triggers that can be applied to a single table?

1067

---

What is truncate oracle?

1013

---

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

1083

---

What are the oracle built-in data types?

1134

---

How to resolve name conflicts between variables and columns?

1076

---

How to increment dates by 1 in oracle?

1134

---