DB2 Interview Questions
Questions Answers Views Company eMail

What are PACKAGES ?

3 7743

Which catalog tables contain authorization information?

1 5263

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 8307

How does one remove entries from the SCT02 table?

1 3848

what is the difference between join and union?

IBM,

4 16991

I use CS and update a page. Will the lock be released after I am done with that page?

2 8599

Explain what a plan is?

CTS,

3 7425

What is a synonym ?

2 4638

What are the four lockable units for DB2?

1 5480

In a DB2-CICS program which is acts as co-ordinator and which is participant?

IBM,

1 4524

Describe what a storage group(STOGROUP) is?

2 9255

What is SPUFI?

4 15434

What is the difference between SYNONYM and ALIAS?

TCS,

6 26315

What is a data page?

1 3699

What is a subselect? Is it different from a nested select?

1 6698


Post New DB2 Questions

Un-Answered Questions { DB2 }

What is performance tuning db2?

598


What does reorg do in db2?

564


What is the purpose of using commit?

604


What is consistency token in db2?

626


What is the difference between using bind () and rebind () methods of naming class?

766






What is data manager?

592


Is db2 a mainframe database?

555


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

573


Can we delete records from view?

549


How to fetch the last row from the table in SQL (db2)?

1020


How is a typical db2 batch pgm executed?

630


What is database alias db2?

584


Outputs of explain are with matchcols = 0. What does this signify?

604


What is host variable in db2 cobol?

585


What's The Error Code For Unique Index Voilation?

640