Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

DC2012 Chapter 10

Total questions: 35

Worksheet time: 18mins

Name
Class
Date
1.

A(n) ____ digit is a number(s) or character(s) that is appended to or inserted into a primary key field.

a)

Check

b)

Index

c)

Insertion

d)

Integer

2.

A(n) ____ check is a validity check performed on data like that in the accompanying figure, which ensures users enter only numeric data into a field.

a)

Range

b)

Numeric

c)

Completeness

d)

Consistency

3.

A(n) ____ contains data about each file in a database and each field in those files.

a)

glossary

b)

repository

c)

index

d)

table of contents

4.

A DBMS uses the ____ to perform validation checks.

a)

data server

b)

data mart

c)

data warehouse

d)

data dictionary

5.

A(n) ____ value is the one that a DBMS initially displays in a field.

a)

query

b)

start

c)

initial

d)

default

6.

A(n) ____ is a request for specific data from a database.

a)

query

b)

index

c)

ask

d)

inquiry

7.

A(n) ____ language consists of simple, English-like statements that allow users to specify the data to display, print, or store.

a)

report

b)

query

c)

specification

d)

inquiry

8.

A DBMS places a copy of the record prior to a change, called the ____ image, in the log.

a)

prior

b)

before

c)

static

d)

dynamic

9.

A DBMS that creates a log usually provides a(n) ____ utility that uses the logs and/or backups to restore a database when it becomes damaged or destroyed.

a)

recovery

b)

restoration

c)

resumption

d)

baseline

10.

____ backup is a backup plan in which all data is backed up whenever a change is made.

a)

Integrated

b)

Continuous

c)

Dynamic

d)

Automated

11.

A(n) ____ model consists of rules and standards that define how a database organizes data.

a)

Standards

b)

Data

c)

Rules-Based

d)

Object Relational

12.

A user of a relational database, such as that pictured in the accompanying figure, refers to a field as a ____.

a)

table

b)

column

c)

row

d)

relationship

13.

In a relational database, such as that pictured in the accompanying figure, users can set up a relationship between tables at any time, but the tables must have a common ____.

a)

record

b)

row

c)

column

d)

key

14.

A(n) ____ stores data in objects.

a)

ADB

b)

OTDB

c)

EDB

d)

OODB

15.

____ is a process designed to ensure the data within the relations (tables) contains the least amount of duplication.

a)

Concatenation

b)

Rasterization

c)

Dithering

d)

Normalization

16.

____, as shown in the accompanying figure, is a query language that allows users to manage, update, and retrieve data.

a)

XML

b)

DBMS

c)

SQL

d)

QBE

17.

Compared with relational databases, object-oriented databases ____.

a)

can store more types of data

b)

access data faster

c)

allow programmers to reuse objects

d)

all of the above

18.

A ____ allows users to access and analyze any view of the database data.

a)

data warehouse

b)

hypermedia source

c)

data mining center

d)

hypercube

19.

A data ____ is a huge database that stores and manages the data required to analyze historical and current transactions.

a)

stockyard

b)

warehouse

c)

storehouse

d)

storage unit

20.

In managing a company’s database, the data ____ focuses on the meaning and usage of data.

a)

administrator

b)

manager

c)

modeler

d)

leader

21.

To ensure that data is accessible on demand, a company must manage and protect its data just as it would any other resource.

a)

True

b)

False

22.

Two different people may need the same information presented in a different manner.

a)

True

b)

False

23.

Data redundancy decreases the chance of errors.

a)

True

b)

False

24.

All DBMSs have built-in backup utilities.

a)

True

b)

False

25.

When users query a hierarchical database, the results often are displayed more quickly than the same query of a relational database.

a)

True

b)

False

26.

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)

SQL

b)

DBMS

c)

Data Directory

d)

Spreadsheet

27.

____________________ is a common data type that consists of dollar and cent amounts or numbers containing decimal values.

a)

Currency

b)

Key

c)

Query

d)

Percentage

28.

Users add new records to a file when they obtain new ____________________.

a)

Key

b)

File

c)

Data

d)

Record

29.

If the lowest annual fee at a discount warehouse is $20.25 and the highest is $55.50, a(n) ____________________ on the Annual Fee field ensures it is a value between $20.25 and $55.50.

a)

value

b)

key

c)

check

d)

range-check

30.

A Web database usually resides on a(n) ____________________.

a)

Database Manager

b)

Database warehouse

c)

Database Server

d)

Database Storage

31.

Information that should give more value than it costs to produce.

a)

Cost-effective

b)

economical

c)

cheap

d)

cost-specific

32.

What each byte represents in ASCII.

a)

byte

b)

bit

c)

character

d)

key

33.

Information that has an age suited to its use.

a)

value

b)

key

c)

old

d)

timely

34.

Information that is error free.

a)

Perfect

b)

Accurate

c)

Specific

d)

Value

35.

A group of related fields.

a)

Value

b)

Key

c)

Record

d)

Database