MauryaHub PYQ Practice

Database Management System · End Term · Sep 2022 · AN

Database Management System · End Term · Sep 2022 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 / 26 published solutions

Question 250 MCQ · 1.0 marks

The RAID-1 is implemented using four disks. How much space is being utilized effectively? [Note: Each disk has a size of 1 Terabyte]
A.
25%
B.
50%
C.
75%
D.
100%

A published solution is not available for this question yet.

Report a correction for Q250

Question 251 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 Q251

Question 252 MCQ · 1.0 marks

In RAID, what is A and I stands for?
A.
A: Allocation, I: Independent
B.
A: Allocation, I: Isolation
C.
A: Array, I: Independent
D.
A: Array, I: Isolation

A published solution is not available for this question yet.

Report a correction for Q252

Question 253 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 Q253

Question 254 MCQ · 1.0 marks

Consider a transaction in which 100 is debited from account **A** and credited to account **B**. Which among the following ACID properties ensure that the database executes the transaction completely or if a crash occurs in between it does not execute at all?
A.
Atomicity
B.
Consistency
C.
Isolation
D.
Durability

A published solution is not available for this question yet.

Report a correction for Q254

Question 255 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 Q255

Question 256 MCQ · 2.0 marks

Source diagram or notation
A.
No transaction needs Roll Back.
B.
Transaction T3 needs to Roll Back.
C.
Transaction T2 needs to Roll Back.
D.
Transaction T1 needs to Roll Back.

A published solution is not available for this question yet.

Report a correction for Q256

Question 257 MCQ · 2.0 marks

Source diagram or notation
A.
3,07,20,000 KB
B.
30 KB
C.
30,000 KB
D.
90,000 KB

A published solution is not available for this question yet.

Report a correction for Q257

Question 258 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 Q258

Question 259 MCQ · 3.0 marks

Insert the key values in the following order into an empty 3 order B tree: 50, 21, 92, 52, 27, 63, 97, 9, 76, 4. The resultant B tree must contain which of the following key values for non-leaf nodes?
A.
21,50, 63
B.
21, 50, 63, 89
C.
4,21, 50, 63
D.
4,9, 27, 52, 76, 92, 97

A published solution is not available for this question yet.

Report a correction for Q259

Question 260 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 Q260

Question 261 MCQ · 3.0 marks

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

A published solution is not available for this question yet.

Report a correction for Q261

Question 262 MSQ · 1.0 marks

Source diagram or notation
A.
Relation is in 2NF as well as in 3NF.
B.
Relation is in 2NF but not in 3NF.
C.
Relation is in 3NF as well as in BCNF.
D.
Relation is in 3NF but not in BCNF.

A published solution is not available for this question yet.

Report a correction for Q262

Question 263 MSQ · 1.0 marks

Source diagram or notation
A.
RS
B.
QS
C.
PS
D.
RU

A published solution is not available for this question yet.

Report a correction for Q263

Question 264 MSQ · 2.0 marks

Source diagram or notation
A.
Number of block transfer require=420600
B.
Number of block transfer require=480800
C.
Number of seeks require=1200
D.
Number of seeks require=1600

A published solution is not available for this question yet.

Report a correction for Q264

Question 265 MSQ · 2.0 marks

Consider the instance of the relation **customer** given in Figure 2.
Source diagram or notation
Which among the following multivalued dependencies does this instance **customer** satisfy?
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 Q265

Question 266 MSQ · 3.0 marks

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

A published solution is not available for this question yet.

Report a correction for Q266

Question 267 MSQ · 3.0 marks

Source diagram or notation
A.
(A,C, G,H)
B.
(A,B,C)
C.
(A,B,G)
D.
(A,B, G,H)

A published solution is not available for this question yet.

Report a correction for Q267

Question 268 MSQ · 3.0 marks

Source diagram or notation
A.
Schedule S1 is conflict serializable.
B.
Schedule S1 can be two phase lockable.
C.
Schedule S2 is conflict serializable.
D.
Schedule S2 can be two phase lockable.

A published solution is not available for this question yet.

Report a correction for Q268

Question 269 NAT · 2.0 marks

Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q269

Question 270 NAT · 2.0 marks

Consider a Binary Search Tree(BST) consists of 32 elements. What is the maximum possible height of the given BST?

A published solution is not available for this question yet.

Report a correction for Q270

Question 271 NAT · 2.0 marks

Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q271

Question 272 NAT · 3.0 marks

Consider a multilevel index, where the outermost level must be kept in a single disk block. In each block, 10 entries can be accommodated. There are 2000 blocks at the innermost level (first-level index). How many blocks has to be accessed to access a record from the data file by searching the multilevel index?

A published solution is not available for this question yet.

Report a correction for Q272

Question 273 MCQ · 1.0 marks

Consider the relational schema as shown in figure 1 and answer the given subquestions
Source diagram or notationSource diagram or notation
A.
50
B.
500
C.
0
D.
10

A published solution is not available for this question yet.

Report a correction for Q273

Question 274 MSQ · 2.0 marks

Consider the relational schema as shown in figure 1 and answer the given subquestions
Source diagram or notation
Suppose the **ON DELETE CASCADE** constraint is not applied between the tables and we want to delete the record of team id ’T004’ from **Teams**, then choose the correct sequence of SQL query shown below, to be executed in order to remove the records of Team id ’T004’. a . Delete from Teams where Team_id = ’T004’ b . Delete from Players where Team_id = ’T004’ c . Delete from Points_table where Team_id = ’T004’ Choose the correct option(s)
A.
a → b → c
B.
b → a → c
C.
b → c → a
D.
c → a → b

A published solution is not available for this question yet.

Report a correction for Q274

Question 275 MCQ · 1.0 marks

Consider the relational schema as shown in figure 1 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
      **Business Analytics** **Section Id :** 64065329426 **Section Number :** 10 **Section type :** Online **Mandatory or Optional :** Mandatory **Number of Questions :** 20 **Number of Questions to be attempted :** 20 **Section Marks :** 50 **Display Number Panel :** Yes **Group All Questions :** No

A published solution is not available for this question yet.

Report a correction for Q275