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?
Consider a relational database schema with a relation R(A,B,C,D). If {A,B} and {A,C} are the only two candidate keys of the relati…
In the context of DBMS, consider the two sets T and S given below. T: I: Logical schema, II: Physical schema, III: External schema…
Consider concurrent execution of two transactions T1 and T2 in a DBMS, both of which access a data object A. For these two transac…
In the context of schema normalization in relational DBMS, consider a set F of functional dependencies. The set of all functional …
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.