102) A high activity ratio
A) is typical of batch processing, such as a payroll application.
B) is characteristic of all file processing activities in a large corporation.
C) spreads the fixed costs of sequential processing over fewer transactions.
D) makes ISAM processing more economical if the files are not processed in low activity
situations.
103) The cost of processing per transaction in a high-activity environment is the lowest in which
of the following file organization techniques?
A) Indexed
B) Sequential
C) Direct
D) Indexed-sequential
104) Response time is affected by
A) disk access time.
B) how data records are physically distributed on the disk.
C) the database management system but not the operating system.
D) disk access time and how data records are physically distributed on the disk.
105) In a database management system, defining an individual user view of the database is
known as defining the
A) subschema.
B) name of a data element.
C) schema.
D) number of positions of the data element.
106) The database computer language that consists of commands for updating and extracting
data is
A) DDL.
B) DBA.
C) DML.
D) DQL.
107) The basic DML statement used to modify the rows of tables in SQL is
A) SELECT.
B) DELETE.
C) UPDATE.
D) INSERT.
108) In SQL, the query to extract a customer name from a table identified as company is
A) SELECT name, company.
B) SELECT name FROM company.
C) SELECT company, name.
D) SELECT FROM company, name.
109) In an SQL query, ________ is the comparison operator used to specify “greater than.”
A) >=
B) =>
C) >
D) =>>
110) The command used in an SQL query to combine fields from several tables is
A) GROUP BY.
B) ORDER BY.
C) WHERE INSTR.
D) INNER JOIN.
111) Database management systems have the ability to integrate separate data files for various
accounting applications. In the absence of integration, each type of accounting application will
maintain its own independent data files. Which of the following is an advantage of maintaining
separate files for accounting applications?
A) Maintaining separate files is simple.
B) Using independent files, accounting data must be fed into each application file numerous
times.
C) Since files are defined early in the implementation process, the evolving needs of applications
may be constrained by the existing file structure.
D) Independence among files often leads to different structures for the same data.
112) The essential characteristics of the database approach to data processing of accounting data
requires that
A) data storage is integrated into a single database.
B) separate processing routines are required for separate files.
C) all access to integrated files is through a single software system.
D) data storage is integrated into a single database and all access to integrated files is through a
single software system.
113) Database dictionaries are defined and controlled by
A) a DBA.
B) a DBMS.
C) the SQL DML component.
D) the organization’s steering committee.
114) Which of the following is an alias?
A) A file whose records consist of data item descriptions
B) The use of more than one name for the same field
C) The user having the final responsibility for a data item
D) The physical form in which data are stored in a database
115) A database dictionary is defined and controlled by
A) the controller.
B) the owner.
C) DMA.
D) DBA.
116) Database dictionaries are used both alone and with DBMSs to ________ the use of data
within an organization
A) centralize and document
B) centralize and control
C) centralize, document, control, and coordinate
D) centralize, document, and coordinate
117) Many of the problems a database administrator faces within an organization are
A) internal-control related.
B) political.
C) software and hardware related.
D) data-integrity related.
118) A database, together with database software, is
A) database objects.
B) database agnosticity.
C) a database management system.
D) a database logical structure.
119) ________ permit(s) the data to be physically stored apart from the application which
facilitates a client-server, tiered architecture environment, in which multiple client users access a
shared database.
A) Database objects
B) Database agnosticity
C) Database management system
D) Database logical structure
120) ________ connect(s) the business application to the database management system.
A) Database driver
B) Database agnosticity
C) CASEwise
D) Database objects
121) Object-oriented modeling can be ________ easily into object-oriented program code.
A) moved
B) translated
C) uploaded
D) transformed
122) In practice, ________ databases outperform ________ databases in a wide range of
common tasks that are typically performed in a business environment.
A) object-oriented, relational
B) conceptual, relational
C) relational, object-oriented
D) object-oriented, conceptual
123) ________ is a multidimensional generalization of the 2-dimensional relational table which
provides incredibly fast response times.
A) OLAP
B) UML
C) RUP
D) RAD
124) OLAP uses complicated multidimensional “indexes” called
A) data mining.
B) aggregations.
C) drivers.
D) transformers.
125) What defines an entire database being loaded into computer-internal high-speed random
access memory or other high-speed electronic storage device?
A) Internal database
B) In-resident database
C) RAM database
D) In-memory database
126) ACID
A) ensures reliability of processing database transactions.
B) makes sure development of databases is thorough.
C) ensures a complete design is implemented.
D) makes processing data extremely fast and reporting error free.
127) The “C” in ACID stands for
A) completeness.
B) consistency.
C) conventional.
D) conceptual.
128) High level query languages include the below except
A) QBE.
B) NLDQ.
C) OQL.
D) SQL.
129) Third party reporting solutions can provide end users the ability to easily extract reports and
queries from the application database. Examples of these reporting solutions include
A) Crystal Reports.
B) MicroStrategy.
C) OLAP.
D) Crystal Reports and MicroStrategy are both examples of 3rd party reporting solutions.
130) Presented below is a list of terms relating to accounting information systems, followed by
definitions of those terms.
Required: Match the letter next to each definition with the appropriate term. Each answer will be
used only once.
________ 1. DBA
________ 2. Inheritance
________ 3. Occurrence
________ 4. Branch
________ 5. Database model
________ 6. Record
________ 7. Fully inverted file
________ 8. Trailer record
________ 9. Record key
________ 10. Field
A. The connection between children and parent(s) in a tree structure
B. Individual who has overall responsibility for database administration
C. The smallest block of data that will be stored and retrieved in the information system
D. A synonym for schema
E. A relationship created when an object class is divided into subclasses
F. A file in which all fields are indexed
G. A specific set of data values for a record
H. A logical grouping of fields (data items) that concern a certain entity
I. A data item or combination of data items that uniquely identify a particular record in a file
J. A fixed-length extension of a master record
131) Presented below is a list of terms relating to accounting information systems, followed by
definitions of those terms.
Required: Match the letter next to each definition with the appropriate term. Each answer will be
used only once.
________ 1. Ring structure
________ 2. Alias
________ 3. ISAM
________ 4. Relational algebra
________ 5. Tuple
________ 6. Activity ratio
________ 7. Variable-length record
________ 8. Normalization
________ 9. Disk access time
________ 10. Randomizing transformation
A. A row in a relational table
B. Both the number of fields and the length (character size) of each field are variable
C. A list organization in which the last record in the ring points back to the first record
D. Operations used to extract information from relational tables
E. A widely used method of storing and locating records in a direct-access file
F. The process of applying normal form rules in the relational database model
G. A synonym for indexed-sequential file organization
H. The length of time required for the CPU to retrieve a single block of data from the disk
I. Different users call the same field different names
J. The number of active records divided by the number of records in the file
132) Presented below is a list of terms relating to accounting information systems, followed by
definitions of those terms.
Required: Match the letter next to each definition with the appropriate term. Each answer will be
used only once.
________ 1. Logical data structure
________ 2. Key
________ 3. Node
________ 4. DQL
________ 5. Element
________ 6. Hypertext systems
________ 7. DML
________ 8. SELECT
________ 9. First normal form
________ 10. DDL
A. Defines the logical structure of the database (schema)
B. A synonym for field
C. A synonym for record key
D. Systems that allow users to browse through databases in random fashion by selecting key
words or objects
E. The rational manner in which records and fields in the database are structured and organized
F. Almost all statements in SQL begin with this word
G. The commands for updating, editing, manipulating, and extracting data from a database
H. A user-friendly language or interface that allows the user to request information from the
database
I. Relational tables that do not contain any repeating groups
J. A synonym for repeated group
133) Listed below are ten examples of file organization.
Required: From the following three choices, match the file organization technique with each of
the ten examples listed. All techniques will be used more than once.
S = Sequential
IS = Indexed-sequential
D = Direct access
________ 1. A large manufacturing company pays all employees once a week.
________ 2. The inventory system of a 24-hour grocery store automatically orders merchandise
from vendors when the inventory level is low.
________ 3. A bank customer checking account file is online in an ATM network. The bank also
uses the file each month to produce customer statements.
________ 4. An Internet retailer sells children’s toys online.
________ 5. An airline reservation system answers customer inquiries about available flights and
seats and makes customer reservations.
________ 6. Bookstore employees use an inventory file each week to prepare purchase orders
for books.
________ 7. A plant assets file for a small manufacturer is used to prepare quarterly depreciation
reports. It is used once a year to prepare a report for insurance purposes.
________ 8. Employees use a vendor application at a trucking company daily to answer
questions and accrue accounts payable. The company writes checks to vendors once a week.
________ 9. A file of payables due to actors and writers is processed monthly to prepare royalty
checks; it is also used once a year to prepare tax reports.
________ 10. A metropolitan branch library scans books to check them out, answers patron
inquiries about available books, and mails monthly statements to patrons having overdue books.
134) A database contains the following data:
Student Schedule (Student#, Student_name, Major, Course#1, ClassTime1, Location1,
Course#2, ClassTime2, Location2, Course#3, ClassTime3, Location3)
Required: Normalize this relation through the third normal form.
135) Assume that the customer master file and the transaction file consist of the record numbers
shown in the following sequence:
Master file 3, 7, 23, 76, 79, 99
Transaction file 3, 4, 23, 23, 7, 76, 99
The record number 99 denotes the logical end of the file. The program processes records in
ascending order.
Required: On the lines below, indicate the numbers of records affected as described.
a. Master records which were updated ________
b. Master records which were not updated ________
c. Transaction records which were posted ________
d. Transaction records which were not posted (an error condition) ________
136) Below are three situations in which the Data Definition Language (DDL), the Data
Manipulation Language (DML), or the Data Query Language (DQL) of a database management
system will be used. Indicate on the line beside each situation which of the languages would
likely be used.
________ A. A programmer uses COBOL to make revisions to the company’s payroll
application.
________ B. The zip code file in a customer master file is expanded to accommodate the nine
digit “zip plus 4” zip codes.
________ C. The personnel director requests a special report regarding the number of employees
in the company with a post-secondary education.
137) Below are four situations in which the DML component of SQL can be used to manipulate
and/or extract data. Indicate on the line beside each situation the letter(s) of the SQL statement,
command, or condition which will allow a user to manipulate and/or extract the requested data
and information. An answer may be used more than once, but not all answers will be used.
A. SELECT
B. WHERE
C. ON
D. OR
E. COUNT AS
F. GROUP BY
G. ORDER BY
H. FROM
I. INNER JOIN
J. IN
________ 1. The query calls for selecting certain names and zip codes, sorted by zip code.
________ 2. The query calls for selecting certain companies found in the USA and Canada tables
and grouping them by country
________ 3. The query calls for appending the company name for company 12 to the topics
located in the notes table.
________ 4. The query calls for summarizing the count of companies by country.
138) Discuss the relative benefits and drawbacks of the following file organization methods:
a. sequential
b. indexed-sequential
c. direct
139) Describe the duties of the database administrator (DBA) regarding the data dictionary.
140) Describe the index, prime area, and overflow area in an ISAM file structure.
141) Describe how list organization and multilist organization work in tree and network
databases. Also, distinguish between a list structure and a ring structure in the implementation of
tree and network structures. How does the list organization make database maintenance difficult?
Under what circumstances is the list organization effective?
142) Discuss the conceptual level of architecture relevant to databases and their management.
143) What is ACID? Provide a description of each part.