entify the choice that best completes the statement or answers the question.
With a(n) ____, users create a computerized database; add, change, and delete data in the database; sort and retrieve data from the database; and create forms and reports from the data in the database.
____ is a computer phrase that points out the accuracy of a computer’s output depends on the accuracy of its input.
a.
|
Nothing ventured, nothing gained (NVNG)
|
b.
|
Bad data, bad info (BDBI)
|
c.
|
Garbage in, garbage out (GIGO)
|
d.
|
What you see is what you get (WYSIWYG)
|
Accurate information ____.
a.
|
is error free
|
b.
|
has meaning to the person who receives it
|
c.
|
is available when a decision maker needs it
|
d.
|
has an age suited to its use
|
Verifiable information ____.
a.
|
gives more value than it costs to produce
|
b.
|
is arranged to suit the needs and requirements of a decision maker
|
c.
|
has meaning to the person who receives it
|
d.
|
can be proven as correct or incorrect
|
A ____ is the smallest unit of data a computer can process.
a.
|
bit
|
c.
|
field
|
b.
|
character
|
d.
|
record
|
In the ASCII coding scheme, each byte represents a single ____, which can be a number, letter, punctuation mark, or other symbol.
a.
|
unit
|
c.
|
index
|
b.
|
character
|
d.
|
bit
|
In a database, the data ____ specifies the kind of data a field can contain and how the field is used.
a.
|
model
|
c.
|
type
|
b.
|
mode
|
d.
|
variant
|
____ is a common data type that includes letters, numbers, or special characters.
a.
|
Alpha
|
c.
|
Metric
|
b.
|
Character
|
d.
|
Text
|
In a database, a(n) ____ is a group of related fields.
a.
|
table
|
c.
|
record
|
b.
|
key
|
d.
|
primary field
|
In a database, a(n) ____ field is a field that uniquely identifies each record in a file.
a.
|
main
|
c.
|
master
|
b.
|
identifying
|
d.
|
primary key
|
File maintenance includes which of the following:
a.
|
adding records
|
c.
|
deleting records
|
b.
|
modifying records
|
d.
|
all of the above
|
Many database programs perform which of the following in order to analyze entered data to help ensure that it is correct?
a.
|
information confirmation
|
c.
|
validity check
|
b.
|
integration
|
d.
|
integrity valuation
|
Which of the following kind of checks is a validity check performed on data, like that in the accompanying figure, which ensures users enter only alphabetic data into a field?
a.
|
alphabetic
|
c.
|
range
|
b.
|
numeric
|
d.
|
consistency
|
Which of the following kind of checks is a validity check on data like that in the accompanying figure, which determines whether a number is within a specified group of numbers?
a.
|
group
|
c.
|
range
|
b.
|
numeric
|
d.
|
integer
|
A(n) ____ tests the data in two or more associated fields to ensure that the relationship is logical.
a.
|
range check
|
c.
|
consistency check
|
b.
|
completeness check
|
d.
|
alphabetic/numeric check
|
A major weakness of a lot of file processing systems is that ____.
a.
|
they have redundant data and they isolate data
|
b.
|
they are much more complex than a database
|
c.
|
data is more vulnerable than data in a database
|
d.
|
all of the above
|
When compared with a file processing system, a database offers all of the following except ____.
a.
|
reduced data redundancy
|
b.
|
easier access and shared data
|
c.
|
reduced development time
|
d.
|
less required memory, storage, and processing power
|
A DBMS uses which of the following to perform validation checks?
a.
|
data server
|
c.
|
data warehouse
|
b.
|
data mart
|
d.
|
data dictionary
|
Which of the following is a request for specific data from a database?
a.
|
query
|
c.
|
ask
|
b.
|
index
|
d.
|
inquiry
|
Many organizations adopt the _______________, where users’ access privileges are limited to the lowest level necessary to perform required tasks.
a.
|
access privilage plan
|
c.
|
principle of least privilege policy
|
b.
|
principle of highest privilege policy
|
d.
|
user access plan
|
Which of the following is true in a relational database?
a.
|
Each row and each column has a primary key.
|
b.
|
Each row has a unique name and each column has a primary key.
|
c.
|
Each row has a primary key and each column has a unique name.
|
d.
|
Each row and each column has a unique name.
|
In a database such as that pictured in the accompanying figure, which of the following is a connection within the data?
a.
|
table
|
c.
|
row
|
b.
|
column
|
d.
|
relationship
|
Database design guidelines include
a.
|
Determine the purpose of the database.
|
d.
|
Determine relationships among the tables or files.
|
b.
|
Design tables or files.
|
e.
|
All of the above.
|
c.
|
Design records and fields for each table or file.
|
|
|
Which of the following is a huge database that stores and manages the data required to analyze historical and current transactions?
a.
|
data stockyard
|
c.
|
data storehouse
|
b.
|
data warehouse
|
d.
|
data storage unit
|
___________ is a process designed to ensure the data within the relations (tables) contains the least amount of duplication.
a.
|
naturalization
|
c.
|
normalization
|
b.
|
validation
|
d.
|
randomization
|