DATABASE MANAGEMENT SYSTEM (DBMS)
EXAMINATION QUESTIONS AND CORRECT ANSWER
WITH EXLANATION GRADED A+ STUDY GUIDE
SOUTHERN NEW HAMPSHIRE UNIVERSITY
1. DBMS stands for:
A. Database Management System
B. Data Binary Management System
C. Digital Backup Memory System
D. Data Build Model Structure
Answer: A
Rationale: DBMS manages databases.
2. A database is:
A. Organized collection of data
B. Hardware device
C. Programming language
D. Operating system
Answer: A
Rationale: Structured data storage.
3. DBMS is used to:
A. Store and manage data
B. Design hardware
C. Browse internet
D. Write programs only
Answer: A
Rationale: Data handling system.
4. Example of DBMS is:
A. MySQL
B. Windows
C. Python
D. Excel only
Answer: A
Rationale: Database software.
,5. Data redundancy means:
A. Duplicate data
B. Secure data
C. Encrypted data
D. Deleted data
Answer: A
Rationale: Repeated data storage.
6. Data inconsistency occurs when:
A. Data does not match
B. Data is encrypted
C. Data is sorted
D. Data is compressed
Answer: A
Rationale: Conflicting data values.
7. DBMS reduces:
A. Redundancy
B. Speed
C. Memory
D. Security
Answer: A
Rationale: Eliminates duplication.
8. Table in DBMS is called:
A. Relation
B. File
C. Stack
D. Tree
Answer: A
Rationale: Relational model term.
9. Row in a table is:
A. Tuple
B. Attribute
C. Field
D. Column
Answer: A
Rationale: Single record.
, 10. Column in a table is:
A. Attribute
B. Tuple
C. Record
D. Node
Answer: A
Rationale: Data field.
11. Primary key is:
A. Unique identifier
B. Duplicate value
C. Foreign file
D. Random field
Answer: A
Rationale: Uniquely identifies records.
12. Foreign key is:
A. Link between tables
B. Primary key only
C. Duplicate data
D. File type
Answer: A
Rationale: Relationship between tables.
13. Candidate key is:
A. Possible primary key
B. Duplicate key
C. Random value
D. Foreign file
Answer: A
Rationale: Potential identifier.
14. Super key is:
A. Set of attributes identifying rows
B. Single column only
C. File type
D. Query type
Answer: A
Rationale: Unique identification set.
EXAMINATION QUESTIONS AND CORRECT ANSWER
WITH EXLANATION GRADED A+ STUDY GUIDE
SOUTHERN NEW HAMPSHIRE UNIVERSITY
1. DBMS stands for:
A. Database Management System
B. Data Binary Management System
C. Digital Backup Memory System
D. Data Build Model Structure
Answer: A
Rationale: DBMS manages databases.
2. A database is:
A. Organized collection of data
B. Hardware device
C. Programming language
D. Operating system
Answer: A
Rationale: Structured data storage.
3. DBMS is used to:
A. Store and manage data
B. Design hardware
C. Browse internet
D. Write programs only
Answer: A
Rationale: Data handling system.
4. Example of DBMS is:
A. MySQL
B. Windows
C. Python
D. Excel only
Answer: A
Rationale: Database software.
,5. Data redundancy means:
A. Duplicate data
B. Secure data
C. Encrypted data
D. Deleted data
Answer: A
Rationale: Repeated data storage.
6. Data inconsistency occurs when:
A. Data does not match
B. Data is encrypted
C. Data is sorted
D. Data is compressed
Answer: A
Rationale: Conflicting data values.
7. DBMS reduces:
A. Redundancy
B. Speed
C. Memory
D. Security
Answer: A
Rationale: Eliminates duplication.
8. Table in DBMS is called:
A. Relation
B. File
C. Stack
D. Tree
Answer: A
Rationale: Relational model term.
9. Row in a table is:
A. Tuple
B. Attribute
C. Field
D. Column
Answer: A
Rationale: Single record.
, 10. Column in a table is:
A. Attribute
B. Tuple
C. Record
D. Node
Answer: A
Rationale: Data field.
11. Primary key is:
A. Unique identifier
B. Duplicate value
C. Foreign file
D. Random field
Answer: A
Rationale: Uniquely identifies records.
12. Foreign key is:
A. Link between tables
B. Primary key only
C. Duplicate data
D. File type
Answer: A
Rationale: Relationship between tables.
13. Candidate key is:
A. Possible primary key
B. Duplicate key
C. Random value
D. Foreign file
Answer: A
Rationale: Potential identifier.
14. Super key is:
A. Set of attributes identifying rows
B. Single column only
C. File type
D. Query type
Answer: A
Rationale: Unique identification set.
