CS 302 STUDY EVALUATION QUESTIONS WITH SOLUTIONS
2025 GRADED A+
✔✔An input _____ is a template or pattern that restricts data entry and prevents errors.
- ✔✔mask
✔✔To reach prospective customers and investors, companies use a live or prerecorded
_____, which is an audio or video media file distributed over the Internet. - ✔✔webcast
✔✔A(n) _____ produces one or more lines of output for each record processed. -
✔✔detail report
✔✔A _____ language feature allows users to type commands or requests in normal text
phrases. - ✔✔natural
✔✔_____ describes the relationship between computers and the people who use them
to perform their jobs. - ✔✔Human-computer interaction (HCI)
✔✔In a source document, the _____ contains codes, identification information,
numbers, and dates that are used for storing completed forms. - ✔✔control zone
✔✔Interface designers can obtain data, called _____, by using software that can record
and measure user interaction with a system. - ✔✔usability metrics
✔✔A _____ system allows a customer to request a fax using email, via the company
website, or by telephone. - ✔✔faxback
✔✔A(n) _____ displays only those records that meet a specific condition or conditions. -
✔✔exception report
✔✔_____ is an online data entry method where a blank form that duplicates or
resembles the source document is completed on the screen. - ✔✔form filling
✔✔A _____ improves input quality by testing the data and rejecting any entry that fails
to meet specified conditions. - ✔✔data validation rule
✔✔Companies use various _____ methods to maintain output integrity and security. -
✔✔output control
✔✔The _____, which appears at the beginning of a report, identifies the report and
contains the report title, date, and other necessary information. - ✔✔report header
, ✔✔A _____ usually causes specific actions, such as printing subtotals for a group of
records in a report. - ✔✔control break
✔✔To produce a control break report, the records must be arranged, or sorted, in
_____. - ✔✔control field order
✔✔A(n) _____ is a data validation rule that can be used for data items that must have
certain values. - ✔✔validity check
✔✔A _____ collects input data, triggers or authorizes an input action, and provides a
record of the original transaction. - ✔✔source document
✔✔Typically, a database management system is managed by a person called a _____,
who assesses overall requirements and maintains the database for the benefit of an
entire organization rather than a single department or user. - ✔✔database administrator
✔✔_____ is designed to serve the needs of a specific department, such as sales,
marketing, or finance. - ✔✔A data mart
✔✔A table is in _____ if it is in first normal form and if all fields that are not part of the
primary key are functionally dependent on the entire primary key. - ✔✔second normal
form
✔✔A long integer format uses _____ bits to represent the number 1,234,567,890 in
binary form. - ✔✔32
✔✔One type of validity check, called _____, is a set of rules that avoids data
inconsistency and quality problems. - ✔✔referential integrity
✔✔A _____ is a set of letters or numbers that represents a data item. - ✔✔code
✔✔A(n) _____ is a graphical model of an information system that depicts the logical
relationships and interaction among system entities. - ✔✔entity-relationship diagram
✔✔With a _____, users provide an example of the data requested. - ✔✔query by
example language
✔✔A(n) _____ allows a user to specify a task without specifying how the task will be
accomplished. - ✔✔query language
✔✔A _____, which is not unique, is a field or combination of fields that can be used to
access or retrieve records. - ✔✔secondary key
2025 GRADED A+
✔✔An input _____ is a template or pattern that restricts data entry and prevents errors.
- ✔✔mask
✔✔To reach prospective customers and investors, companies use a live or prerecorded
_____, which is an audio or video media file distributed over the Internet. - ✔✔webcast
✔✔A(n) _____ produces one or more lines of output for each record processed. -
✔✔detail report
✔✔A _____ language feature allows users to type commands or requests in normal text
phrases. - ✔✔natural
✔✔_____ describes the relationship between computers and the people who use them
to perform their jobs. - ✔✔Human-computer interaction (HCI)
✔✔In a source document, the _____ contains codes, identification information,
numbers, and dates that are used for storing completed forms. - ✔✔control zone
✔✔Interface designers can obtain data, called _____, by using software that can record
and measure user interaction with a system. - ✔✔usability metrics
✔✔A _____ system allows a customer to request a fax using email, via the company
website, or by telephone. - ✔✔faxback
✔✔A(n) _____ displays only those records that meet a specific condition or conditions. -
✔✔exception report
✔✔_____ is an online data entry method where a blank form that duplicates or
resembles the source document is completed on the screen. - ✔✔form filling
✔✔A _____ improves input quality by testing the data and rejecting any entry that fails
to meet specified conditions. - ✔✔data validation rule
✔✔Companies use various _____ methods to maintain output integrity and security. -
✔✔output control
✔✔The _____, which appears at the beginning of a report, identifies the report and
contains the report title, date, and other necessary information. - ✔✔report header
, ✔✔A _____ usually causes specific actions, such as printing subtotals for a group of
records in a report. - ✔✔control break
✔✔To produce a control break report, the records must be arranged, or sorted, in
_____. - ✔✔control field order
✔✔A(n) _____ is a data validation rule that can be used for data items that must have
certain values. - ✔✔validity check
✔✔A _____ collects input data, triggers or authorizes an input action, and provides a
record of the original transaction. - ✔✔source document
✔✔Typically, a database management system is managed by a person called a _____,
who assesses overall requirements and maintains the database for the benefit of an
entire organization rather than a single department or user. - ✔✔database administrator
✔✔_____ is designed to serve the needs of a specific department, such as sales,
marketing, or finance. - ✔✔A data mart
✔✔A table is in _____ if it is in first normal form and if all fields that are not part of the
primary key are functionally dependent on the entire primary key. - ✔✔second normal
form
✔✔A long integer format uses _____ bits to represent the number 1,234,567,890 in
binary form. - ✔✔32
✔✔One type of validity check, called _____, is a set of rules that avoids data
inconsistency and quality problems. - ✔✔referential integrity
✔✔A _____ is a set of letters or numbers that represents a data item. - ✔✔code
✔✔A(n) _____ is a graphical model of an information system that depicts the logical
relationships and interaction among system entities. - ✔✔entity-relationship diagram
✔✔With a _____, users provide an example of the data requested. - ✔✔query by
example language
✔✔A(n) _____ allows a user to specify a task without specifying how the task will be
accomplished. - ✔✔query language
✔✔A _____, which is not unique, is a field or combination of fields that can be used to
access or retrieve records. - ✔✔secondary key
