DBMS Rapid Quiz - 2 (App update required to attempt this test)

Assume a schedule having three transaction T1, T2, T3 with 5, 4 and 4 operation respectively. The number of schedules which are concurrent but not serial is_____________.

Consider the following key sequence:

10, 3, 6, 8, 4, 2, 1

Let order of the node be 3 where order of the node denotes the no of pointers in a particular node.

Let Y be the no of times node splitting occurs while insertion is done to the B⁺ tree and X be the no of time node splitting occurs when insertion is made to B tree. What is the magnitude of X-Y?

Consider an Entity-Relationship (ER) model in which entitysets E₁ and E₂ are connected by an m : n relationship R₁₂. E₁ and E₃ are connected by a 1 : n (1 on the side of E₁ and n on the side of E₃) relationship R₁₃.
E₁ has two single-valued attributes a₁₁ and a₁₂ of which a₁₁ is the key attribute. E₂ has two single- valued attributes a₂₁ and a₂₂ of which a₂₁ is the key attribute. E₃ has two single-valued attributes a₃₁ and a₃₂ of which a₃₁ is the key attribute. The relationships do not have any attributes.
If a relational model is derived from the above ER model, then the minimum number of relations that would be generated if all the relations are in 3NF is_________.

Suppose x is a component of some tuple, and the domain for that component of some tuple, and the domain for that component is the integers. If x has the NULL, what is the value of
i. 0 * x
ii. x – x