GATE 1994
April 18, 2024Sorting
April 18, 2024Database-Management-System
|
Question 278
|
Consider the above tables A, B and C. How many tuples does the result of the following SQL query contains?
SELECT A.id
FROM A
WHERE A.age > ALL (SELECT B.age
FROM B
WHERE B.name – “Arun”)
|
3
|
|
|
0
|
|
|
1
|
|
|
4
|
Question 278 Explanation:
All condition with empty return true
Also the result of subquery is empty So all id of A will be selected.
Correct Answer: A
Question 278 Explanation:
All condition with empty return true
Also the result of subquery is empty So all id of A will be selected.