DBMS ASSESSMENT EXAM QUESTIONS & ANSWERS
The word ____ indicates that the facts have not yet been processed to reveal their
meaning. - Answers - raw
Processed data, or ____, can be used as the foundation for decision making. - Answers
- information
Raw data must be properly ____ for storage, processing, and presentation. - Answers -
formatted
What is a key characteristic of knowledge? - Answers - "new" knowledge can be derived
from "old" knowledge
Accurate, relevant, and timely ____ is the key to good decision making. - Answers -
information
What is the name for data about data? - Answers - metadata
Data management is a discipline that focuses on ____. - Answers - the proper
generation, storage, and retrieval of data
What is a benefit of using a DBMS? - Answers - they help create an environment for
end users to have access to more data
The ____ manages interaction between the end user and the database. - Answers -
DBMS
The ____ receives all application requests and translates them into the complex
operations required to fulfill requests. - Answers - DBMS
An ad hoc query is a ____. - Answers - spur-of-the-moment question
Wider access to well-managed data promotes a(n) ____ view of the organization's
operations and a clearer view of the big picture. - Answers - integrated
What is the name for an answer to a query that the DBMS sends back to the
application? - Answers - query result set
A single-user database that runs on a personal computer is called a(n) ____ database. -
Answers - desktop
A database that supports data distributed across several different sites is called a(n)
____ database. - Answers - distributed
,The ____ is a specialized database that stores data in a format optimized for decision
support. - Answers - data warehouse
Another name for a production database is a ____ database. - Answers - transactional
John is working in the customer table and needs to know what customers are located in
Florida. To find the information he would ____. - Answers - create a new query
How many users does a workgroup database usually support? - Answers - 50
Which of the following products do not provide an enterprise database? - Answers - MS
Access
The design of a ____ database recognizes the use of historical and aggregated data. -
Answers - data warehouse
Data processing (DP) specialists are in existence because of ____. - Answers - the
need to track data and produce required reports
A ____ system is composed of software, hardware, data, procedures and people. -
Answers - database
Where was a traditional file system normally stored? - Answers - file cabinet
A record consists of a ____. - Answers - set of one or more fields
All fields for a specific entity can be grouped together as a ____. - Answers - record
A raw fact such as a telephone number is known as ____. - Answers - data
A(n) ____ allows the user to specify what must be done without specifying how it must
be done. - Answers - nonprocedural language
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. - Answers -
independence
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 ____. - Answers - data dependence
Human beings view data according to its ____ data format. - Answers - logical
____ independence exists when it is possible to make changes in the file structure
without affecting the application program's ability to access the data. - Answers -
Structural
, Data ____ exists when the same data are stored unnecessarily at different places. -
Answers - Structural
Data ____ exists when the same data are stored unnecessarily at different places. -
Answers - inconsistent redundant data
Data ____ is defined as "the condition in which all of the data in the database are
consistent with the real-world events and conditions." - Answers - integrity
A data ____ develops when all of the required changes in the redundant data are not
made successfully. - Answers - anomaly
The term ____ refers to an organization of components that define and regulate the
collection, storage, management, and use of data within a database environment. -
Answers - database system
____ are the people who use application programs to run the organization's daily
operations. - Answers - End users
Database management systems, operating systems, applications and utilities are all
examples of ____. - Answers - software
____ are considered database architects. - Answers - Database designers
Where does the DBMS store the definitions of data elements and their relationships? -
Answers - data dictionary
____ are the instructions and rules that govern the design and use of the database
system. - Answers - Procedures
Activities that make the database perform more efficiently in terms of storage and
access speed are known as performance ____. - Answers - tuning
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) ____. - Answers - query language
____ deals with fixing the database after a failure such as a disk or power failure. -
Answers - Recovery
____ is the de facto query language and data access standard supported by the
majority of DBMS vendors. - Answers - Structured Query Language
Traditionally, database designers relied on ____ to help them develop a good design. -
Answers - good judgment
The word ____ indicates that the facts have not yet been processed to reveal their
meaning. - Answers - raw
Processed data, or ____, can be used as the foundation for decision making. - Answers
- information
Raw data must be properly ____ for storage, processing, and presentation. - Answers -
formatted
What is a key characteristic of knowledge? - Answers - "new" knowledge can be derived
from "old" knowledge
Accurate, relevant, and timely ____ is the key to good decision making. - Answers -
information
What is the name for data about data? - Answers - metadata
Data management is a discipline that focuses on ____. - Answers - the proper
generation, storage, and retrieval of data
What is a benefit of using a DBMS? - Answers - they help create an environment for
end users to have access to more data
The ____ manages interaction between the end user and the database. - Answers -
DBMS
The ____ receives all application requests and translates them into the complex
operations required to fulfill requests. - Answers - DBMS
An ad hoc query is a ____. - Answers - spur-of-the-moment question
Wider access to well-managed data promotes a(n) ____ view of the organization's
operations and a clearer view of the big picture. - Answers - integrated
What is the name for an answer to a query that the DBMS sends back to the
application? - Answers - query result set
A single-user database that runs on a personal computer is called a(n) ____ database. -
Answers - desktop
A database that supports data distributed across several different sites is called a(n)
____ database. - Answers - distributed
,The ____ is a specialized database that stores data in a format optimized for decision
support. - Answers - data warehouse
Another name for a production database is a ____ database. - Answers - transactional
John is working in the customer table and needs to know what customers are located in
Florida. To find the information he would ____. - Answers - create a new query
How many users does a workgroup database usually support? - Answers - 50
Which of the following products do not provide an enterprise database? - Answers - MS
Access
The design of a ____ database recognizes the use of historical and aggregated data. -
Answers - data warehouse
Data processing (DP) specialists are in existence because of ____. - Answers - the
need to track data and produce required reports
A ____ system is composed of software, hardware, data, procedures and people. -
Answers - database
Where was a traditional file system normally stored? - Answers - file cabinet
A record consists of a ____. - Answers - set of one or more fields
All fields for a specific entity can be grouped together as a ____. - Answers - record
A raw fact such as a telephone number is known as ____. - Answers - data
A(n) ____ allows the user to specify what must be done without specifying how it must
be done. - Answers - nonprocedural language
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. - Answers -
independence
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 ____. - Answers - data dependence
Human beings view data according to its ____ data format. - Answers - logical
____ independence exists when it is possible to make changes in the file structure
without affecting the application program's ability to access the data. - Answers -
Structural
, Data ____ exists when the same data are stored unnecessarily at different places. -
Answers - Structural
Data ____ exists when the same data are stored unnecessarily at different places. -
Answers - inconsistent redundant data
Data ____ is defined as "the condition in which all of the data in the database are
consistent with the real-world events and conditions." - Answers - integrity
A data ____ develops when all of the required changes in the redundant data are not
made successfully. - Answers - anomaly
The term ____ refers to an organization of components that define and regulate the
collection, storage, management, and use of data within a database environment. -
Answers - database system
____ are the people who use application programs to run the organization's daily
operations. - Answers - End users
Database management systems, operating systems, applications and utilities are all
examples of ____. - Answers - software
____ are considered database architects. - Answers - Database designers
Where does the DBMS store the definitions of data elements and their relationships? -
Answers - data dictionary
____ are the instructions and rules that govern the design and use of the database
system. - Answers - Procedures
Activities that make the database perform more efficiently in terms of storage and
access speed are known as performance ____. - Answers - tuning
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) ____. - Answers - query language
____ deals with fixing the database after a failure such as a disk or power failure. -
Answers - Recovery
____ is the de facto query language and data access standard supported by the
majority of DBMS vendors. - Answers - Structured Query Language
Traditionally, database designers relied on ____ to help them develop a good design. -
Answers - good judgment
