DATABASE PROCESSING FUNDAMENTALS
DESIGN AND IMPLEMENTATION
CERTIFICATION EVALUATION EXAMS SET
FULL QUESTIONS AND COMPLETE
SOLUTION
●● Analytical Database
Answer: A database focused primarily on storing historical data and
business metrics used for tactical or strategic decision making.
●● Business Intelligence (BI)
Answer: A comprehensive, cohesive, and integrated set of tools and
processes used to capture, collect, integrate, store, and analyze data with
the purpose of generating and presenting information to support business
decision making.
●● Centralized Database
Answer: A database located at a single site.
●● Cloud Database
Answer: A database that is created and maintained using cloud services,
such as Microsoft Azure or Amazon AWS.
, ●● Data
Answer: Raw facts, or facts that have not yet been processed to reveal
their meaning to the end user.
●● Data Anomoly
Answer: A data abnormality in which inconsistent changes have been
made to a database. For example, and employee moves, but the address
change is not corrected in all files in the database.
●● Data Dictionary
Answer: 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 information resources
dictionary.
●● Data Inconsistency
Answer: A condition in which different versions of the same data yield
different (inconsistent) results.
●● Data Independence
Answer: A condition in which data access is unaffected by changes in
the physical data storage characteristics.
DESIGN AND IMPLEMENTATION
CERTIFICATION EVALUATION EXAMS SET
FULL QUESTIONS AND COMPLETE
SOLUTION
●● Analytical Database
Answer: A database focused primarily on storing historical data and
business metrics used for tactical or strategic decision making.
●● Business Intelligence (BI)
Answer: A comprehensive, cohesive, and integrated set of tools and
processes used to capture, collect, integrate, store, and analyze data with
the purpose of generating and presenting information to support business
decision making.
●● Centralized Database
Answer: A database located at a single site.
●● Cloud Database
Answer: A database that is created and maintained using cloud services,
such as Microsoft Azure or Amazon AWS.
, ●● Data
Answer: Raw facts, or facts that have not yet been processed to reveal
their meaning to the end user.
●● Data Anomoly
Answer: A data abnormality in which inconsistent changes have been
made to a database. For example, and employee moves, but the address
change is not corrected in all files in the database.
●● Data Dictionary
Answer: 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 information resources
dictionary.
●● Data Inconsistency
Answer: A condition in which different versions of the same data yield
different (inconsistent) results.
●● Data Independence
Answer: A condition in which data access is unaffected by changes in
the physical data storage characteristics.
