Let the set of functional dependencies F = { QR -> S, R -> P, S -> Q } hold on relation schema X(P, Q, R, S). X is not in BCNF. Su…
Consider relations P(X, Y, Z), Q(X, Y, T) and R(Y, V) with instances given. How many tuples will be returned by the following rela…
Consider the following two statements about database transaction schedules: 1. Strict two-phase locking protocol generates conflic…
Which one of the following statements is NOT correct about the B+ tree data structure used for creating an index of a relational d…
Let P, Q, R and S be the attributes of a relation in a relational schema. Let X → Y indicate functional dependency in the context …
In the context of relational database normalization, which of the following statements is/are true?
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.