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
- 18017 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the renewal class?
What is overloading and its types?
What is polymorphism what is it for and how is it used?
Describe these concepts: Polymorphism, Inheritance and Abstraction.
What is the difference between a constructor and a destructor?
What is abstraction example?
What is advantage of inheritance?
Why is polymorphism important in oop?
What are the components of marker interface?
Which language is not a true object oriented programming language?
Plese get me a perfect C++ program for railway/airway reservation with all details.
Whats oop mean?
Is data hiding and abstraction same?
Question: Implement a base class Appointment and derived classes Onetime, Daily, Weekly, and Monthly. An appointment has a description (for example, “see the dentist”) and a date and time. Write a virtual function occurs_on(int year, int month, int day) that checks whether the appointment occurs on that date. For example, for a monthly appointment, you must check whether the day of the month matches. Then fill a vector of Appointment* with a mixture of appointments. Have the user enter a date and print out all appointments that happen on that date.
What is abstraction with example?
