DATABASE SYSTEMS DESIGN IMPLEMENTATION AND MANAGEMENT ACTUAL TEST QUESTIONS AND SOLUTIONS COMPREHENSIVE REVIEW PACKAGE

DATABASE SYSTEMS DESIGN
IMPLEMENTATION AND MANAGEMENT
ACTUAL TEST QUESTIONS AND SOLUTIONS
COMPREHENSIVE REVIEW PACKAGE

●● What is a DBMS?
Answer: A Database Management System that manages data integrity
and consistency.


●● What are the limitations of file system data management?
Answer: Requires extensive programming, complex system
administration, difficult changes to structures, inadequate security
features, and redundant data.


●● What is structural dependence?
Answer: Access to a file depends on its structure.


●● What is structural independence?
Answer: Ability to change the file structure without affecting data access
programs.


●● What is data dependence?

, Answer: Data access programs must change when file storage
characteristics change.


●● What is data independence?
Answer: Ability to change data storage characteristics without affecting
data access programs.


●● What does the logical data format refer to?
Answer: How a human views the data.


●● What does the physical data format refer to?
Answer: How a computer sees the data.


●● Why is proper field naming important in databases?
Answer: It makes the file structure self-documenting and helps identify
the information contained in fields.


●● What is data redundancy?
Answer: Unnecessary storage of the same data in different places.


●● What are update anomalies?
Answer: Issues that occur when changes must be made to existing
records.