MauryaHub PYQ Practice

Database Management System · End Term · Jan 2023 · AN

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

Question 322 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 Q322

Question 323 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 Q323

Question 324 MSQ · 2.0 marks

Source diagram or notation
A.
45, 65, 8, 9, 15, 11, 22, 48, 95, 46, 6
B.
45, 65, 6, 9, 15, 22, 11, 48, 95, 46, 8
C.
45, 65, 9, 8, 15, 22, 11, 48, 95, 46, 6
D.
45, 65, 8, 9, 15, 22, 11, 48, 95, 46, 6

A published solution is not available for this question yet.

Report a correction for Q324

Question 325 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 Q325

Question 326 MSQ · 2.0 marks

The snapshot of a database at a point of time is provided below. Which of the following statements are correct with respect to the procedure followed after a system crash?
Source diagram or notation
A.
Transaction T1 and T2 must roll back.
B.
Transaction T3 must be undone.
C.
Redo transaction T1 and T2
D.
Redo transaction T1, T2, and T3

A published solution is not available for this question yet.

Report a correction for Q326

Question 327 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 Q327

Question 328 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 Q328

Question 329 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
E.Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q329

Question 330 MCQ · 1.0 marks

Source diagram or notation
A.
It provides poor read and write performance.
B.
It requires a large number of disks.
C.
It provides no fault tolerance or data redundancy.
D.
All of these.

A published solution is not available for this question yet.

Report a correction for Q330

Question 331 MCQ · 1.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 Q331

Question 332 MCQ · 1.0 marks

Which of the following precedence graphs represents a schedule that is not conflict serializable?
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 Q332

Question 333 MCQ · 1.0 marks

Which of the following backup strategies provides the most comprehensive protection against data loss?
A.
Incremental backup
B.
Full backup
C.
Differential backup
D.
All of these

A published solution is not available for this question yet.

Report a correction for Q333

Question 334 MCQ · 1.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 Q334

Question 335 MCQ · 1.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 Q335

Question 336 MCQ · 2.0 marks

Consider a B-tree based index with an order p = 25. Assume that each node in the B-tree is 80% full. What is the minimum number of keys that the B-tree can have?
A.
19,880
B.
19,800
C.
18,000
D.
19,999

A published solution is not available for this question yet.

Report a correction for Q336

Question 337 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 Q337

Question 338 MCQ · 3.0 marks

Source diagram or notation
A.
A-1, B-6, C-1, D-4
B.
A-1, B-6, C-2, D-3
C.
A-2, B-5, C-1, D-3
D.
A-2, B-5, C-2, D-4

A published solution is not available for this question yet.

Report a correction for Q338

Question 339 MCQ · 3.0 marks

Source diagram or notation
A.
{40, 80}
B.
{40}
C.
{10, 30}
D.
{40, 20}

A published solution is not available for this question yet.

Report a correction for Q339

Question 340 NAT · 2.0 marks

Consider a magnetic disk with 16 platters, 2 surfaces/platter, 1024 tracks/surface, 2048 sectors/track, and 1024 bytes/sector. The disk rotates with 6000 revolutions per minute. What is the minimum number of bits required for addressing all the sectors?

A published solution is not available for this question yet.

Report a correction for Q340

Question 341 NAT · 3.0 marks

Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q341

Question 342 NAT · 3.0 marks

Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q342

Question 343 MSQ · 3.0 marks

Consider the following schema diagram of **IPLt20** and answer the given subquestions
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 Q343

Question 344 MCQ · 1.0 marks

Consider the following schema diagram of **IPLt20** and answer the given subquestions
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 Q344

Question 345 MCQ · 2.0 marks

Answer the subquestions on the basis of the given data.
Source diagram or notation
According to the figure disk-4 has crashed. What data is present in the two blocks of disk-4? Note: Assume block size is 4 bits
A.
block A: 0101, block B: 0101
B.
block A: 1110, block B: 0100
C.
block A: 1111, block B: 0110
D.
block A: 0001, block B: 0001

A published solution is not available for this question yet.

Report a correction for Q345

Question 346 MCQ · 2.0 marks

Answer the subquestions on the basis of the given data.
Source diagram or notation
Assume that the binary values represent 8-bit ASCII code. What is the data word present inside this RAID-5 storage system? Note: The ASCII value of ‘A’ is 65 and ‘a’ is 97.
A.
POST
B.
PORT
C.
PART
D.
PLUM       **Business Analytics** **Section Id :** 64065338410 **Section Number :** 13 **Section type :** Online **Mandatory or Optional :** Mandatory **Number of Questions :** 18 **Number of Questions to be attempted :** 18 **Section Marks :** 45 **Display Number Panel :** Yes **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 Q346