Where could you look if you had a question about whether a
column has been defined as an index?

Answers were Sorted based on User's Feedback



Where could you look if you had a question about whether a column has been defined as an index?..

Answer / sadiq afroze

This information can be found in SYSIBM.SYSINDEXES

Is This Answer Correct ?    5 Yes 0 No

Where could you look if you had a question about whether a column has been defined as an index?..

Answer / sushmitha

in our company we use Platinum tool.
in platinum for the option 1 - we can see if the column has
been defined as an index.

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is an intent lock?

3 Answers  


What is the use of dclgen in db2?

0 Answers  


What is the maximum No of rows per page?

0 Answers   IBM,


Which isolation level provides highest data integrity?

0 Answers  


How does coalesce work?

0 Answers  






what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........

1 Answers  


What are the contents of a DCLGEN?

4 Answers   MetLife,


In which column of which DB2 catalog would you find the length of the rows for all tables?

2 Answers  


What is meant by dclgen?

0 Answers  


what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx

2 Answers   IBM,


What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 Answers  


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

0 Answers   IBM,


Categories