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
- 17650 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is encapsulation process?
What is multilevel inheritance?
What are the 4 pillars of oop?
i=20;k=0;
for(j=1;k-i;k+=j<10?4:3)
{
cout< There are two base class B1,B2 and there is one class D
which is derived from both classes,
Explain the flow of calling constructors and destructors
when an object of derived class is instantiated. How to improve object oriented design skills? What is difference between multiple inheritance and multilevel inheritance? What is new keyword in oops? What is the real time example of inheritance? Templates mean What is the use of oops? Why is polymorphism important in oop? What is overriding vs overloading? What is the significance of classes in oop? Is data hiding and abstraction same?
