Database Reference
In-Depth Information
5b.
Complete the following triplets with the most appropriate
words or expressions to be taken from the list provided
below (Figure
26-7
).
{10}
Figure 26-7.
Database Terminology Puzzle
26.12 Sample Final Examination A
This examination consists of nine (9) questions distributed over four (4) sections. You are
required to do four (4) questions, but no more than one question from a section.
Section A: Do all questions from this section.
1.
1a.
What are the main components of a database system?
With the aid of a diagram, show how they are related. {10}
1b.
State six (6) objectives of a database system.
{06}
1c.
Give four (4) examples of popular DBMS suites.
{04}
2.
2a.
Briefly clarify the terms
external schema
,
conceptual schema
and
internal schema.
By use of an appropriate diagram,
show how the three terms are related.
{10}
2b.
Explain what is meant by
data sub-language (DSL)
,
data
definition language (DDL)
and
data manipulation language
(DML)
. How does SQL relate to these terms?
{04}
