MauryaHub PYQ Practice

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

Question 2 MCQ · 3.0 marks

Source diagram or notation
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

Source diagram or notation
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

Source diagram or notation
A.
Names of all beverage items from the brand Keventer that have lower prices than all food items from the brand Amul
B.Source diagram or notation
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

Source diagram or notation
A.
5
B.
4
C.
6
D.
3

A published solution is not available for this question yet.

Report a correction for Q5

Question 6 MCQ · 3.0 marks

Source diagram or notation
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

Source diagram or notation
A.
Course
B.
RoomNo
C.
Instructor
D.
None of these

A published solution is not available for this question yet.

Report a correction for Q7

Question 8 MCQ · 3.0 marks

Source diagram or notationSource diagram or notation
A.Source diagram or notation
B.Source diagram or notation
C.Source diagram or notation
D.Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q8

Question 9 MCQ · 3.0 marks

Source diagram or notationSource diagram or notation
A.Source diagram or notation
B.Source diagram or notation
C.Source diagram or notation
D.Source diagram or notation

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.
15, 25, 60,90
B.
10,27,103, 20,86
C.
10,27,103, 20,86, 30
D.
10,27,103

A published solution is not available for this question yet.

Report a correction for Q10

Question 11 MCQ · 2.0 marks

Source diagram or notation
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

Source diagram or notation
A.
11010010 AND 00010011
B.
11010010 OR 10100100
C.
11010010 AND 01001000
D.
00101101 OR 10100100

A published solution is not available for this question yet.

Report a correction for Q12

Question 13 MCQ · 2.0 marks

Source diagram or notation
A.
5
B.
4
C.
7
D.
6

A published solution is not available for this question yet.

Report a correction for Q13

Question 14 MCQ · 2.0 marks

Source diagram or notation
A.Source diagram or notation
B.Source diagram or notation
C.Source diagram or notation
D.Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q14

Question 15 NAT · 3.0 marks

Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q15

Question 16 NAT · 3.0 marks

Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q16

Question 17 NAT · 3.0 marks

Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q17

Question 18 MSQ · 3.0 marks

Source diagram or notation
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

Source diagram or notation
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

Source diagram or notation
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

Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q21