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

DB2 Interview Questions

Questions Answers Views Company eMail

Can you tell me how can you find out the # of rows updated after an update statement?

602

What are the contents of dclgen?

643

Why select is not preferred in embedded sql programs?

701

How do you select a row using indexes in db2?

633

When reorg is used?

663

What are the various isolation levels possible?

637

How can you do the explain of a dynamic sql statement?

628

Can you use max on a char column?

632

List some fields from sqlca?

602

Explain what are the various isolation levels possible?

602

What is the physical storage length of the data types date, time, and timestamp?

593

What is the use of value function?

613

If I have a view which is a join of two or more tables, can this view be updateable?

685

What is the result of open cursor statement?

627

How would the varchar column remarks defined?

624

Post New DB2 Questions

Un-Answered Questions { DB2 }

Mention some fields that are a part of sqlca.

590

What is meant by explain?

654

What is host variable in db2 cobol?

591

What is the maximum length of sqlca?

852

What is collection in db2 bind?

567

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

570

what is the sqlcode -501

11258

What do you mean by storage group (stogroup)?

575

Can we update view in db2?

551

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

598

Explain package in db2 and its advantages?

588

How do I delete a table in db2?

638

How to connect to db2 database from windows command line?

555

What is the difference between cursor and select statement?

605

What is the role of union all and union

642

For More Un-Answered { DB2 } Questions Click Here