Home / Study library / Database Management System / End Term · Sep 2023 Database Management System · End Term · Sep 2023 · AN
Database Management System · End Term · Sep 2023 AN
← Course papers · Start practice / exam
This page contains the reliably extracted subset, not the complete original paper.
Questions and published explanations below are available without starting a test. Some questions may not have a published solution yet.
0 / 20 published solutions
Q2 Q3 Q4 Q5 Q6 Q7 Q8 Q9 Q10 Q11 Q12 Q13 Q14 Q15 Q16 Q17 Q18 Q19 Q20 Q21
Question 2 MCQ · 3.0 marks A. A = Tea, B = Zury, C = Our’s cafe, D = Tea, E = 19-10-21
B. A = Coffee, B = Zury, C = Our’s cafe, D = Coffee, E = 19-10-21
C. A = Tea, B = Zury, C = Your’s cafe, D = Coffee, E = 21-10-21
D. A = Coffee, B = Zury, C = Your’s cafe, D = Tea , E = 21-10-21
A published solution is not available for this question yet.
Report a correction for Q2
Question 3 MCQ · 3.0 marks A. D1 is a lossless decomposition and D2 is a lossy decomposition.
B. D1 is a lossy decomposition and D2 is a lossless decomposition.
C. D1 and D2 both are lossless decompositions.
D. D1 and D2 both are lossy decompositions.
A published solution is not available for this question yet.
Report a correction for Q3
Question 4 MCQ · 3.0 marks A. Names of all beverage items from the brand Keventer that have lower prices
than all food items from the brand Amul
B. Names of all food items from the brand Keventer that have lower prices than all beverage items
from the brand Amul
C. Names of all food items from the brand Keventer that have higher prices than
all food and beverage items from the brand Amul
D. Names of all beverage items from the brand Amul that have a lower price than
all food and beverage items from the brand Keventer
A published solution is not available for this question yet.
Report a correction for Q4
Question 5 MCQ · 3.0 marks A published solution is not available for this question yet.
Report a correction for Q5
Question 6 MCQ · 3.0 marks A. A = 700,B = 450,C = 1000,D = 460
B. A = 500,B = 450,C = 1100,D = 560
C. A = 700,B = 900,C = 1100,D = 560
D. A = 500,B = 900,C = 1000,D = 560
A published solution is not available for this question yet.
Report a correction for Q6
Question 7 MSQ · 1.0 marks A published solution is not available for this question yet.
Report a correction for Q7
Question 8 MCQ · 3.0 marks A. B. C. D. A published solution is not available for this question yet.
Report a correction for Q8
Question 9 MCQ · 3.0 marks A. B. C. D. A published solution is not available for this question yet.
Report a correction for Q9
Question 10 MCQ · 2.0 marks Construct a binary search tree by inserting the following elements in the given order 30,20, 27, 86,
103, 25, 60, 90, 10, 15. Find out the elements present in the non-leaf nodes (including root node) of
the constructed binary search tree.
Choose the correct option.
A published solution is not available for this question yet.
Report a correction for Q10
Question 11 MCQ · 2.0 marks A. Names of the 3 youngest students
B. Names of the 3 oldest students
C. Names of the 4 oldest students
D. Names of the 4 youngest students
A published solution is not available for this question yet.
Report a correction for Q11
Question 12 MCQ · 2.0 marks A published solution is not available for this question yet.
Report a correction for Q12
Question 13 MCQ · 2.0 marks A published solution is not available for this question yet.
Report a correction for Q13
Question 14 MCQ · 2.0 marks A. B. C. D. A published solution is not available for this question yet.
Report a correction for Q14
Question 15 NAT · 3.0 marks A published solution is not available for this question yet.
Report a correction for Q15
Question 16 NAT · 3.0 marks A published solution is not available for this question yet.
Report a correction for Q16
Question 17 NAT · 3.0 marks A published solution is not available for this question yet.
Report a correction for Q17
Question 18 MSQ · 3.0 marks A. Minimum 5 tables are required to convert the given ER diagram into the
relational model
B. Every manager has at least one dependent
C. Every manager is appointed as an advisor for some employee
D. A dependent can be related to at most one manager
A published solution is not available for this question yet.
Report a correction for Q18
Question 19 MSQ · 3.0 marks A. Schedule **S** is conflict serializable.
B. Schedule **S** can be two-phase lockable.
C. Schedule **S** is not conflict serializable.
D. Schedule **S** can not be two-phase lockable.
A published solution is not available for this question yet.
Report a correction for Q19
Question 20 MCQ · 1.0 marks A. S1 and S3 are true, S2 is false
B. S1 is true, S2 and S3 are false
C. S2 is true, S1 and S3 are false
D. S1 and S2 are true, S3 is false
A published solution is not available for this question yet.
Report a correction for Q20
Question 21 NAT · 2.0 marks A published solution is not available for this question yet.
Report a correction for Q21