Interested to Buy Any Domain ? << Click Here >> for more details...
You attempt to query the data base with this command:
SELECT name, salary FROM employee WHERE salary=(SELECT
salary FROM employee WHERE last name='Wagner' OR dept no=233)
Choose most appropriate option from the following:
1)Sub-queries are not allowed in the where clause.
2)a multiple row sub-query used with a single row comparison
operator.
3)a single row query is used with a multiple row comparison
operator.
- 10 Answers
- 17680 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
In my knowlenge if i run this query,the subquery is likely
to return more than single rows as resultset as OR condition
is used so 3rd option is likely to be occured.
| Is This Answer Correct ? | 26 Yes | 4 No |
Answer / nitin
option b is correct because we can not compare more than one values with single value using '=' operator.
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / raghavan
Actually the query may return more than one row.
Hence "is" should be used in place of "=".
So the best answer would be the third choice.
| Is This Answer Correct ? | 11 Yes | 4 No |
Answer / r
Sorry ...frgot explain why it is 2nd option....everyone
explained it right ..but the answer choosen is incorrect...
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / girish
Final Answer is 'Option 2' . Read option 2 and 3
carefully, u will get to know why 2 is correct.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / dilip
the answer is b becouse the query the query compares one
row at a time and there is multiple rows generated in
subqueries
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / vicky
SELECT name, salary FROM employee WHERE salary=(SELECT
salary FROM employee WHERE last name='Wagner' OR dept
no=233)
Choose most appropriate option from the following:
1)Sub-queries are not allowed in the where clause.
2)a multiple row sub-query used with a single row comparison
operator.
3)a single row query is used with a multiple row comparison
operator.
4)logical aparatous are not allowed in where clause .
| Is This Answer Correct ? | 0 Yes | 2 No |
What is the difference between inheritance and polymorphism?
Program to check whether a word is the first word of the sentence.
why function overloading is not called as pure polymorphism?
What is Method overloading?
Is enum a class?
create a c++ program that will ask 10 numbers and display their sum using array.
What is difference between oop and pop?
What exactly is polymorphism?
Can we define a class within the interface?
how do you handle yourself when you feel the wald is aganist you
What is ambiguity in inheritance?
WRITE A SIMPLE C++ PROGRAM TO SWAP TWO NOS WITHOUT USING TEMP
STL 
