©Jason McConnel 2025 ALL RIGHTS RESERVED.
Data Management Exam Questions With
Correct Answers A+
Data - Answer✔Raw facts or facts that have not yet been processed to reveal their meaning to
the end user
Information - Answer✔The result of processing raw data to reveal its meaning.
Knowledge - Answer✔The body of information and facts about a specific subject
Data Management - Answer✔A process that focuses on data collection, storage, and retrieval.
(addition, deletion, modification, listing)
Database - Answer✔A shared, integrated computer structure that houses a collection of related
data.
End-user data - Answer✔raw facts
metadata - Answer✔Data about data characteristics and relationships
Database Management System (DBMS) - Answer✔The collection of progams that manages the
database structure and controls access to the data stored in the database
Data inconsistency - Answer✔a condition in which different versions of the same data yield
different results
Query - Answer✔A question or task asked by an end user of a database in the form of SQL code
Ad hoc query - Answer✔a "spur of the moment" question
Query result set - Answer✔The collection of data rows returned by a query
Data quality - Answer✔A comprehensive approach to ensuring the accuracy, validity, and
timeliness of data
Singe-user database - Answer✔A database that supports only one user at a time
desktop database - Answer✔a single-useer database that runs on a personal computer
multiuser database - Answer✔A database that supporest multiple concurrent users
Workgroup database - Answer✔A multiuser database that usually supports fewer than 50 users
or is used for a specific department in an organization
1|Page
, ©Jason McConnel 2025 ALL RIGHTS RESERVED.
Enterprise Database - Answer✔the overall company data representation which provides support
for present and expected future needs
Centralized Database - Answer✔A databse located at a single site
Distributed Database - Answer✔A logically related database that is stored in two or more
physically independent sites
Cloud Database - Answer✔A database that is created and maintained using cloud services
General Purpose Database - Answer✔A database that contains a wide variety of data used in
multiple disciplines
Discipline-Specific Database - Answer✔A database that contains data focused on specific
subject areas
Operational Database - Answer✔A database designed primarily to support a company's day to
day operations
Analytical Database - Answer✔A database focused primarily on storing historical data and
business metrics used for tactical or strategic decision making
Data Warehouse - Answer✔A specialized database that stores historical and aggregated data in a
format optimized for decision support
Online Analytical Processing (OLAP) - Answer✔A set of tools that provide advanced data
analysis for retrieving, processing, and modeling data from the data warehouse
Business Intelligence - Answer✔A set of tools and processes used to capture, collect, integrate,
store, and analyze data to support business decision making
Unstructured Data - Answer✔Data that exists in its original, raw state.
Structured Data - Answer✔Data that has been formatted to facilitate storage, use and information
generation.
Semistructed Data - Answer✔Data that has already been processed to some extent
Extensible Markup Language (XML) - Answer✔A metalanguage used to represent and
manipulate data elements. Allows for the manipulation of document's data elements.
XML Database - Answer✔A database system that stores and manages semistructured XML data
NoSQL - Answer✔A new generation of database management systems that is not based on the
traditional relational database model
Database design - Answer✔The process that yields the description of the database structure and
determines the database components. The 2nd phase of Database Life Cycle
Data Processing (DP) Specialist - Answer✔The person responsible for developing and managing
a computerized file processing system
2|Page
Data Management Exam Questions With
Correct Answers A+
Data - Answer✔Raw facts or facts that have not yet been processed to reveal their meaning to
the end user
Information - Answer✔The result of processing raw data to reveal its meaning.
Knowledge - Answer✔The body of information and facts about a specific subject
Data Management - Answer✔A process that focuses on data collection, storage, and retrieval.
(addition, deletion, modification, listing)
Database - Answer✔A shared, integrated computer structure that houses a collection of related
data.
End-user data - Answer✔raw facts
metadata - Answer✔Data about data characteristics and relationships
Database Management System (DBMS) - Answer✔The collection of progams that manages the
database structure and controls access to the data stored in the database
Data inconsistency - Answer✔a condition in which different versions of the same data yield
different results
Query - Answer✔A question or task asked by an end user of a database in the form of SQL code
Ad hoc query - Answer✔a "spur of the moment" question
Query result set - Answer✔The collection of data rows returned by a query
Data quality - Answer✔A comprehensive approach to ensuring the accuracy, validity, and
timeliness of data
Singe-user database - Answer✔A database that supports only one user at a time
desktop database - Answer✔a single-useer database that runs on a personal computer
multiuser database - Answer✔A database that supporest multiple concurrent users
Workgroup database - Answer✔A multiuser database that usually supports fewer than 50 users
or is used for a specific department in an organization
1|Page
, ©Jason McConnel 2025 ALL RIGHTS RESERVED.
Enterprise Database - Answer✔the overall company data representation which provides support
for present and expected future needs
Centralized Database - Answer✔A databse located at a single site
Distributed Database - Answer✔A logically related database that is stored in two or more
physically independent sites
Cloud Database - Answer✔A database that is created and maintained using cloud services
General Purpose Database - Answer✔A database that contains a wide variety of data used in
multiple disciplines
Discipline-Specific Database - Answer✔A database that contains data focused on specific
subject areas
Operational Database - Answer✔A database designed primarily to support a company's day to
day operations
Analytical Database - Answer✔A database focused primarily on storing historical data and
business metrics used for tactical or strategic decision making
Data Warehouse - Answer✔A specialized database that stores historical and aggregated data in a
format optimized for decision support
Online Analytical Processing (OLAP) - Answer✔A set of tools that provide advanced data
analysis for retrieving, processing, and modeling data from the data warehouse
Business Intelligence - Answer✔A set of tools and processes used to capture, collect, integrate,
store, and analyze data to support business decision making
Unstructured Data - Answer✔Data that exists in its original, raw state.
Structured Data - Answer✔Data that has been formatted to facilitate storage, use and information
generation.
Semistructed Data - Answer✔Data that has already been processed to some extent
Extensible Markup Language (XML) - Answer✔A metalanguage used to represent and
manipulate data elements. Allows for the manipulation of document's data elements.
XML Database - Answer✔A database system that stores and manages semistructured XML data
NoSQL - Answer✔A new generation of database management systems that is not based on the
traditional relational database model
Database design - Answer✔The process that yields the description of the database structure and
determines the database components. The 2nd phase of Database Life Cycle
Data Processing (DP) Specialist - Answer✔The person responsible for developing and managing
a computerized file processing system
2|Page
