SQL

Common data for Q.50 and Q.51: Consider the following relations A, B and C: $$\textbf{A}: \begin{array}{|c|c|c|} \hline \textbf{Id} & \textbf{Name} & \textbf{Age} \\ \hline 12 & \text{Arun} & 60 \\ 15 & \text{Shreya} & 24 \\ 99 & \text{Rohit} & 11 \\ \hline \end{array} \qquad \textbf{B}: \begin{array}{|c|c|c|} \hline \textbf{Id} & \textbf{Name} & \textbf{Age} \\ \hline 15 & \text{Shreya} & 24 \\ 25 & \text{Hari} & 40 \\ 98 & \text{Rohit} & 20 \\ 99 & \text{Rohit} & 11 \\ \hline \end{array} \qquad \textbf{C}: \begin{array}{|c|c|c|} \hline \textbf{Id} & \textbf{Phone} & \textbf{Area} \\ \hline 10 & 2200 & 02 \\ 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')

Consider a database table T containing two columns X and Y each of type integer. After the creation of the table, one record (X=1, Y=1) is inserted in the table. Let MX and MY denote the respective maximum values of X and Y among all records in the table at any point in time. Using MX and MY, new records are inserted in the table 128 times with X and Y values being MX+1, 2*MY+1 respectively. It may be noted that each time after the insertion, values of MX and MY change. What will be the output of the following SQL query after the steps mentioned above are carried out?

SELECT Y FROM T WHERE X=7;

Database table by name Loan_Records is given below.

Borrower   Bank_Manager   Loan_Amount
Ramesh     Sunderajan     10000.00
Suresh     Ramgopal       5000.00
Mahesh     Sunderajan     7000.00

What is the output of the following SQL query?

SELECT count(*)
FROM (
      (SELECT Borrower, Bank_Manager FROM Loan_Records) AS S
      NATURAL JOIN
      (SELECT Bank_Manager, Loan_Amount FROM Loan_Records) AS T
);