COMP 5970 Session 2 Quiz - January 13, 1999
(one correct answer)
1. The __________________ consists of tools that assist the developer in creating a complete
application package.
2. The ___________________ is a fundamental part of the DBMS, which enables developers
and users to store and retrieve data.
3. Adoption of a DBMS provides benefits of:
4. The ___________________ is the heart of the DBMS, and is responsible for storing,
retrieving, and updating the data.
5. Historical trends that led to increased adoption of database methodologies include the
exponential _______ in cost for storage, along with the ______ in processor speed.
6. In a relational database:
7. A type of database that requires the user to access the database from the top level
downward is
8. A type of database containing three major data components - a name, a set of properties or
attributes, is:
9. A form of data inconsistency that occurs when multiple users utilize a data system, and the
changes of one are lost to the other are referred to as:
10. Traditional programming languages (COBOL, C++, etc.) can connect to the database using:
11. Object-oriented databases provide:
12. Disadvantages of the file-based methodology include:
a. database engine
b. forms generator
c. application generator
d. database engine
e. query processor
a. database engine
b. forms generator
c. application generator
d. database engine
e. query processor
a. data independence
b. sharing of data
c. data consistency
d. reduction of data redundancy
e. all of the above
a. database engine
b. forms generator
c. application generator
d. database engine
e. query processor
a. increase, increase
b. increase, decrease
c. decrease, increase
d. decrease, decrease
e. storage and processor speed had no effect on adoption of DBMS
a. data is stored in separate sets of data
b. the designer must know all questions that will be asked of the data
c. tables are not physically connected
d. a and c above
e. all of the above
a. a network database
b. a relational database
c. a bill of materials
d. a hierarchical database
e. a object-oriented database
a. a network database
b. a relational database
c. a bill of materials
d. a hierarchical database
e. a object-oriented database
a. dirty read
b. deadly embrace
c. standards violations
d. "lost" or concurrent update
e. system error
a. the query processor
b. the 3GL connector
c. the communications network
d. the application generator
e. the database engine
a. the ability to create powerful and reusable components
b. the best solution for all database design
c. the ability to create hardware independence
d. a and c
e. all of the above
a. the necessity for programmers to recompile all programs that use a data structure to
be altered (excessive program maintenance).
b. the same information stored in multiple locations, resulting in data duplication and
inconsistencies
c. the same data being referred to in many different names and styles
d. developer focus on data structure rather than business rules
e. all of the above
