INSY 3304 Database Exam 1 || Errorless Answers 100%.
Data correct answers Raw facts or facts that have not yet been processed to reveal their meaning
to the end user.
information correct answers the result of processing raw data to reveal its meaning.
What are the components of a database system environment? correct answers -Computer
-Peripherals
-Operating System
-DBMS Software
-Application programs and utilities software (GUI)
-Systems administrators
-Database administrators
-Database designers
-Systems analysts and programmers
-End users
-Procedures
-Data
What are the functions of the DBMS? correct answers -Data dictionary management
-Data storage management
-Data transformation
-Security management
-Multiuser access control
-Backup and recovery management
-Data integrity management
, -Database access languages and APIs
-Database communication interfaces
Data Dictionary correct answers A DBMS component that stores metadata—data about data. It
also contains the data definitions as well as their characteristics and relationships.
Data warehouse correct answers a specialized database that stores data in a format optimized for
decision support and stores historical, aggregated data.
Why is the data warehouse used? correct answers Used for managerial decision making -
strategic and tactical.
Data Dependence correct answers A data condition in which data representation and
manipulation are dependent on the physical data storage characteristics.
Structural Dependence correct answers A data characteristic in which a change in the database
schema affects data access, thus requiring changes in all access programs.
Data Inconsistency correct answers A condition in which different versions of the same data
yield different (inconsistent) results.
Data integrity correct answers In a relational database, a condition in which the data in the
database complies with all entity and referential integrity constraints.
Data redundancy correct answers Exists when the same data is stored unnecessarily at different
places.
System catalog correct answers A detailed system data dictionary that describes all objects in a
database.
Data correct answers Raw facts or facts that have not yet been processed to reveal their meaning
to the end user.
information correct answers the result of processing raw data to reveal its meaning.
What are the components of a database system environment? correct answers -Computer
-Peripherals
-Operating System
-DBMS Software
-Application programs and utilities software (GUI)
-Systems administrators
-Database administrators
-Database designers
-Systems analysts and programmers
-End users
-Procedures
-Data
What are the functions of the DBMS? correct answers -Data dictionary management
-Data storage management
-Data transformation
-Security management
-Multiuser access control
-Backup and recovery management
-Data integrity management
, -Database access languages and APIs
-Database communication interfaces
Data Dictionary correct answers A DBMS component that stores metadata—data about data. It
also contains the data definitions as well as their characteristics and relationships.
Data warehouse correct answers a specialized database that stores data in a format optimized for
decision support and stores historical, aggregated data.
Why is the data warehouse used? correct answers Used for managerial decision making -
strategic and tactical.
Data Dependence correct answers A data condition in which data representation and
manipulation are dependent on the physical data storage characteristics.
Structural Dependence correct answers A data characteristic in which a change in the database
schema affects data access, thus requiring changes in all access programs.
Data Inconsistency correct answers A condition in which different versions of the same data
yield different (inconsistent) results.
Data integrity correct answers In a relational database, a condition in which the data in the
database complies with all entity and referential integrity constraints.
Data redundancy correct answers Exists when the same data is stored unnecessarily at different
places.
System catalog correct answers A detailed system data dictionary that describes all objects in a
database.
