Which one of the following is used to represent the supporting many-one relationships of a weak entity set in an entity-relationsh…
Consider a relational table R that is in 3NF, but not in BCNF. Which one of the following statements is TRUE?
Consider a database implemented using B+ tree for file indexing on disk with block size 4 KB. Search key is 12 bytes and tree/disk…
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…
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.