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 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.