___ is the de facto query language and data access standard supported by the majority of DBMS vendors.

___ is the de facto query language and data access standard supported by the majority of DBMS vendors.

a. DBMS
b. Access Query Language
c. Structured Query Language
d. 4GL



Answer: c. Structured Query Language

____ deals with fixing the database after a failure such as a disk or power failure.

____ deals with fixing the database after a failure such as a disk or power failure.

a. Access control
b. Backup
c. Recovery
d. Security


Answer: c. Recovery

The DBMS allows the user to specify what must be done, without having to specify how it is to be done, by using a(n) ____.

The DBMS allows the user to specify what must be done, without having to specify how it is to be done, by using a(n) ____.

a. access control
b. query language
c. table generator
d. security system



Answer: b. query language

Activities that make the database perform more efficiently in terms of storage and access speed are known as performance ____.

Activities that make the database perform more efficiently in terms of storage and access speed are known as performance ____.

a. development
b. upgrades
c. enhancements
d. tuning


Answer: d. tuning

___ are the instructions and rules that govern the design and use of the database system.

___ are the instructions and rules that govern the design and use of the database system.

a. Procedures
b. Hardware
c. Software
d. Data


Answer: a. Procedures

Where does the DBMS store the definitions of data elements and their relationships?

Where does the DBMS store the definitions of data elements and their relationships?

a. data map
b. data file
c. index
d. data dictionary


Answer: d. data dictionary

__ are considered database architects.

__ are considered database architects.

a. Systems analysts and programmers
b. Database administrators
c. Systems administrators
d. Database designers


Answer: d. Database designers

Database management systems, operating systems, applications and utilities are all examples of ____.

Database management systems, operating systems, applications and utilities are all examples of ____.

a. input and output
b. software
c. hardware
d. computer infrastructure


Answer: b. software

___ are the people who use application programs to run the organization's daily operations.

___ are the people who use application programs to run the organization's daily operations.

a. Data practitioners
b. End users
c. Managers
d. Database programmers


Answer: b. End users

The term ____ refers to an organization of components that define and regulate the collection, storage, management, and use of data within a database environment.

The term ____ refers to an organization of components that define and regulate the collection, storage, management, and use of data within a database environment.

a. people
b. DBMS
c. database system
d. hardware


Answer: c. database system

A data ____ develops when all of the required changes in the redundant data are not made successfully.

A data ____ develops when all of the required changes in the redundant data are not made successfully.

a. dependence
b. redundancy
c. anomaly
d. inconsistency


Answer: c. anomaly

Data ____ is defined as "the condition in which all of the data in the database are consistent with the real-world events and conditions."

Data ____ is defined as "the condition in which all of the data in the database are consistent with the real-world events and conditions."

a. verification
b. redundancy
c. inconsistency
d. integrity


Answer: d. integrity

Which of the following would result in a data anomaly?

Which of the following would result in a data anomaly?

a. obsolescence of data
b. inconsistent redundant data
c. modification of data
d. timeliness of data



Answer: b. inconsistent redundant data

Data ____ exists when the same data are stored unnecessarily at different places.

Data ____ exists when the same data are stored unnecessarily at different places.

a. fragmentation
b. dependency
c. redundancy
d. inconsistency


Answer: c. redundancy

___ independence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data.

___ independence exists when it is possible to make changes in the file structure without affecting the application program's ability to access the data.

a. Structural
b. Logical
c. Physical
d. Fragmentation


Answer: a. Structural

Human beings view data according to its ____ data format.

Human beings view data according to its ____ data format.

a. structured
b. outer
c. logical
d. physical


Answer: c. logical

Because all data access programs are subject to change when any of the file's data storage characteristics change (that is, changing the data type), the file system is said to exhibit ____.

Because all data access programs are subject to change when any of the file's data storage characteristics change (that is, changing the data type), the file system is said to exhibit ____.

a. physical data format
b. data dependence
c. data independence
d. logical data format


Answer: b. data dependence

Data ____ exists when it is possible to make changes in the data storage characteristics without affecting the application program's ability to access the data.

Data ____ exists when it is possible to make changes in the data storage characteristics without affecting the application program's ability to access the data.

a. mining
b. integrity
c. independence
d. inconsistency


Answer: c. independence

A(n) ____ allows the user to specify what must be done without specifying how it must be done.

A(n) ____ allows the user to specify what must be done without specifying how it must be done.

a. script
b. nonprocedural language
c. procedural language
d. object-oriented language


Answer: b. nonprocedural language

A raw fact such as a telephone number is known as ____.

A raw fact such as a telephone number is known as ____.

a. data
b. information
c. relationships
d. records


Answer: a. data

All fields for a specific entity can be grouped together as a ____.

All fields for a specific entity can be grouped together as a ____.

a. database
b. file
c. field
d. record


Answer: d. record

A record consists of a ____.

A record consists of a ____.

a. group of files
b. character
c. collection of related records
d. set of one or more fields


Answer: d. set of one or more fields

Where was a traditional file system normally stored?

Where was a traditional file system normally stored?

a. file cabinet
b. database
c. data warehouse
d. closet


