Let \(R(A,B,C,D,E)\) be a relational schema with functional dependency set \(F = \{A \rightarrow BC,\ CD \rightarrow E,\ E \righta…
Consider that the visualization of a 3-dimensional data cube is showing Sales Quantity for each combination of the attributes Prod…
Consider two relations \(r\) and \(s\) defined on the relational schemas \(R(A,B)\) and \(S(E,C)\), respectively. \(A\) is the pri…
In a relational database, a B+ Tree Index is to be constructed for a relation on a key field. In a B+ Tree, a Node Pointer points …
Consider a B+ Tree where the maximum number of key values in each leaf node is 2 and the maximum number of pointers in each non-le…
Consider the given relations \(X\), \(Y\) and \(Z\). The relation \(X\) has three columns P, Q and R. The relation \(Y\) has three…
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.