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…
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…
Consider the concept hierarchies as shown in the figure. Which of the following options denotes the total number of possible data…
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.