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,

2670

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 7894

How to insert more than one record using insert?

Atos Origin, IBM,

7 13783

How to update more then one record using update?

IBM,

5 11298

what are extents?

5 16417

what is consistency token

3 19425

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

IBM,

4 10501

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

4 10545

How can you split a table in to exactly half?

HSBC,

7 15831

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

Cap Gemini,

15 23516

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

Amdocs, HeadStrong,

8 15893

What is a view? Why use it?

2 7854

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,

2476

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 10642

what is the Foreign key? explain?

2 7524

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is alias in db2?

983

can we view the access paths created by dbrm ? how ? thx

6979

What is the cobol picture clause of the db2 data types date, time, timestamp?

1012

What is a dbrm in db2?

971

What is syscat in db2?

951

What is coalesce in db2?

1058

What is db2? Explain.

989

What is db2 instance?

1018

What is dclgen (declaration generator)?

1012

What is database manager in db2?

968

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

3147

What's The Percentage Free Space ?

1158

Explain packages.

1055

How would the varchar column remarks defined?

1038

before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

2125

For More Un-Answered { DB2 } Questions Click Here