MauryaHub PYQ Practice

Database Management System · End Term · May 2024 · AN

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

Question 205 MCQ · 2.0 marks

Which hypothesis test should the researcher use to compare the effectiveness of the two teaching methods?
A.
One-sample t-test
B.
Two-sample t-test
C.
Two-sample z-test
D.
One-sample z-test
E.
Chi-squared test
F.
F test

A published solution is not available for this question yet.

Report a correction for Q205

Question 206 NAT · 3.0 marks

If the P-value of the test is 0.05, find the value of n. Round off your answer to the next greatest integer.

A published solution is not available for this question yet.

Report a correction for Q206

Question 208 MCQ · 2.0 marks

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

A published solution is not available for this question yet.

Report a correction for Q208

Question 209 MCQ · 2.0 marks

Source diagram or notation
A.
75000
B.
250
C.
300
D.
50

A published solution is not available for this question yet.

Report a correction for Q209

Question 210 MCQ · 2.0 marks

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

A published solution is not available for this question yet.

Report a correction for Q210

Question 211 MCQ · 2.0 marks

Given below are four statements. Match each of them with the corresponding property in the set of ACID properties. Statement 1 : Any data written to the database must be valid according to all the defined rules like the check and key constraints and triggers. Statement 2 : Every completed transaction is saved into the secondary storage. Statement 3 : During money transfer, either the amount debited from the source account must be credited to the destination account or the money should not be debited from the source account at all. Statement 4 : If multiple transactions are being executed concurrently, then the final result should be the same irrespective of the sequence in which the transactions were executed. Let A denote Atomicity, C denote Consistency, I denote Isolation and D denote Durability. From among the given options, find the correct match.
A.
1 - A, 2 - C, 3 - I, 4 - D
B.
1 - C, 2 - D, 3 - A, 4 - I
C.
1 - C, 2 - D, 3 - I, 4 - A
D.
1 - A, 2 - I, 3 - D, 4 - C

A published solution is not available for this question yet.

Report a correction for Q211

Question 212 MCQ · 2.0 marks

Source diagram or notation
A.
00101101 AND 10000010
B.
00101101 OR 00110100
C.
11010010 AND 10000010
D.
11010010 OR 00110100

A published solution is not available for this question yet.

Report a correction for Q212

Question 213 MCQ · 3.0 marks

Source diagram or notation
A.
21, 26, 31, 16
B.
21, 31, 26, 16
C.
16, 21, 26, 31
D.
21, 26, 16, 31

A published solution is not available for this question yet.

Report a correction for Q213

Question 214 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 Q214

Question 215 MCQ · 3.0 marks

Source diagram or notation
A.
A = 100, B = 400, C = 1000, D = 700
B.
A = 100, B = 300, C = 1000, D = 700
C.
A = 200, B = 300, C = 1000, D = 700
D.
A= 200, B = 400, C = 500, D = 800

A published solution is not available for this question yet.

Report a correction for Q215

Question 216 MCQ · 3.0 marks

The following key values are inserted into a B\(^{+}\) tree of order 4 in a given sequence. The tree is initially empty. **25,8,13,59,3,31,60,11,43** Which of the following values appear only once in the tree?
A.
59
B.
25
C.
60
D.
11

A published solution is not available for this question yet.

Report a correction for Q216

Question 217 MSQ · 3.0 marks

Source diagram or notation
A.
The decomposition **R1, R2, R3** are in 3NF but all the dependencies are not getting preserved.
B.
The decomposition **R1, R2, R3** are in BCNF.
C.
In the decomposition, **R1** and **R2** are in BCNF and **R3** is in 3NF.
D.
In the decomposition, **R2** is not required. As **R1** and **R3** is sufficient decomposition in 3NF but all the dependencies will not get preserved.

A published solution is not available for this question yet.

Report a correction for Q217

Question 218 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 Q218

Question 219 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 Q219

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

Question 221 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 Q221

Question 222 MSQ · 3.0 marks

Source diagram or notation
A.
Schedule **S** can not be two-phase lockable.
B.
Schedule **S** can be two-phase lockable.
C.
Schedule **S** can be strict two-phase lockable.
D.
Schedule **S** is conflict serializable.

A published solution is not available for this question yet.

Report a correction for Q222

Question 223 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 Q223

Question 224 MSQ · 2.0 marks

Source diagram or notation
A.
Schedule **S** is Conflict serializable
B.
Schedule **S** is View serializable
C.
Schedule **S** is not Conflict Serializable
D.
Schedule **S** is not View Serializable

A published solution is not available for this question yet.

Report a correction for Q224

Question 225 MSQ · 1.0 marks

Choose the correct statement(s):
A.
In an ordered index, index entries are stored sorted on the search key value
B.
Primary index is also called clustering index
C.
Secondary index is an index whose search key specifies an order different from the sequential order of the file
D.
An index-sequential file is an unordered file

A published solution is not available for this question yet.

Report a correction for Q225

Question 226 NAT · 2.0 marks

The following numbers are inserted into an empty binary search tree in the given order: 27, 43, 33, 49, 81, 92, 73, 10, 78. What is the height of the resulting binary search tree?

A published solution is not available for this question yet.

Report a correction for Q226

Question 227 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: • Total number of block transfers: 30500 • Total number of seeks required: 2000 • Number of block in the outer relation: 500 What is the number of blocks in the inner relations?

A published solution is not available for this question yet.

Report a correction for Q227