Home / Study library / Database Management System / End Term · Jan 2024 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
Q204 Q206 Q207 Q208 Q209 Q210 Q211 Q212 Q213 Q214 Q215 Q216 Q217 Q218 Q219 Q220 Q221 Q222 Q223 Q224 Q225
Question 204 NAT · 3.0 marks A published solution is not available for this question yet.
Report a correction for Q204
Question 206 MCQ · 2.0 marks A published solution is not available for this question yet.
Report a correction for Q206
Question 207 MCQ · 2.0 marks A published solution is not available for this question yet.
Report a correction for Q207
Question 208 MCQ · 3.0 marks A. B. C. D. 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 C. T1, T2 and T3 need to be redone
A published solution is not available for this question yet.
Report a correction for Q211
Question 212 MSQ · 2.0 marks A. B. C. D. A published solution is not available for this question yet.
Report a correction for Q212
Question 213 MSQ · 3.0 marks 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 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 A. B. C. D. A published solution is not available for this question yet.
Report a correction for Q215
Question 216 MSQ · 3.0 marks A. B. C. D. A published solution is not available for this question yet.
Report a correction for Q216
Question 217 MSQ · 3.0 marks 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 A published solution is not available for this question yet.
Report a correction for Q218
Question 219 NAT · 2.0 marks A published solution is not available for this question yet.
Report a correction for Q219
Question 220 NAT · 3.0 marks A published solution is not available for this question yet.
Report a correction for Q220
Question 221 NAT · 3.0 marks A published solution is not available for this question yet.
Report a correction for Q221
Question 222 NAT · 4.0 marks A published solution is not available for this question yet.
Report a correction for Q222
Question 223 NAT · 4.0 marks A published solution is not available for this question yet.
Report a correction for Q223
Question 224 NAT · 3.0 marks A published solution is not available for this question yet.
Report a correction for Q224
Question 225 MSQ · 2.0 marks 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. B. C. D.
**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