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 8907

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 5868

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 11373

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 10603

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 9520

How will fetch last 5 rows from table in db2

6 17963

how to identify the pseudo conversation by seeing the program

DELL,

2 7883

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 13152

Post New DB2 Questions

Un-Answered Questions { DB2 }

How do you find the maximum value in a column in db2?

1106

How to get the ddl of a table in db2?

1131

What are the various isolation levels possible?

1122

what is diffrence b/w file-aid tool and file-aid utility???

4892

What is the syntax for seeing the columns and data types of a table in the db2 database?

1169

What is a db2 collection?

1046

On which levels locks can be applied?

1133

What is a bind in db2?

1042

What is reorg?

1161

What is db2 optimizer?

1237

What's The Percentage Free Space ?

1224

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1102

What is copy pending and check pending in db2?

1004

What is blu acceleration in db2?

1070

Which command is used to connect to a database in DB2 ? Give the Syntax.

1104

For More Un-Answered { DB2 } Questions Click Here