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

DB2 Interview Questions

Questions Answers Views Company eMail

What is rct?

751

What is check constraint in db2?

603

How can you count the number of rows from a table tab?

631

Which components manage deadlocks in db2?

606

What is the physical storage length of time data type?

673

How many types of page locks can be held in db2?

589

What is the picture clause of null indicator variable?

688

Where can you declare a cursor in a cobol-db2 program?

602

What is concurrency in db2?

1 1418

Which component is responsible for db2 startup and shutdown?

624

What is data manager?

603

What is the physical storage length of date data type?

722

Which isolation level provides highest data integrity?

593

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

601

What is the maximum size of varchar data type in db2?

643

Post New DB2 Questions

Un-Answered Questions { DB2 }

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

712

List out the three types of page locks that can be held.

685

Can we update view in db2?

555

What is the maximum size of a char data type in db2?

584

What is check constraint. Explain with example.

642

What do you mean by rollback?

572

What is dbrm? When it will be created?

594

Mention data types used in db2 ?

671

What is release/acquire in bind?

651

What is explain in db2?

582

What is null indicator in db2?

602

Define declaration generator (dclgen).

665

What is database reorganization?

587

What is db2 catalog database?

581

What is package in cobol db2?

698

For More Un-Answered { DB2 } Questions Click Here