what are database files, control files and log files. How many of these files should a database have at least? Why?

878

---

What is denormalization and why would someone consider doing so?

968

---

What is buffer manager?

927

---

How view is related to data independence?

987

---

How are exceptions handled in pl/sql? Give some of the internal exceptions name?

1023

---

What is system catalog or catalog relation?

1091

---

What are some disadvantages of a standard language such as sql?

900

---

Describe the difference between data and database administration.

1154

---

What is natural key?

997

---

What is system r?

974

---

What is a distributed database?

1052

---

Name two utilities that oracle provides, which are use for backup and recovery.

903

---

Explain a join between tables?

1049

---

What is partial key?

1068

---

Can two oracle blocks have the same address?

1037

---