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 6958

what is a trigger and types of triggers

HSBC,

3 9181

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 6559

what is rebinding ?

IBM,

1 5921

what is the use of bind parameter, Replace?

IBM,

5 10782

difference between group clause and order clause

1 5230

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

1 4225

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

Syntel,

1 5784

what is different three logs in DB2?

Syntel,

1 5779

what is difference between random and sequence file access

Syntel,

1 5166

How do you run JCL in cobol program

IBM, Syntel,

1 5653

what is difference between Plan and Package

Syntel,

1 6128

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 10883

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

Hewitt,

1 5900

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

3 46304

Post New DB2 Questions

Un-Answered Questions { DB2 }

Explain about open switch business continuity software?

1140

what is db2 restart?

2165

What is the physical storage length of time data type?

1133

What is a trigger in the db2 database?

1091

How and when does the db2 enforces the unique key?

1086

Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1444

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1090

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2371

Explain about rct.

1093

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1110

How can tablespace be moved to another dasd volume that is allocated for that tablespace?

1242

What is the difference between oracle and db2?

1117

How connect db2 database to datastage?

1249

What is bufferpool in db2?

1059

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

2048

For More Un-Answered { DB2 } Questions Click Here