Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
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
View Answer
B
Q202: The primary key of the 'Semester' entity is __________.
- A: semester_Start_Date
- B: semester_End_Date
- C: semester_Name
- D: course_Code
View Answer
C
Q203: A course code and semester code together form a __________ key in the 'Course Offered' entity.
- A: primary
- B: composite
- C: foreign
- D: unique
View Answer
B
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
View Answer
C
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
View Answer
C
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
View Answer
A
Q207: The logical database design phase depends on the __________.
- A: tool used
- B: analysis phase
- C: E-R Diagram
- D: attributes identified
View Answer
A
Q208: Which attribute is multi-valued in the 'Course' entity?
- A: course_Code
- B: course_Name
- C: course_Prereq
- D: Courses_Offered_in
View Answer
C
Q209: The 'Result' entity can be derived from __________.
- A: GPA and CGPA
- B: Semester and Course
- C: Student and Teacher
- D: Program and Courses
View Answer
A
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
View Answer
A