Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
1.
|
What
is Access?
a. | A text
manipulator | b. | A word processor | c. | A
database | d. | A presentation software | | |
|
|
|
2.
|
Data
management is a discipline that focuses on
a. | the management of end users. | b. | the proper
generation, storage, and retrieval of data. | c. | the help items
to be used by end users. | d. | the proper generation, storage, and retrieval of
information. | | |
|
|
|
3.
|
DBMSs
are important because
a. | we need good ways of managing such
data. | b. | they contain a query language that makes it possible to produce
ad hoc queries. | c. | they help create an environment for end users to have access to
more data. | d. | All of the above | e. | None of the
above | | |
|
|
|
4.
|
A
file system is composed of
a. | Hardware - Software - Procedure | b. | People -
Hardware - Data | c. | Procedures - Hardware - Software -
Data | d. | Procedures -
Hardware - Software - Data - People | | |
|
|
|
5.
|
The
DBMS can be classified according to
a. | number of users. | b. | database site
location(s). | c. | expected type and extent of use. | d. | all of the
above. | | |
|
|
|
6.
|
A
database is an efficient way to ___________________related data.
a. | enter | b. | maintain | c. | retrieve | d. | all of the above | | |
|
|
|
7.
|
Which
of the following could be defined as a field in a database?
a. | Customer_Name | b. | Address | c. | Phone_Number | d. | all of the above | | |
|
|
|
8.
|
All
fields for a specific entity can be grouped together as a(n)
a. | object. | b. | element. | c. | table. | d. | database. | | |
|
|
|
9.
|
The
Access DBMS allows you to create structure containing
a. | fields. | b. | tables. | c. | relationships. | d. | all of the above | e. | none of the
above | | |
|
|
|
10.
|
A
relational database is a group of
a. | common fields. | b. | field
values. | c. | records. | d. | related
tables. | | |
|
|
|
11.
|
A
relational database data is organized as
a. | a collection of records. | b. | a collection of
common fields. | c. | elements. | d. | tables. | | |
|
|
|
12.
|
DBMS
allows you to extrapolate information from your data by using a
a. | query
language. | b. | table generator. | c. | report
generator. | d. | wizard. | | |
|
|
|
13.
|
Most
DBMS are referred to as _____________database management systems.
a. | elemental | b. | linked | c. | hierarchical | d. | relational | | |
|
|
|
14.
|
Which
of the following is NOT an example of an Access object?
a. | form | b. | report | c. | query | d. | toolbar | | |
|
|
|
15.
|
A
Data processing (DP) specialist is in existence because of
a. | the increase in
the number of computers. | b. | the advent of database management
systems. | c. | the need to convert manual files to a matching computer file
system. | d. | the need to speed up processing of
data. | | |
|
|
|
16.
|
The
content of any given field is the
a. | database. | b. | field
value. | c. | entity. | d. | table. | | |
|
|
|
17.
|
Which
of the following could not be defined as a field in a database?
a. | FIRST_NAME | b. | ADDRESS_1 | c. | STATE | d. | ZIP CODE | e. | all of the
above | | |
|
|
|
18.
|
A
field, or a combination of fields, that has a unique value is a
a. | foreign
key. | b. | primary
key. | c. | relation. | d. | table. | | |
|
|
|
19.
|
A
primary key
a. | consists of only
one field. | b. | has the same value for all records. | c. | must contain a
unique value for each record within the table. | d. | is defined
automatically. | | |
|
|
|
20.
|
A
foreign key must
a. | be numeric. | b. | be
unique. | c. | be defined in all tables within the
database. | d. | match the field value of a primary key in a related
table. | | |
|
|
|
21.
|
Using
a CUSTOMER database, what would not be an appropriate report for the sales
department?
a. | Monthly
summaries of amounts of insurance sold by each agent. | b. | Report on agent
travel expenses. | c. | Report that analyzes the ratios of insurance types sold by each
agent. | d. | Monthly checks to determine which customers must be contacted
for renewal. | | |
|
|
|
22.
|
Of
the languages listed below, which is NOT considered a third generation language
(3GL)?
a. | Common
Business-Oriented Language (COBOL) | b. | Beginner's All-purpose Symbolic Instruction Code
(BASIC) | c. | Report Program Generator (RPG) | d. | FORmula
TRANslation (FORTRAN) | | |
|
|
|
23.
|
Of
the following, what is NOT considered Data Anomalies?
a. | Inconsistency | b. | Modified | c. | Insertion | d. | Deletion | | |
|
|
|
24.
|
Of
the following, what is NOT considered a software?
a. | System
administrators | b. | Data Base Management System | c. | Operating
Systems | d. | Application and Utilities | | |
|
|
|
25.
|
Of
the database system environment, which of the following is not considered part of the people
component?
a. | Salesmen | b. | Administrators | c. | Designers | d. | End Users | | |
|
|
|
26.
|
DBMS
performs several important functions that guarantee the integrity and consistency of the data in the
database. Which of the following is NOT one of those functions?
a. | Directory
management | b. | Storage management | c. | Data
Reports | d. | Security management | | |
|
|
|
27.
|
DBMS
performs several important functions that guarantee the integrity and consistency of the data in the
database. Which of the following is NOT one of those functions?
a. | Multiuser access
control | b. | Data integrity management | c. | Database access
languages | d. | End of month reports | | |
|
|
|
28.
|
DBMS
performs several important functions that guarantee the integrity and consistency of the data in the
database. Which of the following is NOT one of those functions?
a. | Communication
interfaces | b. | Transformation and presentation | c. | Backup and
Recovery | d. | Data verification | | |
|
|
|
29.
|
A
database model is a collection of logical constructs used to represent the data structure and
relationship. Database models are
a. | conceptual. | b. | conceptual and
Relationship. | c. | conceptual and Implementation. | d. | implementation
and relationship. | | |
|
|
|
30.
|
The
most important advantages of the hierarchical database model are
a. | conceptual
simplicity, security, integrity, diversity, and security. | b. | security,
efficiency, diversity, simplicity, and integrity. | c. | integrity,
efficiency, diversity, independence, and simplicity. | d. | conceptual
simplicity, security, independence, integrity, and efficiency. | | |
|
|
|
31.
|
Using
network terminology, a relationship is called a(n)
a. | member. | b. | owner. | c. | set. | d. | table. | | |
|
|
|
32.
|
The
Access DBMS allows you to create database structures containing
a. | table
relationships. | b. | tables. | c. | fields. | d. | all of the above | | |
|
|
|
33.
|
The
Hierarchical database model is based on
a. | tree structure. | b. | lack of a parent
segment. | c. | lack of a child segment. | d. | none of the
above | | |
|
|
|
34.
|
The
hierarchical database model uses the hierarchic sequence that always starts at
a. | the right side
of the tree. | b. | the left side of the tree. | c. | the top of the
tree. | d. | the bottom of the tree. | | |
|
|
|
35.
|
The
hierarchical database model depicts a set of _______________relationship.
a. | many to
one | b. | one to
one | c. | one to
many | d. | many to
many | | |
|
|
|
36.
|
Given
its parent/child structure, the hierarchical models yields integrity and consistency; there cannot
be
a. | a parent without
a child. | b. | a large amount of data. | c. | a child without
a parent. | d. | many transactions. | | |
|
|
|
37.
|
The
hierarchical database is very efficient when
a. | handling large amounts of data. | b. | handling little
amounts of transactions. | c. | handling many transactions. | d. | a and
b | e. | a and
c | | |
|
|
|
38.
|
The
hierarchical database models
a. | have no implementation limitations. | b. | promote data
sharing. | c. | have very strict standards. | d. | have a simple
navigational system. | | |
|
|
|
39.
|
A
relational database model
a. | does not require substantial hardware and system software
overhead. | b. | does not promote "islands of information"
problems. | c. | allows trained people to use a good system
poorly. | d. | improves implementation and management
simplicity. | e. | none of the above | | |
|
|
|
40.
|
The
object-oriented model
a. | adds semantic content. | b. | has
standards. | c. | has a simple complex navigational
system. | d. | has a low system overhead that speeds
transactions. | | |
|
|
|
41.
|
The
network database models have
a. | a navigational system that yields simple
design. | b. | a simple system that promotes
efficiency. | c. | an owner/member relationship that promotes database
integrity. | d. | a and b | e. | b and
c | | |
|
|
|
42.
|
The
entity relationship model
a. | has unlimited constraint
representation. | b. | has unlimited relationship
representation. | c. | has data manipulation language. | d. | has visual
representation that makes it an effective communications tool. | | |
|
|
|
43.
|
An ad
hoc query is
a. | a pre-scheduled
question. | b. | a spur of the moment question. | c. | a pre-planned
question. | d. | none of the above | | |
|
|
|
44.
|
Database models were developed to
a. | address the file
system's inherent weaknesses. | b. | deposit data within a single file. | c. | keep data within
multiple data repository. | d. | allow DBMS to maintain loose control over the database
activities. | | |
|
|
|
45.
|
The
DataBase Task Group (DBTG) of the Conference on Data System Languages (CODASYL)
produced
a. | standard network
specifications for a network schema. | b. | standard network specifications for a network
sub-schema. | c. | a data management language. | d. | a, b, and
c | e. | a and
c | | |
|
|
|
46.
|
The
relational database management system (RDBMS)
a. | is very
sophisticated. | b. | does not manage data structures. | c. | allows
user/designer to ignore the logical view of the database. | d. | does not manage
the details of physical storage. | | |
|
|
|
47.
|
Because RDBMS hides the system's complexity from the
user/designer,
a. | it does not exhibit data
independence. | b. | it does not exhibit structural
independence. | c. | data management is easier. | d. | data management
is very difficult. | | |
|
|
|
48.
|
Object-oriented models became popular in the 1990s as a result of
a. | fostering code
reusability. | b. | inclusion of graphics, video and
sound. | c. | supporting increasingly sophisticated
transactions. | d. | supporting complex object oriented data, process, and
procedures made possible by the increase in computer power. | e. | all of the
above | | |
|
|
|
49.
|
A
table's contents are displayed as rows and columns in
a. | a datasheet
view. | b. | a database form. | c. | the query
windows. | d. | the export window. | | |
|
|
|
50.
|
John
is working in the customer table and needs to know what customers are located in Florida. To
find the information he would
a. | create a new table. | b. | create a new
form. | c. | create a new query. | d. | utilize the
Database Wizard. | | |
|