October 3, 2023Database-Management-SystemQuestion 106 The order of an internal node in a B+ tree index is the maximum number of children it can have. Suppose that a child […]
October 4, 2023Database-Management-SystemQuestion 94 The order of a leaf node in a B+– tree is the maximum number of (value, data record pointer) pairs it can hold. Given that […]
October 4, 2023TransactionsQuestion 6 Which of the following scenarios may lead to an irrecoverable error in a database system? A A transaction writes a data item after it […]
October 4, 2023NormalizationQuestion 12 Relation R with an associated set of functional dependencies, F, is decomposed into BCNF. The redundancy (arising out of functional dependencies) in the resulting […]