Database Management System MCQs with Answers
Practice important Database Management System MCQs with answers and explanations.
Chapter: 12
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
Correct Answer:
A
Chapter: 12
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
Correct Answer:
B
Chapter: 12
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
Correct Answer:
B
Chapter: 12
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
Correct Answer:
B
Chapter: 12
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
Correct Answer:
A
Chapter: 12
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
Correct Answer:
A
Chapter: 12
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
Correct Answer:
A
Chapter: 12
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
Correct Answer:
A
Chapter: 12
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
Correct Answer:
A
Chapter: 12
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
Correct Answer:
A
Chapter: 12
Q191:
Fill in the blank: The result data for a student is updated after calculating the _______.
A. GPA
B. CGPA
C. Attendance
D. Assignments
Correct Answer:
A
Chapter: 12
Q192:
The teacher interacts with the examination system by _______.
A. Providing a list of students to the controller
B. Submitting assignments and quizzes data
C. Calculating GPAs
D. Generating transcripts
Correct Answer:
B
Chapter: 12
Q193:
Which entity is NOT included in the ER-Diagram for the examination system?
A. Controller
B. Student
C. Courses
D. Registration
Correct Answer:
A
Chapter: 12
Q194:
What is the role of the result collection process in the examination system?
A. It calculates the GPAs of students
B. It submits and organizes the results provided by teachers
C. It manages student registration
D. It updates the registration database
Correct Answer:
B
Chapter: 13
Q195:
The primary key for the 'Program' entity is represented by which attribute?
A. pr_Code
B. max_Dur
C. no_of_Semesters
D. Pr_Lvl
Correct Answer:
A
Chapter: 13
Q196:
Which attribute of the 'Student' entity represents the student's unique identification?
A. st_Name
B. st_Father_name
C. st_GPA
D. Reg_No
Correct Answer:
D
Chapter: 13
Q197:
A 'Course' entity may have multiple prerequisites. This describes a _______ relationship.
A. one-to-one
B. one-to-many
C. many-to-many
D. recursive
Correct Answer:
D
Chapter: 13
Q198:
The cardinality between 'Program' and 'Courses' is __________.
A. one-to-one
B. one-to-many
C. many-to-many
D. zero-to-many
Correct Answer:
B
Chapter: 13
Q199:
In an E-R Diagram, the relationship between 'Student' and 'Course Offered' is described as __________.
A. one-to-one
B. many-to-many
C. one-to-many
D. zero-to-many
Correct Answer:
B
Chapter: 13
Q200:
The 'Teacher' entity includes which of the following attributes?
A. teacher_Reg_No
B. course_Code
C. st_GPA
D. semester_Start_Date
Correct Answer:
A