The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
+2 votes

Question-65:Full Length Test:Part-1

asked in Databases by Active (2.1k points) | 90 views

2 Answers

+1 vote
Here ans will be (c)1

inner query first executed i.e. select manager from emp ; and this fetches 2,3,4

Now, outer query will be executed and the rows of eno.=2 or 3 or 4 will not be prined

So, it only prints

eno           ename            manager

  1                 a                         2
answered by Veteran (91.9k points)
edited by

According to ans key : 

Solution to question-65:Full Length Test:Part-1

is It correct!!!

I don't think that key is correct. You can try on a DBMS..
yes, I think NULL cannot make any change here.
0 votes
ans d is correct....whenever not in operator compare with null value condition become no row is selected...
answered by (99 points)

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true

38,102 questions
45,600 answers
49,188 users