Data Management Foundation -
Assessment Practice Exam with
Questions and Answers 100
Revised
ad hoc query - answersA "spur-of-the-moment" question.
analytical database - answersA database focused primarily on storing historical data
and business metrics used for tactical or strategic decision making.
availability - answersIn the context of data security, it refers to the accessibility of data
whenever required by authorized users and for authorized purposes.
centralized database - answersA database located at a single site.
cloud database - answersA database that is created and maintained using cloud
services, such as Microsoft Azure, or Amazon AWS.
data - answersRaw facts, or facts that have not yet been processed to reveal their
meaning to the end user.
data anomaly - answersA data abnormality in which inconsistent changes have been
made to a database. For example, an employee moves, but the address change is not
corrected in all files in the database.
data dependence - answersA data condition in which data representation and
manipulation are dependent on the physical data storage characteristics.
data dictionary - answersA DBMS component that stores metadata - data about data.
Thus, the data dictionary contains the data definition as well as their characteristics and
relationships. A data dictionary may also include data that are external to the DBMS.
Also know as an information resource dictionary. See also active data dictionary,
metadata, and passive data dictionary.
data inconsistency - answersA condition in which different versions of the same data
yield different or inconsistent results.
data independence - answersA condition is which data access is unaffected by changes
in the physical data storage characteristics.
data integrity - answersIn a relational database, a condition in which the data in the
database complies with all entity and referential integrity constraints.
,data management - answersA process that focuses on data collection, storage, and
retrieval. Common data management functions include addition, deletion, modification,
and listing.
data processing or DP specialist - answersThe person responsible for developing and
managing a computerized file processing system.
data redundancy - answersExists when the same data is stored unnecessarily at
different places.
database - answersA shared, integrated computer structure that houses a collection of
related data. A database contains two types of data: end-user data or raw facts and
metadata.
database design - answersThe process that yields the description of the database
structure and determines the database components. The second phase of the Database
Life Cycle.
database management system or DBMS - answersThe collection of programs that
manages the database structure and controls access to the data stored in the database.
database system - answersAn organization of components that defines and regulates
the collection, storage, management, and use of data in a database environment.
desktop database - answersA single-user database that runs on a personal computer.
discipline-specific databases - answersA database that contains data focused on
specific subject areas.
enterprise database - answersThe overall company data representation, which provides
support for present and expected future needs.
field - answersAn alphabetic or numeric character or group of characters that defines a
characteristic of a person, place, or thing. For example, a person's Social Security
number, address, phone number, and bank balance all constitute fields.
file - answersA named collection of related records.
general-purpose database - answersA database that contains a wide variety of data
used in multiple disciplines.
hub - answersA warehouse of data packets housed in a central location on a local area
network. It contains multiple ports that copy the data in the data packets to make it
accessible to selected or all segments of the network.
,information - answersThe result of processing raw data to reveal its meaning.
Information consists of transformed data and facilitates decision making.
islands of information - answersIn the old file system environment, pools of
independent, often duplicated, and inconsistent data created and managed by different
departments.
knowledge - answersThe body of information and facts about a specific subject.
Knowledge implies familiarity, awareness, and understanding of information as it applies
to an environment. A key characteristic is that new knowledge can be derived from old
knowledge.
logical data format - answersThe way a person views data within the context of a
problem domain.
metadata - answersData about data; that is, data about data characteristics and
relationships. See also data dictionary.
multi-user database - answersA database that supports multiple concurrent users.
NoSQL - answersA new generation of database management systems that is not based
on the traditional relational database model.
online analytical processing or OLAP - answersDecision support systemor DSS tools
that use multidimensional data analysis techniques. OLAP creates an advanced data
analysis environment that supports decision making, business modeling, and operations
research.
online transaction processing or OLTP database - answersSee operational database.
operational database - answersA database designed to support a company's day-to-day
operations. Also known as a transactional database, OLTP database, or production
database.
performance tuning - answersActivities that make a database perform more efficiently in
terms of storage and access speed.
physical data format - answersThe way a computer "sees" or stores data.
production database - answersSee operational database.
query - answersA 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.
, query language - answersA non-procedural language that is used by a DBMS to
manipulate its data. An example of a query language is SQL.
query result set - answersThe collection of data rows returned by a query.
record - answersA collection of related or logically connected fields.
role - answersIn Oracle, a named collection of database access privileges that authorize
a user to connect to a database and use its system resources.
router - answers1- An intelligent device used to connect dissimilar networks.
2- Hardware/software equipment that connects multiple and diverse networks.
semi-structured data - answersData that has already been processed to some extent.
single-user database - answersA database that supports only one user at a time.
social media - answersWeb and mobile technologies that enable "anywhere, anytime,
always on" human interactions.
structural dependence - answersA data characteristic in which a change in the database
schema affects data access, thus requiring changes in all access programs.
structural independence - answersA data characteristic in which changes in the
database schema do not affect data access.
structured data - answersData that has been formatted to facilitate storage, use, and
information generation.
Structured Query Language or SQL - answersA powerful and flexible relational
database language composed of commands that enable users to create database and
table structures, perform various types of data manipulation and data administration,
and query the database to extract useful information.
transactional database - answersSee operation database.
unstructured data - answersData that exists in its original, raw state; that is, in the
format in which it was collected.
website - answersRefers to the Web server and the collection of Web pages stored on
the local hard disk of the server computer.
workgroup database - answersA multi-user database that usually supports fewer than
50 users or is used for a specific department in an organization.
Assessment Practice Exam with
Questions and Answers 100
Revised
ad hoc query - answersA "spur-of-the-moment" question.
analytical database - answersA database focused primarily on storing historical data
and business metrics used for tactical or strategic decision making.
availability - answersIn the context of data security, it refers to the accessibility of data
whenever required by authorized users and for authorized purposes.
centralized database - answersA database located at a single site.
cloud database - answersA database that is created and maintained using cloud
services, such as Microsoft Azure, or Amazon AWS.
data - answersRaw facts, or facts that have not yet been processed to reveal their
meaning to the end user.
data anomaly - answersA data abnormality in which inconsistent changes have been
made to a database. For example, an employee moves, but the address change is not
corrected in all files in the database.
data dependence - answersA data condition in which data representation and
manipulation are dependent on the physical data storage characteristics.
data dictionary - answersA DBMS component that stores metadata - data about data.
Thus, the data dictionary contains the data definition as well as their characteristics and
relationships. A data dictionary may also include data that are external to the DBMS.
Also know as an information resource dictionary. See also active data dictionary,
metadata, and passive data dictionary.
data inconsistency - answersA condition in which different versions of the same data
yield different or inconsistent results.
data independence - answersA condition is which data access is unaffected by changes
in the physical data storage characteristics.
data integrity - answersIn a relational database, a condition in which the data in the
database complies with all entity and referential integrity constraints.
,data management - answersA process that focuses on data collection, storage, and
retrieval. Common data management functions include addition, deletion, modification,
and listing.
data processing or DP specialist - answersThe person responsible for developing and
managing a computerized file processing system.
data redundancy - answersExists when the same data is stored unnecessarily at
different places.
database - answersA shared, integrated computer structure that houses a collection of
related data. A database contains two types of data: end-user data or raw facts and
metadata.
database design - answersThe process that yields the description of the database
structure and determines the database components. The second phase of the Database
Life Cycle.
database management system or DBMS - answersThe collection of programs that
manages the database structure and controls access to the data stored in the database.
database system - answersAn organization of components that defines and regulates
the collection, storage, management, and use of data in a database environment.
desktop database - answersA single-user database that runs on a personal computer.
discipline-specific databases - answersA database that contains data focused on
specific subject areas.
enterprise database - answersThe overall company data representation, which provides
support for present and expected future needs.
field - answersAn alphabetic or numeric character or group of characters that defines a
characteristic of a person, place, or thing. For example, a person's Social Security
number, address, phone number, and bank balance all constitute fields.
file - answersA named collection of related records.
general-purpose database - answersA database that contains a wide variety of data
used in multiple disciplines.
hub - answersA warehouse of data packets housed in a central location on a local area
network. It contains multiple ports that copy the data in the data packets to make it
accessible to selected or all segments of the network.
,information - answersThe result of processing raw data to reveal its meaning.
Information consists of transformed data and facilitates decision making.
islands of information - answersIn the old file system environment, pools of
independent, often duplicated, and inconsistent data created and managed by different
departments.
knowledge - answersThe body of information and facts about a specific subject.
Knowledge implies familiarity, awareness, and understanding of information as it applies
to an environment. A key characteristic is that new knowledge can be derived from old
knowledge.
logical data format - answersThe way a person views data within the context of a
problem domain.
metadata - answersData about data; that is, data about data characteristics and
relationships. See also data dictionary.
multi-user database - answersA database that supports multiple concurrent users.
NoSQL - answersA new generation of database management systems that is not based
on the traditional relational database model.
online analytical processing or OLAP - answersDecision support systemor DSS tools
that use multidimensional data analysis techniques. OLAP creates an advanced data
analysis environment that supports decision making, business modeling, and operations
research.
online transaction processing or OLTP database - answersSee operational database.
operational database - answersA database designed to support a company's day-to-day
operations. Also known as a transactional database, OLTP database, or production
database.
performance tuning - answersActivities that make a database perform more efficiently in
terms of storage and access speed.
physical data format - answersThe way a computer "sees" or stores data.
production database - answersSee operational database.
query - answersA 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.
, query language - answersA non-procedural language that is used by a DBMS to
manipulate its data. An example of a query language is SQL.
query result set - answersThe collection of data rows returned by a query.
record - answersA collection of related or logically connected fields.
role - answersIn Oracle, a named collection of database access privileges that authorize
a user to connect to a database and use its system resources.
router - answers1- An intelligent device used to connect dissimilar networks.
2- Hardware/software equipment that connects multiple and diverse networks.
semi-structured data - answersData that has already been processed to some extent.
single-user database - answersA database that supports only one user at a time.
social media - answersWeb and mobile technologies that enable "anywhere, anytime,
always on" human interactions.
structural dependence - answersA data characteristic in which a change in the database
schema affects data access, thus requiring changes in all access programs.
structural independence - answersA data characteristic in which changes in the
database schema do not affect data access.
structured data - answersData that has been formatted to facilitate storage, use, and
information generation.
Structured Query Language or SQL - answersA powerful and flexible relational
database language composed of commands that enable users to create database and
table structures, perform various types of data manipulation and data administration,
and query the database to extract useful information.
transactional database - answersSee operation database.
unstructured data - answersData that exists in its original, raw state; that is, in the
format in which it was collected.
website - answersRefers to the Web server and the collection of Web pages stored on
the local hard disk of the server computer.
workgroup database - answersA multi-user database that usually supports fewer than
50 users or is used for a specific department in an organization.
