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

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,


When Can you be sure that a query will return only one row?

4 Answers   IBM,


my project is insurance management system,how to explain my work environment in interview?

2 Answers   CGI, Value Labs,


Explain dclgen.

0 Answers  


What is runstats and reorg in db2?

0 Answers  






What is the advantage in De-normalizing tables in DB2?

0 Answers  


What is explain plan in db2?

0 Answers  


What is the FREE command?

1 Answers  


Is db2 a mainframe database?

0 Answers  


What is dbrm? What it contains?

0 Answers  


What is a collection in db2?

0 Answers  


How to find primary key of a table in db2?

0 Answers  


Categories