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

Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

DB2 Interview Questions

Questions Answers Views Company eMail

What is rct?

593

What is check constraint in db2?

448

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

483

Which components manage deadlocks in db2?

463

What is the physical storage length of time data type?

484

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

460

What is the picture clause of null indicator variable?

541

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

468

What is concurrency in db2?

1 1024

Which component is responsible for db2 startup and shutdown?

465

What is data manager?

460

What is the physical storage length of date data type?

509

Which isolation level provides highest data integrity?

464

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

452

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

453

Post New DB2 Questions

Un-Answered Questions { DB2 }

How do I add a column to an existing table in db2?

446

How to rename a table in DB2 ?

500

How to retrieve rows from a db2 table in embedded sql?

535

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2169

What is a cursor in programming?

436

Explain correlated sub-queries.

444

What is the difference between cursor and select statement?

451

Mention the location where the output received from explain statement is stored.

483

How many databases can be created inside an instance in db2 ?

454

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

512

What is a collection in db2?

445

What is temporal table in db2?

419

What is alias in db2?

427

What is dbrm? What it contains? When it will be created?

454

What is the maximum number of columns in a db2 table?

530

For More Un-Answered { DB2 } Questions Click Here