Database Management-Final Exam2025-
2026 ACTUAL EXAM COMPLETE
QUESTIONS AND CORRECT DETAILED
ANSWERS WITH RATIONALES
Relationship - CORRECT ANSWERS association between entities
Types of relationships: - CORRECT ANSWERS One-to-many: Each rep is associated with
many customers. Each customer is associated with a single rep
Database - CORRECT ANSWERS structure that can store information about different
categories of information and relationships between those categories
Database Management System (DBMS) - CORRECT ANSWERS program, or collection of
programs, through which users interact with a database; can create forms and reports
Advantages of database processing: - CORRECT ANSWERS Getting more information
from the same amount of data
Sharing data
Balancing conflicting requirements
Controlling redundancy
Facilitating consistency
Expanding security
, Increasing productivity
Providing data independence
Disadvantages of database processing: - CORRECT ANSWERS Larger file size
Increased complexity
Greater impact of failure
More difficult recovery
Rules of a Relation - CORRECT ANSWERS Two-dimensional table in which:
Entries are unnormalized
Each column has a distinct name (attribute name)
All values in a column are values of the same attribute
Order of columns is immaterial
Each row is distinct
2026 ACTUAL EXAM COMPLETE
QUESTIONS AND CORRECT DETAILED
ANSWERS WITH RATIONALES
Relationship - CORRECT ANSWERS association between entities
Types of relationships: - CORRECT ANSWERS One-to-many: Each rep is associated with
many customers. Each customer is associated with a single rep
Database - CORRECT ANSWERS structure that can store information about different
categories of information and relationships between those categories
Database Management System (DBMS) - CORRECT ANSWERS program, or collection of
programs, through which users interact with a database; can create forms and reports
Advantages of database processing: - CORRECT ANSWERS Getting more information
from the same amount of data
Sharing data
Balancing conflicting requirements
Controlling redundancy
Facilitating consistency
Expanding security
, Increasing productivity
Providing data independence
Disadvantages of database processing: - CORRECT ANSWERS Larger file size
Increased complexity
Greater impact of failure
More difficult recovery
Rules of a Relation - CORRECT ANSWERS Two-dimensional table in which:
Entries are unnormalized
Each column has a distinct name (attribute name)
All values in a column are values of the same attribute
Order of columns is immaterial
Each row is distinct
