1-
|
____ use both applications and direct means to access the ____ of the DBMS
|
|
A -
|
data modelers, runtime modeling tools
|
|
B -
|
developers, design tools
|
|
C -
|
end user, database
|
|
D -
|
end users, metadata
|
2-
|
A telephone number would be stored in a ___
|
|
A -
|
memo
|
|
B -
|
computed
|
|
C -
|
text
|
|
D -
|
date
|
3-
|
A database can be accessed by:
|
|
A -
|
data entry personnel
|
|
B -
|
programmers
|
|
C -
|
the DBA
|
|
D -
|
All of the others are correct
|
4-
|
A Custom setup type is required to #
|
|
A -
|
Code samples
|
|
B -
|
Full-text search
|
|
C -
|
Local system account
|
|
D -
|
SQL Authentication Mode
|
5-
|
A database is an organized collection of ____related data.
|
|
A -
|
badly
|
|
B -
|
logically
|
|
C -
|
physically
|
|
D -
|
not
|
6-
|
A primaty key is:
|
|
A -
|
a candidate key
|
|
B -
|
All of the above
|
|
C -
|
used to represent rows in relationships
|
|
D -
|
used to identify unique rows
|
7-
|
A database management system is software which
|
|
A -
|
All of the others
|
|
B -
|
Provides recovery and access limitation features
|
|
C -
|
Provides a data dictionary feature
|
|
D -
|
Provides a range of data integrity facilities
|
8-
|
A DBMSs features and functions are grouped into these three subsystems: *
|
|
A -
|
Runtime, schema, design tools
|
|
B -
|
DBMS engine, data model, application programs
|
|
C -
|
Indexes, design tools, metadata
|
|
D -
|
Design tools, run time, DBMS engine
|
9-
|
A Distributed Database enivoment
|
|
A -
|
(a) servers to share data with each other; requires a network or connection to be effective
|
|
B -
|
All of the others
|
|
C -
|
Permits physical isolation of each server
|
|
D -
|
Maintains logical connection of the servers involved
|
10-
|
A relational database is:
|
|
A -
|
a collection of forms and reports that support a given purpose
|
|
B -
|
a set of applications and the data sets for those applications
|
|
C -
|
a selt-describing collection of related tables
|
|
D -
|
a library of queries and data files for quer
|