In a single table,How to retrieve a employee-id of an
employee who works in more than one department?
Answer Posted / vish
Another classic example of people replying to the queries
in hurry..the answer #1, #2, #3, #4 & #7 are WRONG ANSWERS.
Answer #6 is correct. Answer #5 also seems to be correct to
me (unfortunatley I can't run & verify it at the moment,
someone please verify it & let everyone know).
Ram.g, FYI..EXISTS clause just denotes whether query after
EXISTS clause returned any row or not, it NEVER give a
count of the number of rows returned. Here need to find if
there are more than one rows (i.e count is needed) so
EXISTS can't be used here.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the maximum No of rows per page?
Explain packages.
Differentiate between cs and rr isolation levels? Where do you specify them?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Define check constraint.
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What is universal database?
What is ibm db2 database?
How do you pull up a query which was previously saved in qmf?
Are view updateable?
What is an instance in db2?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What do you mean by cursor?
B37 abend during spufi?
What is difference between alias and synonym in db2?