DB2 Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB2 Interview Questions

Questions Answers Views Company eMail

How can you find out which query is taking lot of time to execute in cobol-db2 program ?

Danske,

1 3587

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

RBS,

1 2594

How to fetch the last row from the table in SQL (db2)?

1590

What's The Percentage Free Space ?

IBM,

1163

What's The Error Code For Unique Index Voilation?

IBM,

1155

What is a Foreign Key?

Tavant Technologies, Zensar,

1043

what is a corelated subquerry?

IBM,

1068

can all users have the privilage to use the sql statement select * (dml)?

IBM,

1108

What is the maximum number of columns in a db2 table?

IBM,

1216

B37 abend during spufi?

IBM,

1408

What is the maximum No of rows per page?

IBM,

1015

Which are the db2 tools to protect integrity of the database?

IBM,

1075

How to rename a table in DB2 ?

MCN Solutions,

1034

Is it possible to create an Instance in DB2 using DB2 Control Center ?

MCN Solutions,

1046

What is the difference between dbm cfg and db cfg file in db2 ?

MCN Solutions,

1481

Post New DB2 Questions

Un-Answered Questions { DB2 }

what is the responsibility of the construction superintendent

2086

What is sqlca?

1002

What is the role of union all and union

1075

How is the value function used?

1084

What is a Foreign Key?

1043

What are types of indexes?

1002

How will you return the number of records in table?

884

What is the maximum size of varchar data type in db2?

1073

On which levels locks can be applied?

1066

What is a trigger in the db2 database?

1021

What is data manager?

998

Are views updateable?

1075

What is rct?

1175

Explain the contention situations caused by locks?

1017

How do you stop a db2 database in linux?

962

For More Un-Answered { DB2 } Questions Click Here