1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category
DB2 Interview Questions
Questions Answers Views Company eMail

What are the 4 environments which can access DB2 ?

 2 6082

What is the picture clause of the null indicator variable?

 6 17287

What will the FREE command do to a plan?

 2 4823

What is a DB2 bind?

Logica CMG,

1 6403

What information can you find in SYSIBM.SYSLINKS table?

TCS,

1 8318

What is the difference between IN subselects and EXISTS subselect?

HCL, PreVator, TCS,

1 9873

What is meant by concurrency?

 1 5345

What is subquery ?

 6 10431

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

 1 5102

How does the processing of a correlated subquery differ from a non correlated subquery?

 1 6628

Can you define an Index if the table size less than 10 PAGES?

IBM,

1 5451

What are the various locks available?

CTS,

5 10401

What will the DB2 optimizer do?

 2 5066

What are the contents of a DCLGEN?

MetLife,

4 11377

What is deadlock?

 2 5677

Post New DB2 Questions

Un-Answered Questions { DB2 }

What is meant by explain?

652

What is reorg?

610

What is null value in db2?

552

Explain about mirror activator disk mirroring?

548

What is the result of open cursor statement?

627




What is the difference between plan and package in db2?

564

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

643

What is blu acceleration in db2?

594

What is dclgen in db2?

664

What is alias in db2?

558

Discuss about db2 bind?

658

What is a system catalog table in db2?

576

What is a bind in db2?

585

How do we specify index to include or not during bind process.

1667

What is copy pending status in db2?

625

For More Un-Answered { DB2 } Questions Click Here