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
- 17712 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 does and I oop mean?
given a set based questions and 5 questions based on it next data sufficiciency questions 2 and 2/3 english sentence completion with options very easy and 2 synononmys paragraph with 10 questions 10 minutes replace =,-,*,% with -,%,+,* type questions 5 3 questions lik following itssickhere itssickthere itssickhere istsickhere which is nt alike the others very easy
Is react oop?
Why is polymorphism important in oop?
What is constructor overloading in oop?
What do you mean by overloading?
How do you achieve polymorphism?
How does polymorphism work?
What is an interface in oop?
What is abstraction encapsulation?
what is difference between class template and template class?
Can we define a class within the interface?
Which type does string inherit from?
Whats is abstraction in oops?
Objective The objective of this problem is to test the understanding of Object-Oriented Programming (OOP) concepts, in particular, on encapsulation. Problem Description Create a program for managing customer’s bank accounts. A bank customer can do the following operations: 1. Create a new bank account with an initial balance. 2. Deposit money into his/her account. 3. Withdraw money from his/her account. For this operation, you need to output “Transaction successful” if the intended amount of money can be withdrawn, otherwise output “Transaction unsuccessful” and no money will be withdrawn from his/her account. Input The input contains several operations and is terminated by “0”. The operations will be “Create name amount”, “Deposit name amount”, or “Withdraw name amount”, where name is the customer’s name and amount is an integer indicating the amount of money. There will be at most 100 bank accounts and they are all created on the first month when the bank is opening. You may assume that all account holders have unique names and the names consist of only a single word. Output The output contains the transaction result of withdrawal operations and the final balance of all customers after some withdrawal and deposit operations (same order as the input). Sample Input Create Billy 2500 Create Charlie 1000 Create John 100 Withdraw Charlie 500 Deposit John 899 Withdraw Charlie 1000 0
