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

DB2 Interview Questions

Questions Answers Views Company eMail

explain about index with examples

Syntel,

2 6935

what is a trigger and types of triggers

HSBC,

3 9154

I have a table name Table1 which contain columns Cust_no, car_model, country, salesamt. The records are 101, Fiat, India, 12345 2nd record is 102, Tata, USA, 98743 3rd record is 101, indica, India, 65342 4th record is 103, Toyota, UK, 64522 5th record is 103, Maruti, USA, 98632 and so on..... Now my question is write sql query which will give me detail about the sum of sales amount in perticular country

IBM,

2 6539

what is rebinding ?

IBM,

1 5900

what is the use of bind parameter, Replace?

IBM,

5 10743

difference between group clause and order clause

1 5211

what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........

1 4217

what is difference between Static call and Dynamic call? How does it function?

Syntel,

1 5769

what is different three logs in DB2?

Syntel,

1 5758

what is difference between random and sequence file access

Syntel,

1 5149

How do you run JCL in cobol program

IBM, Syntel,

1 5626

what is difference between Plan and Package

Syntel,

1 6107

How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement

Syntel,

5 10852

how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?

Hewitt,

1 5879

What is -904 sql code? How to resolve it?

3 46262

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is a trigger in the db2 database?

1069

What is with ur in db2?

1302

What is the difference between cursor and select statement?

1097

Is db2 relational database?

972

What is the use of commit in db2?

1073

Why cursor is used in db2?

1036

What is an instance in db2?

1033

Is schema the same as database?

1053

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

2042

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

2322

What is the difference between cursor stability and repeatable read isolation levels?

1170

What are the various data types available in db2?

1089

How do I add a column to an existing table in db2?

1030

How to run db2 command in windows?

1191

What is the use of db2 optimizer?

1110

For More Un-Answered { DB2 } Questions Click Here