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 9072

is it compulsory commitment control in journal?

TCS,

2519

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

IBM,

2 13466

how will you retrieve first record in table

UST,

1 6242

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 5936

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 11533

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 10767

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

Wipro,

2 7221

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

IBM,

1 9609

How will fetch last 5 rows from table in db2

6 18127

how to identify the pseudo conversation by seeing the program

DELL,

2 7959

cobol-db2 runjcl please?

DELL,

2 6868

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

DELL, HCL,

5 11232

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 4877

what is the sqlcode -501

IBM, Polaris, Zeus,

5 13296

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is null in db2?

1068

How to rename a table in DB2 ?

1142

Explain about open switch business continuity software?

1181

What is node in db2?

1097

Is the primary key a clustered index?

1199

How do I delete a table in db2?

1120

How to resolve deadlock issue

20300

is it compulsory commitment control in journal?

2519

What is null indicator in cobol db2?

1106

What is the maximum number of columns in a db2 table?

1342

What is runstats utility in db2?

1066

How can the duplicate values be eliminated from db2 select?

1155

Explain the function done by data manager?

1326

How do I create a view in db2?

1072

What does db2 blu stand for?

1213

For More Un-Answered { DB2 } Questions Click Here