DB2 Interview Questions
Questions Answers Views Company eMail

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

613

What is meant by dclgen?

594

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

615

How is a typical db2 batch pgm executed?

622

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

553

Name the various locking levels available?

612

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

628

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

625

How do you eliminate duplicate values in db2?

663

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

581

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

647

When do you specify the isolation level?

588

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

571

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

1 1096

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

553


Post New DB2 Questions

Un-Answered Questions { DB2 }

Describe major components of db2?

610


How do I change the column size in db2?

563


What is a db2 package?

578


What is scrollable cursor in db2?

564


What is a db2 table?

573






What is lock escalation in db2?

554


How can we retrieve the total number of records in RPG & CLLE?

170


What is cursor with hold option in db2?

589


How will you return the number of records in table?

496


What action db2 takes when a program aborts in the middle of a transaction?

633


How can we read records for specific member in CL? AND rpg?

214


What is clone table?

574


What is a page in db2?

581


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

561


What is the physical storage length of time data type?

641