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

DB2 Interview Questions

Questions Answers Views Company eMail

What is the logical entity between plan and Package?

5 8701

is it compulsory commitment control in journal?

TCS,

2419

What's the difference between DB2 active log and archive log? Thanks a lot...

IBM,

2 13206

how will you retrieve first record in table

UST,

1 6083

how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...

UST,

1 5773

in a table consist of 1000 records among that i was updated 145 record how could i know that ..list of recently updated record's and where could i see those updated record's....pls help me out....

Infosys,

4 11198

in my table i will update only 100 record among 1000 records i need to display recently updated record'.....can u tell me where those records are stored how can i display those records...?if there is any sql query pls let me know....?

Infosys,

3 10436

how we will do null data selection in cobol-db2 program

Wipro,

2 7025

what is SMP/E? and what are the major steps of it? thanks...

IBM,

1 9367

How will fetch last 5 rows from table in db2

6 17690

how to identify the pseudo conversation by seeing the program

DELL,

2 7766

cobol-db2 runjcl please?

DELL,

2 6597

can we update the table by using cursors can anyone post the query?

DELL, HCL,

5 10868

Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 4728

what is the sqlcode -501

IBM, Polaris, Zeus,

5 12926

Post New DB2 Questions

Un-Answered Questions { DB2 }

How can the duplicate values be eliminated from db2 select?

1044

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3091

What is the use of commit in db2?

1006

Explain in brief how does db2 determine what lock-size to use?

961

How can you quickly find out the # of rows updated after an update statement?

987

What is view db2?

1008

What parameters are used to control the free space in DB2?

1012

What is package in cobol db2?

1078

What is the meaning concurrency in the db2 database?

1061

What is db2 catalog database?

988

What are the rules for db2 programming?

1043

What is multi row fetch in db2?

988

Highlight all the advantages that are attached to a package.

1074

Can one database have multiple instances?

1007

What is ibm db2 database?

953

For More Un-Answered { DB2 } Questions Click Here