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 8895

is it compulsory commitment control in journal?

TCS,

2474

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

IBM,

2 13366

how will you retrieve first record in table

UST,

1 6181

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 5862

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 11360

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 10592

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

Wipro,

2 7131

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

IBM,

1 9505

How will fetch last 5 rows from table in db2

6 17946

how to identify the pseudo conversation by seeing the program

DELL,

2 7875

cobol-db2 runjcl please?

DELL,

2 6755

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

DELL, HCL,

5 11062

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 4806

what is the sqlcode -501

IBM, Polaris, Zeus,

5 13133

Post New DB2 Questions

Un-Answered Questions { DB2 }

How to access db2 tables in mainframe?

1051

What is cloudant database?

1094

What is difference between rollback and commit?

1154

What is dpf in db2?

1103

How to find primary key of a table in db2?

1061

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2210

What do you mean by between and in? Is between inclusive of specified range values?

1089

What is data manager?

1046

Name the various locking levels available?

1089

What are the various data types available in db2?

1089

What is null value in db2?

1019

Mention the location where the output received from explain statement is stored.

1125

What is node in db2?

1042

Explain the function done by data manager?

1274

What r the comman abends in db2, jcl and cobol???????

2250

For More Un-Answered { DB2 } Questions Click Here