Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Multiple Choice Questions
Q181: In the ER Data model for an examination system, what is a prerequisite course?
- A: A course that is mandatory for enrolling in another course
- B: A course that is optional for all students
- C: A course that is taken after the current course
- D: A course that has no relevance to the system
View Answer
A
Q182: What does the Data Flow Diagram (DFD) show in an examination system?
- A: The graphical design of the system
- B: The interaction of different entities with the system
- C: The financial details of the system
- D: The performance evaluation metrics
View Answer
B
Q183: Which external entity provides a list of students who are enrolled in a class?
- A: The controller
- B: The registration system
- C: The student
- D: The teacher
View Answer
B
Q184: The cumulative GPA is calculated based on _______.
- A: Grade points from a single semester
- B: Grade points from all passed semesters
- C: Assignments and quizzes
- D: Only the final exam results
View Answer
B
Q185: Fill in the blank: The difference between enrolled courses and offered courses is due to _______.
- A: prerequisites and student situations
- B: student preferences
- C: teacher availability
- D: course fees
View Answer
A
Q186: What is the purpose of the Cross Reference Matrix (CRM)?
- A: To find out which values or attributes appear in which reports
- B: To design the database schema
- C: To calculate the GPA and CGPA
- D: To evaluate teacher performance
View Answer
A
Q187: The Level 0 Diagram includes which of the following modules?
- A: Subject registration, Result submission, Result calculation
- B: Student enrollment, Teacher assignment, Course scheduling
- C: Exam scheduling, Grade calculation, Result reporting
- D: Transcript generation, Attendance tracking, Class results
View Answer
A
Q188: The teacher submits results for assignments, quizzes, and tests to which process?
- A: Result collection process
- B: Result calculation process
- C: Registration process
- D: GPA calculation process
View Answer
A
Q189: In the DFD, what does Process 1.0 handle?
- A: The validity of registration information
- B: The calculation of GPAs
- C: The submission of exam results
- D: The storage of student data
View Answer
A
Q190: What does the ER-Diagram help to create in the analysis phase?
- A: The design of the database schema
- B: The flow of data within the system
- C: The user interface for the system
- D: The graphical design of the system
View Answer
A