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 keyword does an SQL SELECT statement use for a string search?

2 Answers  


What is an asychronous write?

1 Answers  


how to unload different table data into different gdg files/ vsam files.

3 Answers  


What is a page in db2?

0 Answers  


How to test SQL -911 error while developing COB-DB2 program

1 Answers   Satyam,






What is a LIKE table and how is it created?

2 Answers  


what is the soft code for deadlock ?

2 Answers   Logica CMG,


How many databases are there?

0 Answers  


When will you chose to run RUNSTATS?

1 Answers  


What is sqlca’s maximum length?

0 Answers  


OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

1 Answers   Syntel,


pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,


Categories