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…
A relational database contains tables Student(Roll_no, Student_name) with 5 students and Performance(Roll_no, Subject_code, Marks)…
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…
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.