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

DB2 Interview Questions

Questions Answers Views Company eMail

What is dbrm? When it will be created?

963

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1033

What is dbrm? What it contains?

1112

What does sqlcabc has?

998

What is the difference between cursor stability and repeatable read isolation levels?

1117

How to execute stored procedures?

1070

What is sqlca?

1002

Are view updateable?

986

How and when does the db2 enforces the unique key?

1032

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1117

What is dbrm? What it contains? When it will be created?

996

What is the difference between spufi and qmf?

1055

What is the max length of sqlca?

1160

What are the bind parameters ibm db2?

992

what are bind concepts in db2 cobol?

1036

Post New DB2 Questions

Un-Answered Questions { DB2 }

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

993

is it compulsory commitment control in journal?

2423

Mention data types used in db2 ?

1109

What is runstats db2?

967

How to compare data between two tables in db2?

1035

What is a system catalog table in db2?

1108

What is sqlca’s maximum length?

1104

How does coalesce work?

964

Which command is used to connect to a database in DB2 ? Give the Syntax.

1034

Name the various locking levels available?

1038

How can deadlocks be resolved?

894

What is precompiler in db2?

960

Is the primary key a clustered index?

1080

What is a dbrm in db2?

971

Mention the location where the output received from explain statement is stored.

1056

For More Un-Answered { DB2 } Questions Click Here