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

wht steps we need will coding cobol and db2 pgm ?

6 Answers   CGI,


what is the input to PLAN? what is the input to DBRM?

4 Answers  


Is ibm db2 free?

1 Answers  


What is Skeleton cursor table (SKCT)?

2 Answers  


suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ?

5 Answers   IBM,


what is sql abend code -801,-802?

2 Answers  


What are the functions of Bind?

2 Answers   Amdocs, IBM,


What is correlation names?

1 Answers  


What are the 4 environments which can access DB2 ?

2 Answers  


quary for 1> fetch last record 2> fetch in reverse order 3> fetch last 5 row 4> fetch second last record (their is no primary key) i think concept of count can be use for this in 4th

5 Answers  


how to take the back up of the DB2 table.

7 Answers  


What is catalog database in db2?

1 Answers  


Categories