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
- 11840 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
Give the name of some fields form sqlca.
What's The Error Code For Unique Index Voilation?
What is the advantage in De-normalizing tables in DB2?
Explain dclgen.
What is dclgen (declaration generator)?
What are db2 objects?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
Define db2 and its databases?
What do you mean by storage group (stogroup)?
What is db2 stogroup?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
Explain about rct.
How many databases are there?
Highlight all the advantages that are attached to a package.
What is null in db2?
