Answer Posted / gaurav agrawal

Database normalization is a data design and organization
process applied to data structures based on rules that help
building relational databases. In relational database
design, the process of organizing data to minimize
redundancy is called normalization. Normalization usually
involves dividing a database into two or more tables and
defining relationships between the tables. The objective is
to isolate data so that additions, deletions, and
modifications of a field can be made in just one table and
then propagated through the rest of the database via the
defined relationships.

What is not equal to in oracle?

1001

---

When system tablespace is created?

1041

---

What do database buffers contain?

1029

---

What is the parameter mode that can be passed to a procedure?

1045

---

Can sub procedure/function be called recursively?

1001

---

Write a syntax for update query in oracle?

1034

---

WHAT IS ecc 6.0

2147

---

Explain the truncate in oracle?

966

---

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2043

---

How do we display rows from the table without duplicates?

972

---

What is the dynamic sql in oracle?

1071

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

1987

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4520

---

Write a trigger example in oracle?

1061

---

What is bulk collect in oracle?

996

---