In the context of DBMS, consider the two sets T and S given below.
| List I | List II |
|---|---|
| I. Logical schema | L. Views |
| II. Physical schema | M. File organization and indexes |
| III. External schema | N. Relations |
Which one of the following is the correct match from T to S ?
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 two relations R(P,Q) and S(X,Y). Let E = {<u> | there ∃ v, there ∃ w, <u,v> in R and <v…
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…
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.