Option 2 is correct.

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

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

Answer Posted / rupali

Option 2 is correct.

Is This Answer Correct ?

3 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is coupling in oop?

970

Can an interface inherit a class?

1016

What is encapsulation oop?

995

What are properties in oop?

1025

What is class and object with example?

1060

Please send ford technologies placement paper 2 my mail id

2057

why reinterpret cast is considered dangerous?

2336

What is the oops and benefits of oops programming?

927

what is graphics

2404

INSTANCE FIELDS DECLARED private ARE ACCESSIBLE BY THE METHODS ONLY.CAN WE CHANGE THE private FIELD OF AN OBJECT IN A METHOD OF SOME OTHER OBJECT OF THE SAME CLASS?

2150

What is this pointer in oop?

1003

2. Give the different notations for the class.\

2086

How Do you Code Composition and Aggregation in C++ ?

25266

write a program to find 2^n+1 ?

2018

What is the real time example of inheritance?

1082