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 8906

is it compulsory commitment control in journal?

TCS,

2478

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

IBM,

2 13368

how will you retrieve first record in table

UST,

1 6186

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 5867

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 11371

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 10600

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

Wipro,

2 7143

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

IBM,

1 9519

How will fetch last 5 rows from table in db2

6 17963

how to identify the pseudo conversation by seeing the program

DELL,

2 7882

cobol-db2 runjcl please?

DELL,

2 6768

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

DELL, HCL,

5 11072

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 4812

what is the sqlcode -501

IBM, Polaris, Zeus,

5 13151

Post New DB2 Questions

Un-Answered Questions { DB2 }

How is deadlock resolved?

1146

What is rebind in db2?

1066

When do you specify the isolation level?

1032

How do I create a view in db2?

1024

List out the buffer pools in db2

1075

How do I optimize a query in db2?

1101

What is db2 look?

1024

SET is the ANSI standard for variable assignment, SELECT is not. SET can only assign one variable at a time, SELECT can make multiple assignments at once. If assigning from a query, SET can only assign a scalar value. If the query returns multiple values/rows then SET will raise an error. SELECT will assign one of the values to the variable and hide the fact that multiple values were returned (so you'd likely never know why something was going wrong elsewhere - have fun troubleshooting that one) When assigning from a query if there is no value returned then SET will assign NULL, where SELECT will not make the assignment at all (so the variable will not be changed from it's previous value) As far as speed differences - there are no direct differences between SET and SELECT. However SELECT's ability to make multiple assignments in one shot does give it a slight speed advantage over SET.

2671

What is the maximum length of sqlca?

1529

What is the use of predicate?

1043

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1158

Explain about rct in db2?

1109

What is dclgen in db2?

1148

What is ibm db2 connect?

999

Why do chiropractors use drop table?

1109

For More Un-Answered { DB2 } Questions Click Here