Register
Filter

Questions by Bikram

2 votes
1 answer
10
Test by Bikram | Databases | Test 2 | Question: 21
Consider the following transaction involving two bank accounts $A$ and $B$ ... $A$ and $B$ should remain constant is that of: Atomicity Consistency Isolation Durability
Consider the following transaction involving two bank accounts $A$ and $B$.$\begin{array}{|l|} \hline \text{read(A);} \\ \hline A:=A-250; \\ \hline \text{write(A);} \\ \...
1 votes
1 answer
11
Test by Bikram | Databases | Test 2 | Question: 20
Assume that a B-Tree is used as an index for a large database table which has six levels (including the root node). If a new key is inserted into this index, then the maximum number of levels possible in the updated tree is ______.
Assume that a B-Tree is used as an index for a large database table which has six levels (including the root node). If a new key is inserted into this index, then the max...
1 votes
1 answer
12
Test by Bikram | Databases | Test 2 | Question: 19
A schedule with two transactions T1 and T2 is as mentioned below: ... The above schedule is an example of: Cascade-less schedule Recoverable schedule Both Cascade-less and Recoverable schedule Irrecoverable schedule
A schedule with two transactions T1 and T2 is as mentioned below:$\begin{array}{|c|c|} \hline T1 & T2 \\ \hline \text{read(A)} & {} \\ \hline \text{write(A)} & {} \\ \hl...
2 votes
1 answer
13
Test by Bikram | Databases | Test 2 | Question: 18
The above ER diagram depicts a book rental scheme. If this ER diagram is mapped to a relational model, to correctly depict this above scenario, the total number of relations required will be _________.
The above ER diagram depicts a book rental scheme.If this ER diagram is mapped to a relational model, to correctly depict this above scenario, the total number of relatio...
3 votes
2 answers
15
Test by Bikram | Databases | Test 2 | Question: 16
$\sigma_{A=B \text{ and } B=C \text{ and } C=A} \bigg( \Pi_A (R) \times \Pi_B (R) \times \Pi_C (R) \bigg)$ The number of rows returned by the above relational algebraic expression is ________.
$\sigma_{A=B \text{ and } B=C \text{ and } C=A} \bigg( \Pi_A (R) \times \Pi_B (R) \times \Pi_C (R) \bigg)$The number of rows returned by the above relational algebraic ex...
3 votes
1 answer
16
Test by Bikram | Databases | Test 2 | Question: 15
What is the number of rows returned by an SQL query on the below EMP table? ... EMP where manager IN (NULL, NULL,NULL); It will throw an error. Three rows are selected. No rows are selected. One row is selected.
What is the number of rows returned by an SQL query on the below EMP table?$\begin{array}{|c|c|c|} \hline \text{eno} & \text{ename} & \text{manager} \\ \hline 1 & A & \te...
Page: