Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Chapter: 13
Q201:
To determine the GPA of a student, which entities are involved?
A. Student and Program
B. Student and Semester
C. Program and Course
D. Course and Teacher
Correct Answer:
B
Chapter: 13
Q202:
The primary key of the 'Semester' entity is __________.
A. semester_Start_Date
B. semester_End_Date
C. semester_Name
D. course_Code
Correct Answer:
C
Chapter: 13
Q203:
A course code and semester code together form a __________ key in the 'Course Offered' entity.
A. primary
B. composite
C. foreign
D. unique
Correct Answer:
B
Chapter: 13
Q204:
The 'Enrollment' entity represents a __________ relationship between 'Student' and 'Course Offered.'
A. one-to-one
B. one-to-many
C. many-to-many
D. zero-to-many
Correct Answer:
C
Chapter: 13
Q205:
Which attribute in the 'Program' entity specifies the level of the course?
A. max_Dur
B. no_of_Semesters
C. Pr_Lvl
D. pr_Code
Correct Answer:
C
Chapter: 13
Q206:
The outcome of the analysis phase in database design is __________.
A. Conceptual Database Design
B. Logical Database Design
C. Physical Database Design
D. Database Implementation
Correct Answer:
A
Chapter: 13
Q207:
The logical database design phase depends on the __________.
A. tool used
B. analysis phase
C. E-R Diagram
D. attributes identified
Correct Answer:
A
Chapter: 13
Q208:
Which attribute is multi-valued in the 'Course' entity?
A. course_Code
B. course_Name
C. course_Prereq
D. Courses_Offered_in
Correct Answer:
C
Chapter: 13
Q209:
The 'Result' entity can be derived from __________.
A. GPA and CGPA
B. Semester and Course
C. Student and Teacher
D. Program and Courses
Correct Answer:
A
Chapter: 13
Q210:
In the E-R Diagram, the relationship between 'Semester' and 'Course' is __________.
A. many-to-many
B. one-to-many
C. one-to-one
D. zero-to-many
Correct Answer:
A
Chapter: 13
Q211:
The 'Enrollment' entity requires a composite key of __________.
A. semester, course, student
B. student, program, teacher
C. teacher, course, semester
D. course, student, semester
Correct Answer:
A
Chapter: 13
Q212:
The 'Conceptual Database Design' is __________ of any tool or data model.
A. independent
B. dependent
C. optional
D. none
Correct Answer:
A
Chapter: 13
Q213:
Which entity is not included in the final E-R Diagram but can be used for relationships?
A. Controller
B. Student
C. Teacher
D. Course
Correct Answer:
A
Chapter: 14
Q214:
What is the primary focus of logical database design?
A. Data structure implementation
B. Data storage requirements
C. Database structure for users
D. Query optimization
Correct Answer:
C
Chapter: 14
Q215:
Which data model is most popular for logical database design in modern systems?
A. Hierarchical
B. Network
C. Relational
D. Object-oriented
Correct Answer:
C
Chapter: 14
Q216:
In the relational data model (RDM), what structure is primarily used to represent data?
A. Table
B. Tree
C. Graph
D. Document
Correct Answer:
A
Chapter: 14
Q217:
Which of the following is NOT a property of database relations in RDM?
A. Atomic values in cells
B. Distinct column names
C. Order of rows matters
D. Values from the same domain
Correct Answer:
C
Chapter: 14
Q218:
What does the relational data model (RDM) use as its basic structure?
A. Entity
B. Relation
C. Schema
D. Attribute
Correct Answer:
B
Chapter: 14
Q219:
The relational data model supports which type of schema architecture?
A. Three Level Schema Architecture
B. Two Level Schema Architecture
C. Single Level Schema Architecture
D. Multi-Level Schema Architecture
Correct Answer:
A
Chapter: 14
Q220:
What is the primary advantage of the relational data model (RDM)?
A. Complexity
B. Strong Mathematical Foundation
C. Large Data Size Handling
D. Network Integration
Correct Answer:
B