Final Answer is 'Option 2' . Read option 2 and 3 carefully, u

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 / girish

10 Answers
18019 Views
Zycus Infotech, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between abstraction and polymorphism?

1158

What is Difeerence between List obj=new ArrayList(); and ArrayList obj=new ArrayList()?

2596

Why multiple inheritance is not possible?

1122

What is pointer in oop?

1125

I have One image (means a group photo ) how to split the faces only from the image?............ please send the answer nagadurgaraju@gmail.com thanks in advace...

2175

Why do we use oops?

1071

What is a function in oop?

1139

What is the main purpose of inheritance law?

1251

What are the 4 pillars of oop?

1206

what type of questions

2177

What is encapsulation in simple terms?

1099

Can abstract class have normal methods?

1108

Whats is abstraction in oops?

1143

which feature are not hold visual basic of oop?

2237

What is overloading in oop?

1050