Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
Database Example
Home
>>
Category
>>
Programming Language (MCQ) questions
>>
Database
Q. Consider an SQL query
SELECT A.Id FROM A WHERE A.Age>
All (SELECT B.Age FROM B WHERE B.name = ‘Anay’)
The result of this query contains
- Published on 25 Aug 15
a.
1 tuple
b.
2 tuples
c.
3 tuples
d.
4 tuples
ANSWER: 3 tuples
Related Content
Networking (
207
)
Database (
97
)
C programming (
58
)
Software Engineering (
28
)
SQL (
5
)
HTML (
74
)
Web Technologies (
11
)
Data Structure (
140
)
Operating System (
96
)
Java (
25
)
Oracle (
5
)
C++ (
50
)
Algorithms (
7
)
PL/SQL (
13
)
JavaScript (
7
)
XML (
0
)
CSS (
1
)
Discussion
Nirja Shah
-Posted on 05 Nov 15
- The meaning of “ALL” is A.Age which should be greater than all the values returned by the subquery.
- The subquery will return NULL as there is no entry with name “arun” in table B.
- The condition becomes true for all rows of A if a subquery returns NULL.
- So all rows of table A are selected.
➨
Post your comment / Share knowledge
Required!
Required!
Invalid Email Id!
Required!
Enter the code shown above:
Please enter the code shown above
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
MCQs
English
Tutorials
Download
▲