GATE 2021 · Set-2
Suppose the following functional dependencies hold on a relation U with attributes P, Q, R, S, and T:
P → QR
RS → T
Which of the following functional dependencies can be inferred from the above functional dependencies?
Related Database Management PYQs
Suppose a database system crashes again while recovering from a previous crash. Assume checkpointing is not done by the database e…
The following relation records the age of 500 employees of a company, where empNo (indicating the employee number) is the key: emp…
Let ri(z) and wi(z) denote read and write operations respectively on a data item z by a transaction Ti. Consider the following two…
Consider the relation R(P,Q,S,T,X,Y,Z,W) with the following functional dependencies. PQ → X; P → YX; Q → Y; Y → ZW Consider the de…
Consider the following statements S1 and S2 about the relational data model: S1: A relation scheme can have at most one foreign ke…
A data file consisting of 1,50,000 student-records is stored on a hard disk with block size of 4096 bytes. The data file is sorted…
Free account benefits
Turn practice into measurable progress
Public PYQs and reference pages stay free. Sign in when you want GATEverse to remember what you studied and guide what to practise next.
Saved progressKeep answers, mock results and completion history across devices.
Adaptive practiceGet questions matched to your recent accuracy and difficulty level.
Bookmarks and notesBuild a personal revision list and record why a question was difficult.
Performance insightsSee weak subjects, accuracy trends, streaks and exam readiness.