3-55.
3-56.
3-57.
3-58.
3-59.
A named collection of
records that need not
preserve owner/member
relationships is called a/an
1.
set
2.
area
3.
data item
4.
database key
A database consists of all
of the following items
controlled by a specific
schema except which one?
1.
Sets
2.
Areas
3.
Files
4.
Records
The data manipulation
language relies on which of
the following language types
to provide the procedural
capabilities required to
manipulate data?
1.
Host
2. Query
3.
Application
4.
DDL
After the database physical
description has been
examined,
which of the
following items keys the
actual physical record to be
read?
1.
DDL
2.
DBMS
3.
The object program
4.
The console operator
When data has been requested
by a DBMS, to which of the
following areas does the
operating system deliver the
requested data from the
database?
1.
User work area (UWA)
2.
System buffers
3.
DBMS
4.
DMS
25
3-60.
After the operating system
has transferred data to the
system buffer area, where
does the DBMS deliver the
data to be used by a source
program?
1.
To a system work disk
2.
To a system work tape
3.
To the user work area
(UWA)
4.
To system buffer areas 1
and 2
3-61.
A schema data definition
language (DDL) entry
includes references to a
physical device or media
space.
1.
True
2.
False
3-62.
Which of the following items
is/are contained in a DDL?
1.
Literal formatting only
2.
Key words only
3.
Reserved words only
4.
Literal formatting, key
words,
and reserved
words
3-63.
To specify the relationship
between DDL declarations and
DML commands, a set of basic
data manipulation functions
must be defined that is
independent of which of the
following languages?
1.
DML only
2.
Host language only
3.
DML and the host
language
4.
DDL