What is index in db2?



What is index in db2?..

Answer / harika

Db2 Index. Indexes are the database objects created based on one or more columns of a table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is a recovery log?

1 Answers  


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

0 Answers  


how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,


Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,


When is the results table for the query in a DECLARE CURSOR statement created?

5 Answers  






Bind concepts in DB2 cobol

10 Answers   IBM, TCS, TRD, Virtusa,


Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,


What is package versioning? Please give an example.

1 Answers  


How to resolve -805 error in DB2?

1 Answers   Cap Gemini,


What is an alias?

3 Answers  


before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

0 Answers   IBM,


select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,


Categories