Kean University
MGS 3040 Spring, '03
EXAM #3
All questions are worth 3 points (except 12, which is worth 4).
Statements are True-False questions.
1. A nanosecond is one-billionth of a second.
2. Microprocessors integrate memory, logic, and control circuits for an entire CPU
onto a single chip.
3. RAID delivers data over multiple paths simultaneously.
4. The amount of data companies need to store is increasing from 75 to 150 percent
every year.
5. Batch processing involves the immediate processing of transactions.
6. The operating system manages and controls the computer's activities.
7. Program instructions written in a high-level language are called object code.
8. Source code is object code translated into machine language through a compiler.
9. XML provides a standard format for data exchange.
10. ASPs provide software over the Web and private networks.
11. MICR is used primarily:
A. to translate bar codes B. in sensitized display screens
C. in check processing for the banking industry D. for voice output devices
E. for storing microscopic filmed documents
12. System software is the layer between:
A. primary and secondary memory B. the CPU and secondary storage
C. the hardware and the application software D. the computer and the Internet
E. the application software and the storage medium
13. C++ is:
A. designed for business administrators B. a fourth-generation language
C. a software application package D. object-oriented
E. a natural language
14. A Web server is:
A. a computer whose only task is to access the Web
B. software for locating and managing stored Web pages
C. a computer linking one network to another network
D. part of a telecommunications server
E. all of the above
15. Centralized processing is a model that splits processing between "clients" and
"servers" on a network, assigning functions to the machine most able to perform
the function.
16. The hypertext markup language (HTML) is a general purpose language that de-
scribes the structure of a document and supports links to multiple documents,
allowing data to be manipulated by the computer.
17. Most firms write their own program as a DBMS package, and use related hardware,
rather than purchase it.
18. In most organizations, functional areas tend to develop systems in cooperation
with other functional areas because they all share information.
19. A problem with data redundancy is that the same data item may have different
meanings in different parts of the organization.
20. A DBMS eliminates most of the data definition statements found in traditional
programs.
21. The most popular type of DBMS today for PCs is the hierarchical DBMS.
22. The strength of the relational model is that it can relate data in two files
if the files share a common data element.
23. The entity-relationship diagram documents the physical design of the database.
24. The intent of the data administration function is to define information re-
quirements for the entire company, with direct access to senior management.
25. In a traditional file environment, any change in data requires:
A. a different entity description
B. a change in all programs that access the data C. management approval
D. data redundancy E. a different data dictionary
26. SQL is:
A. the standard data manipulation language for relational DBMS
B. a first-generation language
C. the query language used for networked databases
D. never used for reports
E. a natural language approach to gathering information from databases
27. Hierarchical DBMS can still be found in:
A. older, less flexible management environments that do not understand modern
media
B. large legacy systems that require intensive high-volume transaction process-
ing
C. small new companies that do not need relational DBMS
D. object-oriented environments
E. companies using low-level programming languages
28. Database designers document the conceptual data model with:
A. normalization diagrams B. an entity-relationship diagram
C. a distributed-hierarchical diagram D. an entity-attributes diagram
E. a database model
29. Datamining:
A. cannot predict likely future behavior
B. looks only at broad areas, not detail C. is illegal
D. is not accurate for small companies
E. finds hidden patterns and relationships in large pools of data
30. A key field is the field in a record that uniquely identifies instances of that
record so that it can be retrieved, updated, or sorted.
31. A data mart involves the process of creating small stable data structures from
complex groups of data when designing a relational database.
32. Grace Hopper wrote a precursor to COBOL and is associated with the term 'bugs' in
computer programs.
33. The underlying Kean Administrative database is that of Microsoft Access.