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 |
