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
- 11644 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
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Define data page.
Is db2 relational database?
What is db2 purescale?
What is the result of open cursor statement?
Is schema the same as database?
What is syscat in db2?
What is the syntax for creating a table in the db2 database?
What is the difference between cursor stability and repeatable read isolation levels?
How do I add a column in db2?
What is db2 and what is the use of db2 optimizer?
What is drop table?
What is db2 plan table?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Can we delete records from view?
