MauryaHub PYQ Practice

Database Management System · End Term · Jan 2025 · AN

Database Management System · End Term · Jan 2025 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 · 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 Q2

Question 3 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 Q3

Question 4 MCQ · 2.0 marks

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

A published solution is not available for this question yet.

Report a correction for Q4

Question 5 MCQ · 3.0 marks

Consider the following schedule **S**. **S**:W1(A), W3(A), W3(C), R2(A), W2(A), W1(B), W3(B) Consider the following statements. **Statement 1**: The given schedule S is Conflict serializable. **Statement 2**: All Conflict serializable schedules are 2-P lockable. **Statement 3**: The given schedule is 2-P lockable. Which of the following options is correct?
A.
Statement 1 is true and statement 3 is false
B.
Statement 2 is true and statement 3 is false
C.
Statements 1 and 2 are true
D.
All these statements are true.

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.
19
B.
20
C.
21
D.
22

A published solution is not available for this question yet.

Report a correction for Q6

Question 7 MCQ · 3.0 marks

Source diagram or notation
A.
1-a, 2-d, 3-f
B.
1-b, 2-d, 3-e
C.
1-a, 2-c, 3-e
D.
1-b, 2-c, 3-f

A published solution is not available for this question yet.

Report a correction for Q7

Question 8 MCQ · 1.0 marks

Consider the following statements and select the correct option. 1. RAID 1 employs mirroring, maintaining two identical copies of the data on two different disks 2. RAID 3 has a single check disk with parity information.
A.
Both the statements are correct.
B.
Both the statements are wrong.
C.
Statement 1 is correct and statement 2 is wrong.
D.
Statement 1 is wrong and statement 2 is correct.

A published solution is not available for this question yet.

Report a correction for Q8

Question 9 MSQ · 1.0 marks

Choose the correct statement(s).
A.
In static hashing, overflow is commonly handled using overflow buckets or chaining.
B.
Dynamic hashing is suitable for applications where the number of records is unpredictable.
C.
Static hashing is ideal when the dataset size is expected to grow significantly.
D.
Dynamic hashing ensures that hash table utilization remains balanced as data changes.

A published solution is not available for this question yet.

Report a correction for Q9

Question 10 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 Q10

Question 11 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 Q11

Question 12 MSQ · 2.0 marks

Consider the following Entity Relationship Diagram:
Source diagram or notation
Choose the correct statements.
A.
A bank can provide exactly one ATM machine
B.
An ATM card can be used by multiple customers
C.
A customer can use multiple ATM cards
D.
An ATM card can be inserted in many ATM machines

A published solution is not available for this question yet.

Report a correction for Q12

Question 13 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 Q13

Question 14 NAT · 3.0 marks

Consider you have a file in your hard disk of size 1024 KB. The seek time of your hard disk read head is 4 ms, and the rotational speed is 30,000 rpm. The disk has 256 sectors per track, and each sector stores 512 bytes. Considering that the file data is stored in non-consecutive sectors, how much time will be required to read the whole file after a read request is made (in ms)?

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 NAT · 3.0 marks

Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q18

Question 19 NAT · 3.0 marks

Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q19

Question 20 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 Q20

Question 21 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
      **PDSA** **Section Id :** 64065387632 **Section Number :** 2 **Section type :** Online **Mandatory or Optional :** Mandatory **Number of Questions :** 26 **Number of Questions to be attempted :** 26 **Section Marks :** 100 **Display Number Panel :** Yes **Section Negative Marks :** 0 **Group All Questions :** No **Enable Mark as Answered Mark for Review and** No **Clear Response :** **Section Maximum Duration :** 0 **Section Minimum Duration :** 0 **Section Time In :** Minutes **Maximum Instruction Time :** 0

A published solution is not available for this question yet.

Report a correction for Q21