In a B+ tree, the requirement of at least half-full (50%) node occupancy is relaxed for which one of the following cases?
Which of the following statements about a relation R in first normal form (1NF) is/are TRUE?
Consider the following two relations, R(A,B) and S(A,C): R: (10,20), (20,30), (30,40), (30,50), (50,95) S: (10,90), (30,45), (40,8…
The symbol → indicates functional dependency in the context of a relational database. Which of the following options is/are TRUE?
Consider the following read-write schedule S over three transactions T1, T2, and T3, where the subscripts in the schedule indicate…
Once the DBMS informs the user that a transaction has been successfully completed, its effect should persist even if the system cr…
Free account benefits
Public PYQs and reference pages stay free. Sign in when you want GATEverse to remember what you studied and guide what to practise next.