DBMS ASSESSMENT EXAM QUESTIONS
WITH CORRECT ANSWERS
The word ____ indicates that the facts have not yet been processed to reveal their
meaning. - Correct Answers -raw
Processed data, or ____, can be used as the foundation for decision making. - Correct
Answers -information
Raw data must be properly ____ for storage, processing, and presentation. - Correct
Answers -formatted
What is a key characteristic of knowledge? - Correct Answers -"new" knowledge can be
derived from "old" knowledge
Accurate, relevant, and timely ____ is the key to good decision making. - Correct
Answers -information
What is the name for data about data? - Correct Answers -metadata
Data management is a discipline that focuses on ____. - Correct Answers -the proper
generation, storage, and retrieval of data
What is a benefit of using a DBMS? - Correct 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. - Correct
Answers -DBMS
The ____ receives all application requests and translates them into the complex
operations required to fulfill requests. - Correct Answers -DBMS
An ad hoc query is a ____. - Correct 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. - Correct Answers -integrated
What is the name for an answer to a query that the DBMS sends back to the
application? - Correct Answers -query result set
,A single-user database that runs on a personal computer is called a(n) ____ database. -
Correct Answers -desktop
A database that supports data distributed across several different sites is called a(n)
____ database. - Correct Answers -distributed
The ____ is a specialized database that stores data in a format optimized for decision
support. - Correct Answers -data warehouse
Another name for a production database is a ____ database. - Correct 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 ____. - Correct Answers -create a new query
How many users does a workgroup database usually support? - Correct Answers -50
Which of the following products do not provide an enterprise database? - Correct
Answers -MS Access
The design of a ____ database recognizes the use of historical and aggregated data. -
Correct Answers -data warehouse
Data processing (DP) specialists are in existence because of ____. - Correct Answers -
the need to track data and produce required reports
A ____ system is composed of software, hardware, data, procedures and people. -
Correct Answers -database
Where was a traditional file system normally stored? - Correct Answers -file cabinet
A record consists of a ____. - Correct Answers -set of one or more fields
All fields for a specific entity can be grouped together as a ____. - Correct Answers -
record
A raw fact such as a telephone number is known as ____. - Correct Answers -data
A(n) ____ allows the user to specify what must be done without specifying how it must
be done. - Correct 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. - Correct 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 ____. - Correct Answers -data dependence
Human beings view data according to its ____ data format. - Correct 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. - Correct Answers
-Structural
Data ____ exists when the same data are stored unnecessarily at different places. -
Correct Answers -Structural
Data ____ exists when the same data are stored unnecessarily at different places. -
Correct 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." - Correct Answers -integrity
A data ____ develops when all of the required changes in the redundant data are not
made successfully. - Correct 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. -
Correct Answers -database system
____ are the people who use application programs to run the organization's daily
operations. - Correct Answers -End users
Database management systems, operating systems, applications and utilities are all
examples of ____. - Correct Answers -software
____ are considered database architects. - Correct Answers -Database designers
Where does the DBMS store the definitions of data elements and their relationships? -
Correct Answers -data dictionary
____ are the instructions and rules that govern the design and use of the database
system. - Correct Answers -Procedures
Activities that make the database perform more efficiently in terms of storage and
access speed are known as performance ____. - Correct 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) ____. - Correct Answers -query language
WITH CORRECT ANSWERS
The word ____ indicates that the facts have not yet been processed to reveal their
meaning. - Correct Answers -raw
Processed data, or ____, can be used as the foundation for decision making. - Correct
Answers -information
Raw data must be properly ____ for storage, processing, and presentation. - Correct
Answers -formatted
What is a key characteristic of knowledge? - Correct Answers -"new" knowledge can be
derived from "old" knowledge
Accurate, relevant, and timely ____ is the key to good decision making. - Correct
Answers -information
What is the name for data about data? - Correct Answers -metadata
Data management is a discipline that focuses on ____. - Correct Answers -the proper
generation, storage, and retrieval of data
What is a benefit of using a DBMS? - Correct 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. - Correct
Answers -DBMS
The ____ receives all application requests and translates them into the complex
operations required to fulfill requests. - Correct Answers -DBMS
An ad hoc query is a ____. - Correct 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. - Correct Answers -integrated
What is the name for an answer to a query that the DBMS sends back to the
application? - Correct Answers -query result set
,A single-user database that runs on a personal computer is called a(n) ____ database. -
Correct Answers -desktop
A database that supports data distributed across several different sites is called a(n)
____ database. - Correct Answers -distributed
The ____ is a specialized database that stores data in a format optimized for decision
support. - Correct Answers -data warehouse
Another name for a production database is a ____ database. - Correct 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 ____. - Correct Answers -create a new query
How many users does a workgroup database usually support? - Correct Answers -50
Which of the following products do not provide an enterprise database? - Correct
Answers -MS Access
The design of a ____ database recognizes the use of historical and aggregated data. -
Correct Answers -data warehouse
Data processing (DP) specialists are in existence because of ____. - Correct Answers -
the need to track data and produce required reports
A ____ system is composed of software, hardware, data, procedures and people. -
Correct Answers -database
Where was a traditional file system normally stored? - Correct Answers -file cabinet
A record consists of a ____. - Correct Answers -set of one or more fields
All fields for a specific entity can be grouped together as a ____. - Correct Answers -
record
A raw fact such as a telephone number is known as ____. - Correct Answers -data
A(n) ____ allows the user to specify what must be done without specifying how it must
be done. - Correct 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. - Correct 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 ____. - Correct Answers -data dependence
Human beings view data according to its ____ data format. - Correct 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. - Correct Answers
-Structural
Data ____ exists when the same data are stored unnecessarily at different places. -
Correct Answers -Structural
Data ____ exists when the same data are stored unnecessarily at different places. -
Correct 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." - Correct Answers -integrity
A data ____ develops when all of the required changes in the redundant data are not
made successfully. - Correct 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. -
Correct Answers -database system
____ are the people who use application programs to run the organization's daily
operations. - Correct Answers -End users
Database management systems, operating systems, applications and utilities are all
examples of ____. - Correct Answers -software
____ are considered database architects. - Correct Answers -Database designers
Where does the DBMS store the definitions of data elements and their relationships? -
Correct Answers -data dictionary
____ are the instructions and rules that govern the design and use of the database
system. - Correct Answers -Procedures
Activities that make the database perform more efficiently in terms of storage and
access speed are known as performance ____. - Correct 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) ____. - Correct Answers -query language
