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
- 11599 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 the use of db2?
Which command is used to remove all rows from a table?
What is difference between alias and synonym in db2?
Before you give the explain statement, what are the prerogatives?
what is db2 restart?
What are types of indexes?
What is the clustering index in the db2 database?
Define check constraint.
What is runstats db2?
What is with ur in db2?
List down the types of triggers in the db2 database?
What is buffer pool?
What do you mean by cursor?
How is a typical db2 batch pgm executed?
What is database manager in db2?
