Database Reference
In-Depth Information
9d.
How important is the system catalog in a DBMS? Describe
three important tables that are usually included in the
system catalog (use the Oracle DBMS as a frame
of reference).
{06}
9e.
Given the information provided in Figure
26-9
, illustrate
what might be the contents of one of the catalog tables
mentioned in (9d) above. Explain how the system
catalog is maintained.
{03}
26.13 Sample Final Examination B
This examination consists of four (4) sections. You are required to do all questions in
section A, and three additional questions — one from each of the other three sections.
Section A: Answer all questions in this section. For multiple-choice questions, simply
highlight the responses that you deem to be correct.
1.
State six significant objectives of a database system.
{06}
a.
b.
c.
d.
e.
f.
2.
State three advantages of a database system.
{03}
a.
b.
c.
3.
State three primary functions of a DBMS.
{03}
a.
b.
c.
4.
Which of the following is not a valid example of a DBMS?
{01}
a.
Oracle
b.
DB2
c.
Java Development Kit
d.
Informix
