Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11961 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / ratheesh nellikkal
Hi All,
Here u already have a unique index defined on ACC.NO and ACC.NAME feilds.
Unique index will not allow more than one value for this particular field (Correct me if I am wrong).
Then hw can we get more that one a/c no for a person in this scenario ?
So the answer will be, u can not store more than one a/c number for a person since u have a unique indexes on these table.
Regards,
Ratheesh Nellikal
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is an instance in db2?
Is ibm db2 free?
How is the value function used?
What does a deadlock mean in DB2?
What does reorg do in db2?
What is check constraint. Explain with example.
Which components manage deadlocks in db2?
How to get the ddl of a table in db2?
What is plan in cobol db2?
What does db2 stand for?
What is the difference between plan and package in db2?
Which isolation level provides maximum concurrency?
What is ibm db2 client?
Explain packages.
What is declare cursor?
