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 universal database?

0 Answers  


How do you prepare a COBOL + DB2 program from coading till execution ?

1 Answers   Amdocs, Xansa,


What is a result table?

1 Answers  


What is meant by repeatable read?

4 Answers  


can any one give the list of some important sql abend codes which r frequently asked in interviews?

2 Answers  






What is a collection?

3 Answers  


What is check constraint. Explain with example.

0 Answers  


What is copy pending and check pending in db2?

0 Answers  


Do we need cursor for Count(*)?

4 Answers   iGate,


What is the cascade rule and how does it relate to deletions made with a subselect?

1 Answers  


What is precompiler in db2?

0 Answers  


What are catalog tables in db2?

0 Answers  


Categories