GATE CSE 1990 | Question: 2-iv

Question

Match the pairs in the following questions:$$\begin{array}{|ll|ll|}\hline (a) & \text{Secondary index} & (p) & \text{Function dependency} \\\hline  (b) & \text{Non-procedural query language} & (q) & \text{B-tree} \\\hline   (c) & \text{Closure of a set of attributes} & (r)  & \text{Domain calculus} \\\hline (d) & \text{Natural join} & (s)  & \text{Relational algebraic operations}  \\\hline \end{array}$$

Answer 1

Secondary index $\Rightarrow$  B-tree

Non-procedural query language $\Rightarrow$  Domain calculus

Closure of a set of attributes $\Rightarrow$  Function dependency

Natural join $\Rightarrow$  Relational algebraic operations

$$\begin{array}{|ll|ll|}\hline (a) & \text{Secondary index} & (q) & \text{B-tree} \\\hline  (b) & \text{Non-procedural query language} & (r) & \text{Domain calculus} \\\hline   (c) & \text{Closure of a set of attributes} & (p)  & \text{Function dependency} \\\hline (d) & \text{Natural join} & (s)  & \text{Relational algebraic operations}  \\\hline \end{array}$$

Answer 2

a-q

b-r

c-p

d-s