CS 302 FINAL EXAM 3 QUESTIONS WITH SOLUTIONS 2025
GRADED A+
✔✔Enterprise database: - ✔✔supports many users across many departments
✔✔Centeralized database: - ✔✔data is located at a single site.
✔✔Distributed database: - ✔✔data is distributed across different sites.
✔✔Cloud database: - ✔✔created and maintained using cloud data services that provide
defined performance measures for the database
✔✔General purpose databases: - ✔✔contains a wide variety of data used in multiple
disciplines
✔✔Discipline specific databases: - ✔✔contains data focused on specific subject areas
✔✔Operational database: - ✔✔designed to support a company's day-to-day operations
✔✔Analytical database: - ✔✔stores historical data and business metric used exclusively
for tactical or strategic making
✔✔Data warehouse: - ✔✔stores data in a format optimized for decision support
✔✔Online analytical processing (OLAP): - ✔✔enable retrieving, processing, and
modeling data from the data warehouse
✔✔Business intelligence: - ✔✔captures and processes business data to generate
information that support decision making
✔✔Unstructured data: - ✔✔it exists in their original state
✔✔Structured data: - ✔✔it results from formatting
✔✔Semistructured data: - ✔✔processed to some extent
✔✔Extensible Markup Language (XML): - ✔✔represent data elements in textual format
✔✔Structural dependence: - ✔✔access to a file is dependent on its own structure
✔✔Structural independence: - ✔✔file structure is changed without affecting the
application's ability to access the data.
GRADED A+
✔✔Enterprise database: - ✔✔supports many users across many departments
✔✔Centeralized database: - ✔✔data is located at a single site.
✔✔Distributed database: - ✔✔data is distributed across different sites.
✔✔Cloud database: - ✔✔created and maintained using cloud data services that provide
defined performance measures for the database
✔✔General purpose databases: - ✔✔contains a wide variety of data used in multiple
disciplines
✔✔Discipline specific databases: - ✔✔contains data focused on specific subject areas
✔✔Operational database: - ✔✔designed to support a company's day-to-day operations
✔✔Analytical database: - ✔✔stores historical data and business metric used exclusively
for tactical or strategic making
✔✔Data warehouse: - ✔✔stores data in a format optimized for decision support
✔✔Online analytical processing (OLAP): - ✔✔enable retrieving, processing, and
modeling data from the data warehouse
✔✔Business intelligence: - ✔✔captures and processes business data to generate
information that support decision making
✔✔Unstructured data: - ✔✔it exists in their original state
✔✔Structured data: - ✔✔it results from formatting
✔✔Semistructured data: - ✔✔processed to some extent
✔✔Extensible Markup Language (XML): - ✔✔represent data elements in textual format
✔✔Structural dependence: - ✔✔access to a file is dependent on its own structure
✔✔Structural independence: - ✔✔file structure is changed without affecting the
application's ability to access the data.
