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
- 14578 Views
- Zycus Infotech, I also Faced
- E-Mail Answers
Answer Posted / r
Sorry ...frgot explain why it is 2nd option....everyone
explained it right ..but the answer choosen is incorrect...
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Why is abstraction used?
What is a class in oop?
What is overloading in oops?
Can main method override?
What is polymorphism and types?
What is polymorphism used for?
What is difference between polymorphism and inheritance?
What is a null tree?
Why is there no multiple inheritance?
What does <> mean pseudocode?
What is the difference between procedural programming and oops?
Question In a class, there is a reference or pointer of an object of another class embedded, and the memory is either allocated or assigned to the new object created for this class. In the constructor, parameters are passed to initialize the data members and the embedded object reference to get inialized. What measures or design change should be advised for proper destruction and avioding memory leaks, getting pointers dangling for the embedded object memory allocation? Please suggest. Question Submitted By :: Sunil Kumar I also faced this Question!! Rank Answer Posted By Re: In a class, there is a reference or pointer of an object of another class embedded, and the memory is either allocated or assigned to the new object created for this class. In the constructor, parameters are passed to initialize the data members and the embedded object reference to get inialized. What measures or design change should be advised for proper destruction and avioding memory leaks, getting pointers dangling for the embedded object memory allocation? Please suggest. Answer # 1 use copy constructors 0 Shanthila There is something to be taken care in destructor, in copy constructor, suppose the memory is assigned to the embedded member object pointer with the parameter passed value, but if some other objects of different class also are pointing to this memory, then if some one deletes the object then this class member pointer object will become dangling, or if the object is not deleted properly then there will be memory leak. Please suggest the design change required to handle or avoid this situation
What is the difference between a constructor and a destructor?
can we make game by using c
how to get the oracle certification? send me the answer
