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?
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.
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.
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.
Answer the subquestions on the basis of the given data.
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.