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