if suppose i am having an ACCOUNT table with 3 coloumns ACC.
NO,ACC. NAME,ACC. AMOUNT . If a unique index is also
defined on ACC.NO and ACC.NAME then write a query to
retrieve account holders records who have more than 1 ACC.
- 8 Answers
- 9906 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / s
For this scenario duplicate records will not exist in the
table as the index has been defined on the 2 primary keys.
Hence the answer is we can't pull the account holders
having more than 1 account
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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 plan in cobol db2?
Mention the location where the output received from explain statement is stored.
How do we specify index to include or not during bind process.
What is a db2 tablespace?
Explain the contention situations caused by locks?
What os does db2 run on?
List out the data types available.
What is drop table?
What is meant by explain?
List out the buffer pools in db2
Define sqlca.
What is dbrm? What it contains? When it will be created?
How do I connect my db2 database to ibm?
Are views updateable?
