1
DATA MANAGEMENT FOUNDATIONS EXAMS WITH
CORRECT ANSWERS AND BEST GRADED 2025
OODM - -answer--object-oriented data model. A data model whose basic modeling structure is
an object.
object - -answer--An abstract representation of a real world entity that has a unique identity,
embedded properties, and the ability to interact with other objects and itself.
OODBMS - -answer--object-oriented database management system. Data management
software used to manage data in an object-oriented database model
hashed files - -answer--Files which use a hash function to decide where a record should be
placed on a disk. This allows for faster data lookup without the use of an index file.
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. Information
consists of transformed data and facilitates decision making.
knowledge - -answer--The body of information and facts about a specific subject. A key
characteristic is that new knowledge can be derived from old knowledge.
, 2
database management - -answer--A process that focuses on data collection, storage, and
retrieval. Common data management functions include addition, deletion, modification, and
listing.
database - -answer--A shared, integrated computer structure that houses a collection of related
data. A database contains two types of data: end-user data (raw facts) and metadata.
DBMS - -answer--The collection of programs 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 (inconsistent) results.
query - -answer--A question or task asked by an end user of a database in the form of SQL code.
A specific request for data manipulation issued by the end user or the application to the DBMS.
ad hoc query - -answer--A "spur-of-the-moment" question.
query results 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.
DBMS advantages (7) - -answer--- improved data sharing
- improved data security
- better data integration
- minimized data inconsistency
- improved data access
, 3
- improved decision making
- increased end-user productivity
single vs multiuser database - -answer--supports single or multiple users
desktop database - -answer--A single-user database that runs on a personal computer.
workgroup database - -answer--A multiuser database that usually supports fewer than 50 users
or is used for a specific department in an organization.
enterprise database - -answer--The overall company data representation, which provides
support for present and expected future needs.
centralized vs distributed database - -answer--- A database located at a single site.
- 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, such
as Microsoft Azure or Amazon AWS.
general purpose vs discipline specific database - -answer--- variety of data used in multiple
disciplines.
- data focused on specific subject areas.
OLTP database - -answer--online transaction processing
AKA operational database
AKA transactional database
AKA production database
DATA MANAGEMENT FOUNDATIONS EXAMS WITH
CORRECT ANSWERS AND BEST GRADED 2025
OODM - -answer--object-oriented data model. A data model whose basic modeling structure is
an object.
object - -answer--An abstract representation of a real world entity that has a unique identity,
embedded properties, and the ability to interact with other objects and itself.
OODBMS - -answer--object-oriented database management system. Data management
software used to manage data in an object-oriented database model
hashed files - -answer--Files which use a hash function to decide where a record should be
placed on a disk. This allows for faster data lookup without the use of an index file.
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. Information
consists of transformed data and facilitates decision making.
knowledge - -answer--The body of information and facts about a specific subject. A key
characteristic is that new knowledge can be derived from old knowledge.
, 2
database management - -answer--A process that focuses on data collection, storage, and
retrieval. Common data management functions include addition, deletion, modification, and
listing.
database - -answer--A shared, integrated computer structure that houses a collection of related
data. A database contains two types of data: end-user data (raw facts) and metadata.
DBMS - -answer--The collection of programs 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 (inconsistent) results.
query - -answer--A question or task asked by an end user of a database in the form of SQL code.
A specific request for data manipulation issued by the end user or the application to the DBMS.
ad hoc query - -answer--A "spur-of-the-moment" question.
query results 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.
DBMS advantages (7) - -answer--- improved data sharing
- improved data security
- better data integration
- minimized data inconsistency
- improved data access
, 3
- improved decision making
- increased end-user productivity
single vs multiuser database - -answer--supports single or multiple users
desktop database - -answer--A single-user database that runs on a personal computer.
workgroup database - -answer--A multiuser database that usually supports fewer than 50 users
or is used for a specific department in an organization.
enterprise database - -answer--The overall company data representation, which provides
support for present and expected future needs.
centralized vs distributed database - -answer--- A database located at a single site.
- 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, such
as Microsoft Azure or Amazon AWS.
general purpose vs discipline specific database - -answer--- variety of data used in multiple
disciplines.
- data focused on specific subject areas.
OLTP database - -answer--online transaction processing
AKA operational database
AKA transactional database
AKA production database
