DB2 Interview Questions
Questions Answers Views Company eMail

explain about index with examples

Syntel,

2 5718

what is a trigger and types of triggers

HSBC,

3 7607

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 5552

what is rebinding ?

IBM,

1 5160

what is the use of bind parameter, Replace?

IBM,

5 8758

difference between group clause and order clause

1 4500

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

1 3536

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

Syntel,

1 4902

what is different three logs in DB2?

Syntel,

1 4983

what is difference between random and sequence file access

Syntel,

1 4269

How do you run JCL in cobol program

IBM, Syntel,

1 4805

what is difference between Plan and Package

Syntel,

1 5216

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 9042

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

Hewitt,

1 5046

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

3 43181


Post New DB2 Questions

Un-Answered Questions { DB2 }

What do you mean by commit and rollback?

604


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

633


What is bind plan?

616


How do I change the column size in db2?

600


How do you concatenate the firstname and lastname from emp table to give a complete name?

607






How many databases can be created inside an instance in db2 ?

606


List some fields from sqlca?

615


What is the use of db2?

592


what is the role of the cursor in db2?

647


Explain about mirror activator disk mirroring?

564


What does db2 stand for?

606


How can the duplicate values be eliminated from db2 select?

634


Can one database have multiple instances?

583


What is the reason behind not using select * in embedded sql programs?

611


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

635