DB2 Interview Questions
Questions Answers Views Company eMail

How do you simulate the explain of an embedded sql statement in spufi/qmf?

723

What is meant by dclgen?

704

My sql statement select avg(salary) from emp yields inaccurate results. Why?

735

How is a typical db2 batch pgm executed?

720

Differentiate between cs and rr isolation levels? Where do you specify them?

671

Name the various locking levels available?

707

Explain how can you do the explain of a dynamic sql statement?

749

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

735

How do you eliminate duplicate values in db2?

795

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

681

How do you pull up a query which was previously saved in qmf?

777

When do you specify the isolation level?

687

Explain in brief how does db2 determine what lock-size to use?

673

How do you retrieve the first 5 characters of firstname column of db2 table emp?

1 1310

How would you find out the total number of rows in a db2 table?

664


Post New DB2 Questions

Un-Answered Questions { DB2 }

Mention the definition of cobol in varchar field.

776


define clustering index.

702


What is the clustering index in the db2 database?

650


What is difference between alias and synonym in db2?

726


What is db2 optimizer?

868






Is db2 a mainframe?

677


What is a collection in db2?

675


Can one database have multiple instances?

661


Can you use max on a char column?

717


What is runstats db2?

664


How do I optimize a query in db2?

710


How to create backup table in db2?

740


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

4329


What is check constraint in db2?

705


What is bind package and plan in db2?

694