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

DB2 Interview Questions

Questions Answers Views Company eMail

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

IBM,

2766

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

IBM,

3 8135

How to insert more than one record using insert?

Atos Origin, IBM,

7 14320

How to update more then one record using update?

IBM,

5 11732

what are extents?

5 16828

what is consistency token

3 19711

if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

IBM,

4 10818

what is the input to PLAN? what is the input to DBRM?

4 10873

How can you split a table in to exactly half?

HSBC,

7 16366

In a single table,How to retrieve a employee-id of an employee who works in more than one department?

Cap Gemini,

15 24536

how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

Amdocs, HeadStrong,

8 16432

What is a view? Why use it?

2 8056

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

TATA,

2594

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

Wipro,

6 11114

what is the Foreign key? explain?

2 7794

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is sqlca’s maximum length?

1244

What is reorg?

1238

What is db2 look?

1074

Explain about rct in db2?

1160

Mention the different locking levels that are available in db2.

1183

When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3630

What's The Percentage Free Space ?

1280

When reorg is used?

1178

What is the function of logging in the db2 database?

1172

What is ibm db2 connect?

1050

What is the difference between bind and rebind in db2?

1505

What is dbrm? When it will be created?

1084

My sql statement select avg(salary) from emp yields inaccurate results. Why?

1129

What language is db2 written in?

1099

List some fields from sqlca?

1103

For More Un-Answered { DB2 } Questions Click Here