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,

2727

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 8022

How to insert more than one record using insert?

Atos Origin, IBM,

7 14077

How to update more then one record using update?

IBM,

5 11554

what are extents?

5 16663

what is consistency token

3 19588

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

IBM,

4 10679

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

4 10727

How can you split a table in to exactly half?

HSBC,

7 16129

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

Cap Gemini,

15 24115

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

Amdocs, HeadStrong,

8 16213

What is a view? Why use it?

2 7975

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,

2535

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 10898

what is the Foreign key? explain?

2 7671

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is the information associated with sysibm.syslinks table?

1123

what is diffrence b/w file-aid tool and file-aid utility???

4890

What is plan in cobol db2?

1138

What is ibm db2 database?

1002

What is dbrm?

1105

What is blu acceleration in db2?

1069

What is a db2 package?

1056

What are the rules for db2 programming?

1087

What is db2?

1182

How to resolve deadlock issue

20121

Can we update view in db2?

1002

What is dbrm? What it contains?

1163

What's The Error Code For Unique Index Voilation?

1237

What is dclgen in db2?

1148

What are db2 tables?

1125

For More Un-Answered { DB2 } Questions Click Here