18

Need your ASSIGNMENT done? Use our essay writing service to score better and meet your deadline.


Order a Similar Paper Order a Different Paper

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