MauryaHub PYQ Practice

Database Management System · End Term · Sep 2024 · AN

Database Management System · End Term · Sep 2024 AN

← Course papers · Start practice / exam

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 212 NAT · 2.0 marks

Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q212

Question 214 MCQ · 3.0 marks

Source diagram or notation
A.
A precedence graph of the schedule is cyclic
B.
The given schedule is not view serializable
C.
The given schedule is view serializable but not conflict serializable
D.
The given schedule is view serializable and conflict serializable

A published solution is not available for this question yet.

Report a correction for Q214

Question 215 MCQ · 3.0 marks

Source diagram or notation
A.
Statements 1 and 4 are correct.
B.
Statements 1 and 3 are correct.
C.
Statements 2 and 3 are correct.
D.
Statements 2 and 4 are correct.

A published solution is not available for this question yet.

Report a correction for Q215

Question 216 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 Q216

Question 217 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 Q217

Question 218 MCQ · 3.0 marks

Source diagram or notation
A.
The decomposition of **R** into **R1** and **R2** is dependency preserving.
B.
The decomposition of **R** into **R1** and **R2** is lossless.
C.
The schema **R1** is in 3NF.
D.
The schema **R2** is in 2NF.

A published solution is not available for this question yet.

Report a correction for Q218

Question 219 MCQ · 2.0 marks

Source diagram or notation
A.
team
B.
rating
C.
age
D.
type

A published solution is not available for this question yet.

Report a correction for Q219

Question 220 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 Q220

Question 221 MCQ · 2.0 marks

Consider seek time of your hard disk read head is 2ms, rotational speed is 30,000 RPM. The disk has 400 sectors/track and sector size is 128 bytes. What will be the transfer rate (KB/ms)?
A.
75 KB/ms
B.
25 KB/ms
C.
50 KB/ms
D.
100 KB/ms

A published solution is not available for this question yet.

Report a correction for Q221

Question 222 MCQ · 2.0 marks

Consider a non-empty B+-tree of order 16. What are the maximum and minimum number of keys that can be placed in the root node?
A.
max. number of keys = 15, min. number of keys = 8.
B.
max. number of keys = 15, min. number of keys = 1.
C.
max. number of keys = 16, min. number of keys = 1.
D.
max. number of keys = 16, min. number of keys = 8.

A published solution is not available for this question yet.

Report a correction for Q222

Question 223 MCQ · 2.0 marks

Consider a multilevel index with five levels as L1, L2, L3, L4 and L5. Let L1 be the innermost and L5 be the outermost levels. Let the index blocking factor or the maximum number of entries held by a block be 25. If the number of blocks in level L1 is 12,50,000, then how many blocks are required at L2, L3, L4 and L5?
A.
Number of blocks at L2 is 50000, Number of blocks at L3 is 2000, Number of blocks at L4 is 80, Number of blocks at L5 is 4
B.
Number of blocks at L2 is 125000, Number of blocks at L3 is 2000, Number of blocks at L4 is 80, Number of blocks at L5 is 1
C.
Number of blocks at L2 is 50000, Number of blocks at L3 is 2000, Number of blocks at L4 is 80, Number of blocks at L5 is 1
D.
Number of blocks at L2 is 125000, Number of blocks at L3 is 2500, Number of blocks at L4 is 80, Number of blocks at L5 is 4

A published solution is not available for this question yet.

Report a correction for Q223

Question 224 MCQ · 2.0 marks

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

A published solution is not available for this question yet.

Report a correction for Q224

Question 225 MCQ · 2.0 marks

Source diagram or notation
A.
ID and name of students who have not taken any course from Biology department
B.
ID and name of students who have taken courses from Biology department
C.
ID and name of students who have taken all the courses from Biology department
D.
ID and name of students who have not taken courses from other than Biology department

A published solution is not available for this question yet.

Report a correction for Q225

Question 226 MCQ · 1.0 marks

Consider the following statements: 1. Any transactions committed before the last checkpoint should be ignored. 2. Any transaction that was running at the time of failure needs to be redone. 3. It scans backwards from the end of the log to find the most recent < checkpointL > record. Choose the correct option.
A.
Statements 1 and 2 are correct
B.
Statements 1 and 3 are correct
C.
All the statements are correct
D.
Only Statement 1 is correct

A published solution is not available for this question yet.

Report a correction for Q226

Question 227 MSQ · 3.0 marks

Consider the ER Diagram as shown below:
Source diagram or notation
Identify the correct relational schema for the relationship set **Bank**, **Account** and **Manages** Note: The primary key is underlined.
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 Q227

Question 228 MSQ · 3.0 marks

Consider a state of transactions as shown in Figure 3.
Source diagram or notation
Which of the following statement(s) is/are correct according to the given figure?
A.
T1 can be ignored and T3 needs to be redone.
B.
T4 and T5 need to be undone.
C.
T1 needs to be redone and T4 can be undone.
D.
T2 needs to be undone and T4 needs to be redone.

A published solution is not available for this question yet.

Report a correction for Q228

Question 229 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 Q229

Question 230 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 Q230

Question 231 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 Q231

Question 232 MSQ · 2.0 marks

Source diagram or notation
Which of the following functional dependencies hold in the **Students** table?
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 Q232

Question 233 NAT · 3.0 marks

Consider a **Block nested loop join** for the two relations, **instructor** and **department**. Assuming the worst-case memory availability and **instructor** as the outer relation, the provided details are as follows:
Source diagram or notation
What is the number of blocks in the inner relations?

A published solution is not available for this question yet.

Report a correction for Q233