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

DB2 Interview Questions

Questions Answers Views Company eMail

What is the maximum size of a char data type in db2?

965

What is cursor stability in db2?

1279

What are the various data types available in db2?

1014

Which component is used to execute the sql statements?

1055

What are the rules for db2 programming?

1043

Define db2 and its databases?

1006

How can you quickly find out the # of rows updated after an update statement?

987

Can there be more than one cursor open for any program?

1125

What are the 2 sqlcodes that are returned?

1131

Where do you specify them?

1167

When the like statement is used?

1156

How to retrieve rows from a db2 table in embedded sql?

1328

Are views updateable?

1070

What is reorg?

1072

How can you find out the # of rows updated after an update statement?

1053

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the use of dclgen in db2?

1015

What is database manager in db2?

968

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

Explain in detail about buffer manager and its functionalities?

996

How to connect to db2 database from windows command line?

1003

How will you return the number of records in table?

882

How do you concatenate the firstname and lastname from emp table to give a complete name?

1016

How do I import a csv file into db2?

938

When do you specify the isolation level?

974

What is load utility in db2?

1132

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

1068

When the like statement is used?

1156

What is a plan and package in db2?

1048

Define db2 and its databases?

1006

Describe major components of db2?

1044

For More Un-Answered { DB2 } Questions Click Here