Answer: a. file cabinet

A ____ system is composed of software, hardware, data, procedures and people.

A ____ system is composed of software, hardware, data, procedures and people.

a. database
b. software
c. computer
d. file


Answer: a. database

Data processing (DP) specialists are in existence because of ____.

Data processing (DP) specialists are in existence because of ____.

a. the need to speed up processing of data
b. the increase in the number of computers
c. the advent of database management systems
d. the need to track data and produce required reports


Answer: d. the need to track data and produce required reports

The design of a ____ database recognizes the use of historical and aggregated data.

The design of a ____ database recognizes the use of historical and aggregated data.

a. multiuser
b. data warehouse
c. single-user
d. production


Answer: b. data warehouse

Which of the following products do not provide an enterprise database?

Which of the following products do not provide an enterprise database?

a. Oracle RDBMS
b. MS Access
c. MS SQL Server
d. IBM DB2



Answer: b. MS Access

How many users does a workgroup database usually support?

How many users does a workgroup database usually support?

a. 10
b. 30
c. 50
d. 100


Answer: c. 50

John is working in the customer table and needs to know what customers are located in Florida. To find the information he would ____.

John is working in the customer table and needs to know what customers are located in Florida. To find the information he would ____.

a. utilize the Database Wizard
b. create a new table
c. create a new form
d. create a new query



Answer: d. create a new query

Another name for a production database is a ____ database.

Another name for a production database is a ____ database.

a. data mining
b. development
c. warehousing
d. transactional


Answer: d. transactional

The ____ is a specialized database that stores data in a format optimized for decision support.

The ____ is a specialized database that stores data in a format optimized for decision support.

a. production database
b. distributed database
c. workgroup database
d. data warehouse


Answer: d. data warehouse

A database that supports data distributed across several different sites is called a(n) ____ database.

A database that supports data distributed across several different sites is called a(n) ____ database.

a. desktop
b. workgroup
c. distributed
d. enterprise


Answer: c. distributed

A single-user database that runs on a personal computer is called a(n) ____ database.

A single-user database that runs on a personal computer is called a(n) ____ database.

a. desktop
b. workgroup
c. distributed
d. enterprise



Answer: a. desktop

What is the name for an answer to a query that the DBMS sends back to the application?

What is the name for an answer to a query that the DBMS sends back to the application?

a. data result
b. DBMS result
c. query result set
d. question result


Answer: c. query result set

Wider access to well-managed data promotes a(n) ____ view of the organization's operations and a clearer view of the big picture.

Wider access to well-managed data promotes a(n) ____ view of the organization's operations and a clearer view of the big picture.

a. raw
b. automatic
c. transparent
d. integrated


Answer: d. integrated

An ad hoc query is a ____.

An ad hoc query is a ____.

a. question that will not return any results
b. pre-scheduled question
c. spur-of-the-moment question
d. pre-planned question


Answer: c. spur-of-the-moment question

The ____ receives all application requests and translates them into the complex operations required to fulfill requests.

The ____ receives all application requests and translates them into the complex operations required to fulfill requests.

a. DP
b. query
c. workgroup
d. DBMS


Answer: d. DBMS

The ____ manages interaction between the end user and the database.

The ____ manages interaction between the end user and the database.

a. DP
b. DM query engine
c. DBMS
d. DBMQ


Answer: c. DBMS

What is a benefit of using a DBMS?

What is a benefit of using a DBMS?

a. they provide seamless Internet access to database data
b. they provide full security to data using private/public key encryption
c. they create automatic backups
d. they help create an environment for end users to have access to more data


Answer: d. they help create an environment for end users to have access to more data

Data management is a discipline that focuses on ____.

Data management is a discipline that focuses on ____.

a. the proper generation, storage, and retrieval of information
b. the management of end users
c. the proper generation, storage, and retrieval of data
d. the help items to be used by end users


Answer: c. the proper generation, storage, and retrieval of data

What is the name for data about data?

What is the name for data about data?

a. superdata
b. unique data
c. raw data
d. metadata


Answer: d. metadata

Accurate, relevant, and timely ____ is the key to good decision making.

Accurate, relevant, and timely ____ is the key to good decision making.

a. relationships
b. information
c. processing
d. data



Answer: b. information

What is a key characteristic of knowledge?

What is a key characteristic of knowledge?

a. it cannot be duplicated
b. it exists in a vacuum
c. it is assembled from raw data
d. "new" knowledge can be derived from "old" knowledge


Answer: d. "new" knowledge can be derived from "old" knowledge

Raw data must be properly ____ for storage, processing, and presentation.

Raw data must be properly ____ for storage, processing, and presentation.

a. formatted
b. grouped
c. sorted
d. arranged



Answer: a. formatted

Processed data, or ____, can be used as the foundation for decision making.

Processed data, or ____, can be used as the foundation for decision making.

a. DP
b. raw data
c. information
d. queries


Answer: c. information

The word ____ indicates that the facts have not yet been processed to reveal their meaning.

The word ____ indicates that the facts have not yet been processed to reveal their meaning.

a. dictionary
b. raw
c. information
d. data


Answer: b. raw