CPS 510 PRACTICE TEST PAPER 2026
PRECISE SOLUTIONS INCLUDED
◍ What are the main components of a database system? Answer:
Data, hardware, software, and users.
◍ What does the data component include? Answer: Integrated and
shared data with multiple views for different users or departments.
◍ What is a DBMS? Answer: Database Management System —
software that manages the definition, storage, retrieval, and update of
data.
◍ What are the roles of database users? Answer: Application
programmers, end users, database administrators (DBA), and data
administrators (DA).
◍ What is the difference between a DBA and DA? Answer: DA
defines what data to store and who can access it; DBA enforces and
implements those decisions technically.
◍ What defines a database? Answer: A collection of persistent data
used by an enterprise's applications.
◍ What are examples of static, dynamic, and quasi-static data?
Answer: Static: SIN; Dynamic: bank balance; Quasi-static: salary.
, ◍ Why use databases? Answer: For shared data, reduced redundancy,
improved integrity and security, transaction support, and consistency.
◍ What is data redundancy? Answer: Duplication of data across files
or systems.
◍ What is data integrity? Answer: Ensures correctness and validity of
stored data.
◍ What are transactions in databases? Answer: Logical units of work
that execute completely or not at all, maintaining consistency.
◍ What is data independence? Answer: Ability to modify the database
schema without changing application programs.
◍ What is logical data independence? Answer: Change conceptual
schema without affecting external views or applications.
◍ What is physical data independence? Answer: Change internal
storage details without affecting conceptual or external schemas.
◍ Why is the relational model significant? Answer: Introduced in
1969-70; represents data as tables (relations) with mathematical
foundations.
PRECISE SOLUTIONS INCLUDED
◍ What are the main components of a database system? Answer:
Data, hardware, software, and users.
◍ What does the data component include? Answer: Integrated and
shared data with multiple views for different users or departments.
◍ What is a DBMS? Answer: Database Management System —
software that manages the definition, storage, retrieval, and update of
data.
◍ What are the roles of database users? Answer: Application
programmers, end users, database administrators (DBA), and data
administrators (DA).
◍ What is the difference between a DBA and DA? Answer: DA
defines what data to store and who can access it; DBA enforces and
implements those decisions technically.
◍ What defines a database? Answer: A collection of persistent data
used by an enterprise's applications.
◍ What are examples of static, dynamic, and quasi-static data?
Answer: Static: SIN; Dynamic: bank balance; Quasi-static: salary.
, ◍ Why use databases? Answer: For shared data, reduced redundancy,
improved integrity and security, transaction support, and consistency.
◍ What is data redundancy? Answer: Duplication of data across files
or systems.
◍ What is data integrity? Answer: Ensures correctness and validity of
stored data.
◍ What are transactions in databases? Answer: Logical units of work
that execute completely or not at all, maintaining consistency.
◍ What is data independence? Answer: Ability to modify the database
schema without changing application programs.
◍ What is logical data independence? Answer: Change conceptual
schema without affecting external views or applications.
◍ What is physical data independence? Answer: Change internal
storage details without affecting conceptual or external schemas.
◍ Why is the relational model significant? Answer: Introduced in
1969-70; represents data as tables (relations) with mathematical
foundations.
