2
C175 newest updated Exam with accurate detailed answers
|| || || || || || ||
ad hoc query - ✔✔A "spur-of-the-moment" question.
|| || || || || ||
analytical database - ✔✔A database focused primarily on storing historical data and
|| || || || || || || || || || || ||
business metrics used for tactical or strategic decision making.
|| || || || || || || ||
availability - ✔✔In the context of data security, it refers to the accessibility of data whenever
|| || || || || || || || || || || || || || ||
required by authorized users and for authorized purposes.
|| || || || || || || ||
Centralized - ✔✔A database located at a single site. || || || || || || || ||
cloud database - ✔✔A database that is created and maintained using cloud services, such as
|| || || || || || || || || || || || || ||
Microsoft Azure or Amazon AWS.
|| || || || ||
data - ✔✔Raw facts, or facts that have not yet been processed to reveal their meaning to the
|| || || || || || || || || || || || || || || || || ||
end user. ||
data anomaly - ✔✔A 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 - ✔✔A data condition in which data representation and manipulation are
|| || || || || || || || || || || || ||
dependent on the physical data storage characteristics. || || || || || ||
data dictionary - ✔✔A 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 known as an
|| || || || || || || || || || || || || || || || || ||
,2
information resource dictionary. See also active data dictionary, metadata, and passive data
|| || || || || || || || || || || ||
dictionary.
data inconsistency - ✔✔A condition in which different versions of the same data yield
|| || || || || || || || || || || || || ||
different (inconsistent) results.
|| ||
data independance - ✔✔A condition in which data access is unaffected by changes in the
|| || || || || || || || || || || || || || ||
physical data storage characteristics.
|| || ||
data integrity - ✔✔In a relational database, a condition in which the data in the database
|| || || || || || || || || || || || || || || ||
complies with all entity and referential integrity constraints.
|| || || || || || ||
data management - ✔✔A process that focuses on data collection, storage, and retrieval.
|| || || || || || || || || || || || ||
Common data management functions include addition, deletion, modification, and listing.
|| || || || || || || || ||
data processing (DP) specialist - ✔✔The person responsible for developing and managing a
|| || || || || || || || || || || || ||
computerized file processing system. || || ||
data redundancy - ✔✔Exists when the same data is stored unnecessarily at different places.
|| || || || || || || || || || || || ||
database - ✔✔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.
|| || || || || || || || || || || || ||
database design - ✔✔The 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 (DBMS) - ✔✔The collection of programs that manages the
|| || || || || || || || || || || ||
database structure and controls access to the data stored in the database.
|| || || || || || || || || || ||
,2
database system - ✔✔An organization of components that defines and regulates the
|| || || || || || || || || || || ||
collection, storage, management, and use of data in a database environment.
|| || || || || || || || || ||
desktop database - ✔✔A single-user database that runs on a personal computer.
|| || || || || || || || || || ||
discipline-specific databases - ✔✔A database that contains data focused on specific subject || || || || || || || || || || || ||
areas.
Enterprise Database - ✔✔The overall company data representation, which provides support
|| || || || || || || || || || ||
for present and expected future needs.
|| || || || ||
field - ✔✔An 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 - ✔✔A named collection of related records.
|| || || || || || ||
general-purpose databases - ✔✔A database that contains a wide variety of data used in
|| || || || || || || || || || || || || ||
multiple disciplines. ||
hub - ✔✔A 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 - ✔✔The result of processing raw data to reveal its meaning. Information
|| || || || || || || || || || || || ||
consists of transformed data and facilitates decision making.
|| || || || || || ||
, 2
islands of information - ✔✔In the old file system environment, pools of independent, often
|| || || || || || || || || || || || || ||
duplicated, and inconsistent data created and managed by different departments.
|| || || || || || || || ||
knowledge - ✔✔The 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 - ✔✔The way a person views data within the context of a problem
|| || || || || || || || || || || || || || || ||
domain.
metadata - ✔✔Data about data; that is, data about data characteristics and relationships.
|| || || || || || || || || || || || ||
See also data dictionary.
|| || ||
multiuser database - ✔✔A database that supports multiple concurrent users.
|| || || || || || || || ||
noSQL - ✔✔A new generation of database management systems that is not based on the
|| || || || || || || || || || || || || || ||
traditional relational database model. || || ||
online analytical processing (OLAP) - ✔✔Decision support system (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 (OLTP) database - ✔✔See operational database.
|| || || || || || || ||
Operational Database - ✔✔A database designed primarily to support a company's day-to-
|| || || || || || || || || || ||
day operations. Also known as a transactional database, OLTP database, or production
|| || || || || || || || || || || ||
database.
C175 newest updated Exam with accurate detailed answers
|| || || || || || ||
ad hoc query - ✔✔A "spur-of-the-moment" question.
|| || || || || ||
analytical database - ✔✔A database focused primarily on storing historical data and
|| || || || || || || || || || || ||
business metrics used for tactical or strategic decision making.
|| || || || || || || ||
availability - ✔✔In the context of data security, it refers to the accessibility of data whenever
|| || || || || || || || || || || || || || ||
required by authorized users and for authorized purposes.
|| || || || || || || ||
Centralized - ✔✔A database located at a single site. || || || || || || || ||
cloud database - ✔✔A database that is created and maintained using cloud services, such as
|| || || || || || || || || || || || || ||
Microsoft Azure or Amazon AWS.
|| || || || ||
data - ✔✔Raw facts, or facts that have not yet been processed to reveal their meaning to the
|| || || || || || || || || || || || || || || || || ||
end user. ||
data anomaly - ✔✔A 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 - ✔✔A data condition in which data representation and manipulation are
|| || || || || || || || || || || || ||
dependent on the physical data storage characteristics. || || || || || ||
data dictionary - ✔✔A 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 known as an
|| || || || || || || || || || || || || || || || || ||
,2
information resource dictionary. See also active data dictionary, metadata, and passive data
|| || || || || || || || || || || ||
dictionary.
data inconsistency - ✔✔A condition in which different versions of the same data yield
|| || || || || || || || || || || || || ||
different (inconsistent) results.
|| ||
data independance - ✔✔A condition in which data access is unaffected by changes in the
|| || || || || || || || || || || || || || ||
physical data storage characteristics.
|| || ||
data integrity - ✔✔In a relational database, a condition in which the data in the database
|| || || || || || || || || || || || || || || ||
complies with all entity and referential integrity constraints.
|| || || || || || ||
data management - ✔✔A process that focuses on data collection, storage, and retrieval.
|| || || || || || || || || || || || ||
Common data management functions include addition, deletion, modification, and listing.
|| || || || || || || || ||
data processing (DP) specialist - ✔✔The person responsible for developing and managing a
|| || || || || || || || || || || || ||
computerized file processing system. || || ||
data redundancy - ✔✔Exists when the same data is stored unnecessarily at different places.
|| || || || || || || || || || || || ||
database - ✔✔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.
|| || || || || || || || || || || || ||
database design - ✔✔The 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 (DBMS) - ✔✔The collection of programs that manages the
|| || || || || || || || || || || ||
database structure and controls access to the data stored in the database.
|| || || || || || || || || || ||
,2
database system - ✔✔An organization of components that defines and regulates the
|| || || || || || || || || || || ||
collection, storage, management, and use of data in a database environment.
|| || || || || || || || || ||
desktop database - ✔✔A single-user database that runs on a personal computer.
|| || || || || || || || || || ||
discipline-specific databases - ✔✔A database that contains data focused on specific subject || || || || || || || || || || || ||
areas.
Enterprise Database - ✔✔The overall company data representation, which provides support
|| || || || || || || || || || ||
for present and expected future needs.
|| || || || ||
field - ✔✔An 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 - ✔✔A named collection of related records.
|| || || || || || ||
general-purpose databases - ✔✔A database that contains a wide variety of data used in
|| || || || || || || || || || || || || ||
multiple disciplines. ||
hub - ✔✔A 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 - ✔✔The result of processing raw data to reveal its meaning. Information
|| || || || || || || || || || || || ||
consists of transformed data and facilitates decision making.
|| || || || || || ||
, 2
islands of information - ✔✔In the old file system environment, pools of independent, often
|| || || || || || || || || || || || || ||
duplicated, and inconsistent data created and managed by different departments.
|| || || || || || || || ||
knowledge - ✔✔The 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 - ✔✔The way a person views data within the context of a problem
|| || || || || || || || || || || || || || || ||
domain.
metadata - ✔✔Data about data; that is, data about data characteristics and relationships.
|| || || || || || || || || || || || ||
See also data dictionary.
|| || ||
multiuser database - ✔✔A database that supports multiple concurrent users.
|| || || || || || || || ||
noSQL - ✔✔A new generation of database management systems that is not based on the
|| || || || || || || || || || || || || || ||
traditional relational database model. || || ||
online analytical processing (OLAP) - ✔✔Decision support system (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 (OLTP) database - ✔✔See operational database.
|| || || || || || || ||
Operational Database - ✔✔A database designed primarily to support a company's day-to-
|| || || || || || || || || || ||
day operations. Also known as a transactional database, OLTP database, or production
|| || || || || || || || || || || ||
database.
