WorksheetsDC2012 Chapter 10
Total questions: 35
Worksheet time: 18mins
A(n) ____ digit is a number(s) or character(s) that is appended to or inserted into a primary key field.
Check
Index
Insertion
Integer
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.
Range
Numeric
Completeness
Consistency
A(n) ____ contains data about each file in a database and each field in those files.
glossary
repository
index
table of contents
A DBMS uses the ____ to perform validation checks.
data server
data mart
data warehouse
data dictionary
A(n) ____ value is the one that a DBMS initially displays in a field.
query
start
initial
default
A(n) ____ is a request for specific data from a database.
query
index
ask
inquiry
A(n) ____ language consists of simple, English-like statements that allow users to specify the data to display, print, or store.
report
query
specification
inquiry
A DBMS places a copy of the record prior to a change, called the ____ image, in the log.
prior
before
static
dynamic
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.
recovery
restoration
resumption
baseline
____ backup is a backup plan in which all data is backed up whenever a change is made.
Integrated
Continuous
Dynamic
Automated
A(n) ____ model consists of rules and standards that define how a database organizes data.
Standards
Data
Rules-Based
Object Relational
A user of a relational database, such as that pictured in the accompanying figure, refers to a field as a ____.
table
column
row
relationship
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 ____.
record
row
column
key
A(n) ____ stores data in objects.
ADB
OTDB
EDB
OODB
____ is a process designed to ensure the data within the relations (tables) contains the least amount of duplication.
Concatenation
Rasterization
Dithering
Normalization
____, as shown in the accompanying figure, is a query language that allows users to manage, update, and retrieve data.
XML
DBMS
SQL
QBE
Compared with relational databases, object-oriented databases ____.
can store more types of data
access data faster
allow programmers to reuse objects
all of the above
A ____ allows users to access and analyze any view of the database data.
data warehouse
hypermedia source
data mining center
hypercube
A data ____ is a huge database that stores and manages the data required to analyze historical and current transactions.
stockyard
warehouse
storehouse
storage unit
In managing a company’s database, the data ____ focuses on the meaning and usage of data.
administrator
manager
modeler
leader
To ensure that data is accessible on demand, a company must manage and protect its data just as it would any other resource.
True
False
Two different people may need the same information presented in a different manner.
True
False
Data redundancy decreases the chance of errors.
True
False
All DBMSs have built-in backup utilities.
True
False
When users query a hierarchical database, the results often are displayed more quickly than the same query of a relational database.
True
False
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.
SQL
DBMS
Data Directory
Spreadsheet
____________________ is a common data type that consists of dollar and cent amounts or numbers containing decimal values.
Currency
Key
Query
Percentage
Users add new records to a file when they obtain new ____________________.
Key
File
Data
Record
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.
value
key
check
range-check
A Web database usually resides on a(n) ____________________.
Database Manager
Database warehouse
Database Server
Database Storage
Information that should give more value than it costs to produce.
Cost-effective
economical
cheap
cost-specific
What each byte represents in ASCII.
byte
bit
character
key
Information that has an age suited to its use.
value
key
old
timely
Information that is error free.
Perfect
Accurate
Specific
Value
A group of related fields.
Value
Key
Record
Database
