GATEverse
← GATE CSE 2012

Q51

MCQ2 marks, −0.67

Consider the following relations A,BA, B and C:C:

IdNameAge12Arun6015Shreya2499Rohit11AIdNameAge15Shreya2425Hari4098Rohit2099Rohit11BIdPhoneArea1022000299210001C\overset{\textbf{A}}{\begin{array}{|c|c|c|}\hline\\ \textbf{Id}& \textbf{Name}& \textbf{Age} \\\hline 12& \text{Arun}& 60 \\ \hline 15& \text{Shreya}& 24 \\ \hline 99& \text{Rohit}& 11 \\\hline \end{array}}\qquad \overset{\textbf{B}}{\begin{array}{|c|c|c|}\hline\\ \textbf{Id}& \textbf{Name}& \textbf{Age} \\\hline 15& \text{Shreya}& 24 \\ \hline 25 & \text{Hari} & 40 \\ \hline 98 & \text{Rohit} & 20 \\ \hline 99& \text{Rohit}& 11 \\\hline \end{array}}\qquad \overset{\textbf{C}}{\begin{array}{|c|c|c|}\hline\\ \textbf{Id}& \textbf{Phone}& \textbf{Area} \\\hline 10& 2200& 02 \\ \hline 99& 2100& 01\\ \hline \end{array}}

How many tuples does the result of the following SQL query contain? SELECT A.Id FROM A WHERE A.Age > ALL (SELECT B.Age FROM B WHERE B.Name = ‘Arun’)

Sign in to save attempts.

Loading…