Topic 1 Flashcards
_____ is the result of revealing the meaning of raw facts
a. End-user data
b. An encoded sample
c. An encrypted bit
d. Information
Information
_____ is the body of information and facts about a specific subject
a. Validation
b. A format
c. Knowledge
d. A database
Knowledge
Accurate, relevant, and timely information is the key to ____
a. data management
b. good decision making
c. knowledge
d. understanding
good decision making
End-user data is _____
a. knowledge about the end users
b. raw facts of interest to the end user
c. information about a specific subject
d. accurate, relevant and timely information
raw facts of interest to the end user
_____ provide a description of the data characteristics and the set of relationships that link the data found within the database
a. Queries
b. End-user data
c. Metadata
d. Schemas
Metadata
_____ serve as the intermediary between the user and the database
a. DBMSs
b. Metadata
c. End-user data
d. Programming languages
DBMSs
The database structure in a DBMS is stored as a _____
a. single file
b. collection of files
c. set of key/value pairs
d. collection of queries
collection of files
A (n) _____ might be written by a programmer or it might be created through a DBMS utility program
a. query
b. operating system
c. database management system
d. application
application
_____ exists when different versions of the same data appear in different places
a. Data inconsistency
b. Poor data security
c. Structural dependence
d. Conceptual dependence
Data inconsistency
The response of the DBMS to a query is the ___________
a. ad hoc query
b. ad hoc response
c. query result set
d. integrated view of the data
query result set
A (n) _____ database is used by an organization and supports many users across many departments
a. desktop
b. workgroup
c. enterprise
d. transactional
enterprise
A (n) _____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization
a. desktop
b. workgroup
c. enterprise
d. transactional
workgroup
A workgroup database is a (n) _____ database
a. single-user
b. multiuser
c. desktop
d. distributed
multiuser
A desktop database is a _____ database
a. single-user
b. multiuser
c. workgroup
d. distributed
single-user
A data warehouse contains historical data obtained from the _____
a. operational databases
b. desktop database
c. enterprise databases
d. workgroup databases
operational databases
_____ data exist in the format in which they were collected
a. Structured
b. Semistructured
c. Unstructured
d. Historical
Unstructured
_____ data exist in a format that does not lend itself to processing that yields information
a. Structured
b. Semistructured
c. Unstructured
d. Historical
Unstructured
_____ are the result of formatting disorganized data in order to facilitate storage, use and generation of information
a. Structured data
b. Raw data
c. Unstructured data
d. Obsolete data
Structured data
Most data that can be encountered are best classified as _____
a. structured
b. semistructured
c. unstructured
d. historical
semistructured
An XML database supports the storage and management of _____ XML data
a. structured
b. multistructured
c. fullystructured
d. semistructured
semistructured
The organization of data within folders in a manual file system is determined by _______
a. its date of creation
b. its expected use
c. the title of the documents in the folder
d. the data processing specialist
its expected use
A _____ is a logically connected set of one or more fields that describes a person, place, or thing
a. database
b. column
c. record
d. file
record
A _____ is a collection of related records
a. schema
b. field
c. column
d. file
file
A _____ is a character or group of characters that has a specific meaning
a. database
b. field
c. record
d. file
field
