A dbms uses the ____ to perform validation checks

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.

a.

DBMS

c.

QBE

b.

RMS

d.

XML

____ 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