For this scenario duplicate records will not exist in the table as the in

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.

Question Posted / s

8 Answers
11953 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

Please Help Members By Posting Answers For Below Questions

what is db2 restart?

2162

How does a cursor work?

993

What is db2?

1185

What is a db2 package?

1060

How to rename a table in DB2 ?

1088

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1160

What is check constraint. Explain with example.

1110

Are views updateable?

1163

What is page size in db2?

978

What is dclgen (declaration generator)?

1060

How many types of page locks can be held in db2?

1044

Explain db2.

1039

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1062

Is schema the same as database?

1060

What is explain plan in db2?

999