CHAP 11
A ______ is automatically displayed in a field unless the user enters something different.
default value
______ involves putting data into an electronic file in a format that another application can understand
exporting
An example of ______ is customer demographic data purchased from third parties or statistics complied by the federal government.
external data
A ______ temporarily displays records that much the specified criteria.
filter
A web address is stored as a(n) ______ field in a database.
hyperlink
Which of the following is NOT a main operation of a database management system (DBMS)?
implementing data mining
In a data warehouse, data gathered from sales, billing, and inventory department are examples of ______ sources.
internal data
An expert system and a natural language processing system are both ______.
knowledge-based systems
Data staging consists of all of the following steps, EXCEPT ______.
mining of data
The Siri speech-recognition feature on Apple's iPhone 4s is an example of a ______.
natural language processing (NLP) system
In a database, ______ fields store numbers used to perform calculations.
numeric
In a database, a chart is stored in a(n) ______ field.
object
A ______ relationship indicates that for each record in a table, there is only a single corresponding record in a related table.
one-to-one
A(n) ______ is a way of retrieving information from one or more tables that defines a particular subset of data
query
A ______ check allows you to set credits allowed for students during one quarter for 0 to 21.
range
If a business keeps two lists, one for employee payroll and one for employee benefits information, both containing name an address information, this is a example of data ______.
redundancy
which of the following is NOT type a of management information system (MIS) report?
redundancy
SQL uses ______ to extract records from a database by using English-like expressions that have variables and operations
relational algebra
In a relational database, what is a relationship
A link between tables that defines how the data are related.
Microsoft ______ is a database management system.
Access
Unstructured data such as vide clips, and pictures are known as ______ because of the way they are encoded.
Binary large Objects (BLOBs)
Prior to entering data into a database, you must create a data ______ entry for each field in the database.
Type
Which of the following is NOT a typical disadvantage associated with database?
database information cannot be changed one it is entered.
A database schema is also called a(n) ______.
data dictionary
Which of the following is NOT a data source for a data warehouse?
data mine
Classification, affinity grouping, and estimation are ______ methods used by managers to make their data more meaningful
data mining
If a numeric field has a size of 5, which is the highest number it can hold?
99999
What does the acronym DBMS stand for?
Database management system
______ means that or each value in the foreign key of one table, there is a corresponding value in the primary key of another table
Referential integrity
Which of the following statements about object oriented database is FALSE?
They store data in table format
An individual trained in the design and building of database is called a database ______.
administrator
Data in a multidimensional database is organized in a ______ format.
cube
Nontraditional data such as audio clips, video clips, pictures, and very large documents are called ______ data.
unstructured