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.

List the various oracle database objects?

599

---

Why do you use stored procedures and state some of its disadvantages?

565

---

what is a Nested Loop join?

1568

---

What is Reduced List of Values?

1708

---

Is oracle a programming language?

568

---

---

How to call a stored function in oracle?

574

---

What is clustered table in Oracle?

643

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1833

---

How to define a specific record type?

624

---

Name the various constraints used in oracle?

566

---

How to store only time; not date and time?

557

---

Explain how are indexes update?

623

---

What is an Oracle Instance?

687

---

How to sort output in descending order in oracle?

578

---

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

1656

---