CPS 510 MIDTERM ACTUAL TEST EXAM
STUDY GUIDE SOLVED QUESTIONS 2026
GRADED A+.
⫸ What are the main components of a database system? Answer:
Data, Hardware, Software (DBMS), and Users.
⫸ What does "data is integrated" mean in a database system?
Answer: Distinct files are unified into a single database, eliminating
redundancy between them.
⫸ What does "data is shared" mean? Answer: Multiple users or
departments can access the same data concurrently, though each may
have different views of it.
⫸ Give an example of shared and integrated data. Answer:
EMPLOYEE file used by HR and ENROLLMENT file used by the
training department share the DEPARTMENT info but view it
differently.
⫸ What does the hardware component of a DBMS do? Answer:
Stores data on disks, allowing direct access and rapid I/O; data is
operated on in main memory.
, ⫸ What is the role of the software in a database system? Answer:
The DBMS manages storage, access, and updates while hiding
hardware details from users.
⫸ What is the DBMS? Answer: Software that manages and controls
the database — shielding users from hardware, ensuring integrity,
concurrency, and security.
⫸ Name some DBMS-related software tools that might come with a
system. Answer: Application development tools, Transaction manager,
Report writer, Utilities like backup or reorganization.
⫸ Who are the users of a database system? Answer: Application
programmers, End users, Database Administrators (DBA), and Data
Administrators (DA).
⫸ What's the difference between a DBA and a DA? Answer: DA
decides what data to store and who can access it; DBA implements
those policies and manages technical database operations.
⫸ What is a database? Answer: A collection of persistent data used
by an organization's application systems to store true facts about
entities and relationships.
⫸ What is persistent data? Answer: Data that remains stored
permanently until explicitly deleted — unlike temporary data that
disappears after use.
STUDY GUIDE SOLVED QUESTIONS 2026
GRADED A+.
⫸ What are the main components of a database system? Answer:
Data, Hardware, Software (DBMS), and Users.
⫸ What does "data is integrated" mean in a database system?
Answer: Distinct files are unified into a single database, eliminating
redundancy between them.
⫸ What does "data is shared" mean? Answer: Multiple users or
departments can access the same data concurrently, though each may
have different views of it.
⫸ Give an example of shared and integrated data. Answer:
EMPLOYEE file used by HR and ENROLLMENT file used by the
training department share the DEPARTMENT info but view it
differently.
⫸ What does the hardware component of a DBMS do? Answer:
Stores data on disks, allowing direct access and rapid I/O; data is
operated on in main memory.
, ⫸ What is the role of the software in a database system? Answer:
The DBMS manages storage, access, and updates while hiding
hardware details from users.
⫸ What is the DBMS? Answer: Software that manages and controls
the database — shielding users from hardware, ensuring integrity,
concurrency, and security.
⫸ Name some DBMS-related software tools that might come with a
system. Answer: Application development tools, Transaction manager,
Report writer, Utilities like backup or reorganization.
⫸ Who are the users of a database system? Answer: Application
programmers, End users, Database Administrators (DBA), and Data
Administrators (DA).
⫸ What's the difference between a DBA and a DA? Answer: DA
decides what data to store and who can access it; DBA implements
those policies and manages technical database operations.
⫸ What is a database? Answer: A collection of persistent data used
by an organization's application systems to store true facts about
entities and relationships.
⫸ What is persistent data? Answer: Data that remains stored
permanently until explicitly deleted — unlike temporary data that
disappears after use.
