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

DB2 Interview Questions

Questions Answers Views Company eMail

What is null indicator in db2?

1054

What is package in db2 mainframe?

923

What is page size in db2?

906

What is the difference between bind and rebind in db2?

1396

How will you return the number of records in table?

882

What is performance tuning db2?

1010

What is precompiler in db2?

960

What is rebind in db2?

1001

What is cursor in dbms?

1008

Which command is used to remove all rows from a table?

1040

What is a cursor in programming?

1016

What is the difference between drop table and delete table?

1121

What is the difference between using bind () and rebind () methods of naming class?

1331

What is the difference between plan and package in db2?

1039

How to create backup table in db2?

1044

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is check constraint. Explain with example.

1047

What is release/acquire in bind?

1059

How will you return the number of records in table?

882

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

1590

What is a buffer in memory?

1008

What is ibm db2 connect?

932

Explain about cursor stability?

985

What is the result of open cursor statement?

1030

What are the full forms of spufi and dclgen and why are they used?

1025

What do you mean by between and in? Is between inclusive of specified range values?

1041

What are the prerogatives?

1015

What do you mean by commit and rollback?

976

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

2340

How does a cursor work?

931

How to connect to db2 database from windows command line?

1003

For More Un-Answered { DB2 } Questions Click Here