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.
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
Mention the downsides of page level lock.
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
How can record locking be achieved in those DB2 versions which do not support it?
What is ibm db2 database?
What is a db2 tablespace?
What is dclgen (declaration generator)?
What is the difference between nvl and coalesce?
How can the duplicate values be eliminated from db2 select?
Mention the different locking levels that are available in db2.
How to find the maximum value in a column in the db2 database?
What is database alias db2?
What is a db2 schema?
What is catalog database in db2?
What is cloudant database?