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.
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.
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.
Consider the relational schema as shown in figure 1 and answer the given subquestions
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.
Consider the relational schema as shown in figure 1 and answer the given subquestions
A.B.C.D.
**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.