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 8030

How to insert more than one record using insert?

Atos Origin, IBM,

7 14088

How to update more then one record using update?

IBM,

5 11565

what are extents?

5 16665

what is consistency token

3 19590

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

IBM,

4 10689

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

4 10730

How can you split a table in to exactly half?

HSBC,

7 16132

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

Cap Gemini,

15 24124

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

Amdocs, HeadStrong,

8 16218

What is a view? Why use it?

2 7976

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 10918

what is the Foreign key? explain?

2 7671

Post New DB2 Questions

Un-Answered Questions { DB2 }

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

1104

What is nvl in db2?

1094

What are the two types of logging in the db2 database? Explain them.

1074

what are bind concepts in db2 cobol?

1093

Mention data types used in db2 ?

1159

What is the difference between spufi and qmf?

1132

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2098

How do you pull up a query which was previously saved in qmf?

1151

What is performance tuning db2?

1062

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

1169

Which component is responsible for db2 startup and shutdown?

1035

Explain packages.

1113

How do I optimize a query in db2?

1101

What are the rules for db2 programming?

1089

What is blu acceleration in db2?

1070

For More Un-Answered { DB2 } Questions Click Here