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

DB2 Interview Questions

Questions Answers Views Company eMail

What techniques will be used to avoid deadlock??

IBM, SUN,

5 14582

we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?

2 18123

One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?

3 18618

pls tell me abt the normalization five types....

2 5963

What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.

Cap Gemini, Verizon,

4 11876

My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .

Cap Gemini, RBS,

3 12962

Can we able to find all the Table names under a Particular Plan?

CTS,

1 6757

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

Cap Gemini,

1 8549

what is differnece between DROP TABLE & DELETE TABLE .

Cap Gemini,

4 11643

What if we fail to give values in columns declared as NOT NULL ?

Cap Gemini,

3 10026

What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?

Cap Gemini,

2 9388

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

Cap Gemini,

1 6706

What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

Cap Gemini,

3 12975

i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.

2442

How Plan is created while executing the query using SPUFI?

3 8743

Post New DB2 Questions

Un-Answered Questions { DB2 }

How do I optimize a query in db2?

1146

What is the use of value function?

1203

What is cursor in dbms?

1112

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1788

Explain the contention situations caused by locks?

1141

Explain about cursor stability?

1106

What is the role of the data page in the db2 database?

1082

Where do you specify them?

1365

How to find schema of a table in db2?

1064

What is db2 plan table?

1108

How to check last update on table in db2?

1097

What are the rules for db2 programming?

1153

What is db2 stogroup?

1220

Explain in detail about buffer manager and its functionalities?

1135

What is ibm db2 database?

1061

For More Un-Answered { DB2 } Questions Click Here