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
17656 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 debug class?what is trace class? What differences are between them? With examples.

2187

What is abstract class in oop?

1002

What are different oops concepts?

1057

What is the problem with multiple inheritance?

1160

What is the significance of classes in oop?

1143

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?

2202

String = "C++ is an object oriented programming language.An imp feature of oops is classes and objects".Write a pgm to count the repeated words from this scenario?

2386

What is abstraction oop?

1080

What language is oop?

1007

Are polymorphisms mutations?

1155

write a program that takes input in digits and display the result in words from 1 to 1000

2413

Can an interface inherit a class?

1055

Why is there no multiple inheritance?

997

What is object in oops?

1055

What is oops in simple words?

1083