1. Categories >> Software >> Programming Languages >> C++ >> OOPS
  2. Suggest New Category

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.

Question Posted / recent questions

Answers were Sorted based on User's Feedback



You attempt to query the data base with this command: SELECT name, salary FROM employee WHERE salar..

Answer / sharmaamitanand

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

You attempt to query the data base with this command: SELECT name, salary FROM employee WHERE salar..

Answer / r

option b is correct...

Is This Answer Correct ?    11 Yes 2 No

You attempt to query the data base with this command: SELECT name, salary FROM employee WHERE salar..

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

You attempt to query the data base with this command: SELECT name, salary FROM employee WHERE salar..

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

You attempt to query the data base with this command: SELECT name, salary FROM employee WHERE salar..

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

You attempt to query the data base with this command: SELECT name, salary FROM employee WHERE salar..

Answer / rupali

Option 2 is correct.

Is This Answer Correct ?    3 Yes 0 No

You attempt to query the data base with this command: SELECT name, salary FROM employee WHERE salar..

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

You attempt to query the data base with this command: SELECT name, salary FROM employee WHERE salar..

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

You attempt to query the data base with this command: SELECT name, salary FROM employee WHERE salar..

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

You attempt to query the data base with this command: SELECT name, salary FROM employee WHERE salar..

Answer / manish

Option 3 is right

Is This Answer Correct ?    3 Yes 7 No

Post New Answer

More OOPS Interview Questions

What is for loop and its syntax?

0 Answers  

What is difference between multiple inheritance and multilevel inheritance?

0 Answers  

What is abstraction encapsulation?

0 Answers  

What is difference between new and malloc?

7 Answers   emc2,

What is oops concept with example?

0 Answers  




Can static class have constructor?

0 Answers  

What is design patterns in C++?

2 Answers   Persistent,

what is difference between objects and function

1 Answers  

What is destructor give example?

0 Answers  

pointers are support in C#? if yes then how to use it?

8 Answers   Softvision Solution,

Write a program to sort the number with different sorts in one program ??

0 Answers   NIIT,

How is polymorphism achieved?

0 Answers  

For more OOPS Interview Questions Click Here
Categories