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

DB2 Interview Questions

Questions Answers Views Company eMail

Which isolation level provides maximum concurrency?

668

What are the contents of a dclmgen?

629

What is role in db2?

622

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

659

What is the physical storage length of timestamp data type?

646

What is dclgen (declaration generator)?

604

What is the maximum length of sqlca?

869

How can you classify the locks in db2?

636

Which component is responsible for processing sql statements and selecting access paths?

671

What do you mean by storage group (stogroup)?

583

What is buffer pool?

614

What is the default page size of buffer pools?

650

What is the usage of open cursor command?

601

What is db2? Explain.

606

What is the use of predicate?

588

Post New DB2 Questions

Un-Answered Questions { DB2 }

How does coalesce work?

588

i want to maintain uniqueness on pdf without make lf??????????

1637

Define db2 and its databases?

622

What is buffer pool and list some of them?

630

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

643

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

10778

What is difference between rollback and commit?

635

Is db2 a mainframe?

591

What is access path in db2?

566

When do you specify the isolation level?

611

Which isolation level provides highest data integrity?

599

What is multi row fetch in db2?

611

What is check constraint. Explain with example.

650

If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1580

How can the duplicate values be eliminated from db2 select?

633

For More Un-Answered { DB2 } Questions Click Here