MauryaHub PYQ Practice

Database Management System · End Term · Jan 2024 · AN

Database Management System · End Term · Jan 2024 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 / 21 published solutions

Question 204 NAT · 3.0 marks

Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q204

Question 206 MCQ · 2.0 marks

Source diagram or notation
A.
24.8 milliseconds
B.
128 milliseconds
C.
248 milliseconds
D.
16.6 milliseconds

A published solution is not available for this question yet.

Report a correction for Q206

Question 207 MCQ · 2.0 marks

Source diagram or notation
A.
1
B.
2
C.
3
D.
4

A published solution is not available for this question yet.

Report a correction for Q207

Question 208 MCQ · 3.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 Q208

Question 209 MSQ · 1.0 marks

Choose the incorrect statement(s):
A.
Time complexity of searching in a BST is O(nlogn)
B.
In a B+ tree the leaf nodes are linked using a link list
C.
Sparse indices are generally faster than dense indices for locating records.
D.
B tree does not allow duplicate search-key values

A published solution is not available for this question yet.

Report a correction for Q209

Question 210 MSQ · 1.0 marks

Choose the correct statement(s):
A.
In Raid 0 architecture, if one disk fails, then all the data in the disk array is gone.
B.
Raid 1 architecture provides excellent fault tolerance
C.
In Raid 2 architecture, the striping unit consists of 2 bits.
D.
In Raid 5 architecture, recovery of only one disk failure is possible

A published solution is not available for this question yet.

Report a correction for Q210

Question 211 MSQ · 2.0 marks

Source diagram or notation
A.
T1 needs to be undone
B.
T2 can be ignored
C.
T1, T2 and T3 need to be redone
D.
T4 needs to be undone

A published solution is not available for this question yet.

Report a correction for Q211

Question 212 MSQ · 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 Q212

Question 213 MSQ · 3.0 marks

Source diagram or notation
A.
There can exist a coach who does not coach any team
B.
A coach can be coaching at most one team
C.
Every coach must be training at least one player
D.
A player must have one coach

A published solution is not available for this question yet.

Report a correction for Q213

Question 214 MSQ · 3.0 marks

Source diagram or notation
A.
Schedule **S1** is Conflict Serializable.
B.
Schedule **S2** is Conflict Serializable.
C.
Schedule **S1** is View Serializable.
D.
Schedule **S2** is View Serializable.

A published solution is not available for this question yet.

Report a correction for Q214

Question 215 MSQ · 3.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 Q215

Question 216 MSQ · 3.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 Q216

Question 217 MSQ · 3.0 marks

Source diagram or notation
A.
If F1 is applicable to relation **Books**, then it is 3NF
B.
If F2 is applicable to relation **Books**, then it is 2NF
C.
If F2 is applicable to relation **Books**, then it is BCNF
D.
If F1 is applicable to relation **Books**, then it is 3NF but not in BCNF

A published solution is not available for this question yet.

Report a correction for Q217

Question 218 NAT · 1.0 marks

Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q218

Question 219 NAT · 2.0 marks

Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q219

Question 220 NAT · 3.0 marks

Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q220

Question 221 NAT · 3.0 marks

Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q221

Question 222 NAT · 4.0 marks

Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q222

Question 223 NAT · 4.0 marks

Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q223

Question 224 NAT · 3.0 marks

Source diagram or notationSource diagram or notation

A published solution is not available for this question yet.

Report a correction for Q224

Question 225 MSQ · 2.0 marks

Source diagram or notation
Choose the correct expression(s) for the statement given below: Name all the teams from Spain, with at least 2 losses and at most 3 draws.
A.Source diagram or notation
B.Source diagram or notation
C.Source diagram or notation
D.Source diagram or notation
      **PDSA** **Section Id :** 64065356693 **Section Number :** 8 **Section type :** Online **Mandatory or Optional :** Mandatory **Number of Questions :** 24 **Number of Questions to be attempted :** 24 **Section Marks :** 100 **Display Number Panel :** Yes **Section Negative Marks :** 0 **Group All Questions :** No **Enable Mark as Answered Mark for Review and** Yes **Clear Response :** **Maximum Instruction Time :** 0

A published solution is not available for this question yet.

Report a correction for Q225