ACTG 313 UPDATED SCRIPT 2026
PRACTICE SOLUTIONS GRADED A+
● 22.3.9
Structured Query Language (SQL) is the best defined as a:
a. programming language in which UNIX is written
b. report generator used to produce customized business reports
c. programming language in which many business applications are
written
d. data manipulation language used in conjunction with a database
management system (DBMS). Answer: d. data manipulation language
used in conjunction with a database management system (DBMS)
● 22.3.15
In an inventory system on a database, one stored record contains part
number, part name, part color, and part weight. These individual items
are called
a. Fields
b. Stored Files
c. Bytes
d. Occurrences. Answer: a. Fields
,● 22.3.17
An inventory clerk, using a computer terminal, views the following on
screen: part number, part description, quantity on hand, quantity on
order, order quantity, and reorder point for a particular inventory item.
Collectively, these data make up a
a. Field
b. File
c. Database
d. Record. Answer: d. Record
● 22.4.1
The relationship between online, real-time database systems and batch
processing systems is that
a. A firm will have only one processing mode because a single computer
cannot do both
b. A firm will not use batch processing if it has a large computer
c. A firm may use both processing modes concurrently
,d. A firm will always prefer an online, real-time processing system
because batch processing is slow. Answer: C. A firm may use both
processing modes concurrently
● 22.4.2
Sequential access means that
a. Data must be stored on magnetic strips
b. The address of the location of data is found through the use of either
an algorithm or an index
c. Each record can be accessed in the same amount of time
d. To read record 500, records 1 through 499 must be read first. Answer:
d. to read record 500, records 1 through 499 must be read first
● 22.4.3
Which of the following features is least likely to be found in a real-time
application?
a. User Manuals
b. Preformatted Screens
, c. Automatic Error Correction
d. Turnaround Documents. Answer: d. Turnaround Documents
● 22.4.4
Data processing assigns a unique identification code or key to each data
record. Which one of the following statements about coding is false?
a. A primary key is the main code used to store and locate records within
a file
b. Records can be sorted, and temporary files created, using codes other
than their primary keys
c. Secondary keys are used when the primary keys cannot be found
d. Secondary keys are used for alternative purposes, including inverted
files, and a given data record may have more than one secondary key.
Answer: c. Secondary keys are used when the primary keys cannot be
found
● 22.4.6
**see pg. 499 in book for chart**
PRACTICE SOLUTIONS GRADED A+
● 22.3.9
Structured Query Language (SQL) is the best defined as a:
a. programming language in which UNIX is written
b. report generator used to produce customized business reports
c. programming language in which many business applications are
written
d. data manipulation language used in conjunction with a database
management system (DBMS). Answer: d. data manipulation language
used in conjunction with a database management system (DBMS)
● 22.3.15
In an inventory system on a database, one stored record contains part
number, part name, part color, and part weight. These individual items
are called
a. Fields
b. Stored Files
c. Bytes
d. Occurrences. Answer: a. Fields
,● 22.3.17
An inventory clerk, using a computer terminal, views the following on
screen: part number, part description, quantity on hand, quantity on
order, order quantity, and reorder point for a particular inventory item.
Collectively, these data make up a
a. Field
b. File
c. Database
d. Record. Answer: d. Record
● 22.4.1
The relationship between online, real-time database systems and batch
processing systems is that
a. A firm will have only one processing mode because a single computer
cannot do both
b. A firm will not use batch processing if it has a large computer
c. A firm may use both processing modes concurrently
,d. A firm will always prefer an online, real-time processing system
because batch processing is slow. Answer: C. A firm may use both
processing modes concurrently
● 22.4.2
Sequential access means that
a. Data must be stored on magnetic strips
b. The address of the location of data is found through the use of either
an algorithm or an index
c. Each record can be accessed in the same amount of time
d. To read record 500, records 1 through 499 must be read first. Answer:
d. to read record 500, records 1 through 499 must be read first
● 22.4.3
Which of the following features is least likely to be found in a real-time
application?
a. User Manuals
b. Preformatted Screens
, c. Automatic Error Correction
d. Turnaround Documents. Answer: d. Turnaround Documents
● 22.4.4
Data processing assigns a unique identification code or key to each data
record. Which one of the following statements about coding is false?
a. A primary key is the main code used to store and locate records within
a file
b. Records can be sorted, and temporary files created, using codes other
than their primary keys
c. Secondary keys are used when the primary keys cannot be found
d. Secondary keys are used for alternative purposes, including inverted
files, and a given data record may have more than one secondary key.
Answer: c. Secondary keys are used when the primary keys cannot be
found
● 22.4.6
**see pg. 499 in book for chart**
