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
- 12154 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 picture clause of null indicator variable?
Give the name of some fields form sqlca.
Explain in detail about buffer manager and its functionalities?
Which isolation level provides highest data integrity?
How to find schema of a table in db2?
What is scrollable cursor in db2?
What is difference between rollback and commit?
Is schema the same as database?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is cursor with hold option in db2?
What is page size in db2?
What is the use of commit in db2?
What is dclgen in db2?
What does runstats do in db2?
