DB2 Interview Questions
Questions Answers Views Company eMail

What is a view? Why use it?

3 5035

What is sqlcode -811?

Accenture, CTS, TCS,

7 71182

What is an intent lock?

3 9481

what types of copies can be made with the COPY Utility ?

1 3971

What is a synonym? How is it used?

2 4579

what is a collection?

2 4325

What is the difference between TYPE 1 index & TYPE 2 index

IBM,

1 12454

What are the disadvantages of using VARCHAR?

3 14051

What is the purpose of the DSNC transaction ?

1 6689

What are delete-connected tables?

1 3543

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 28505

What is a correlated sub query?

2 4494

What is read-only cursor?

1 5963

What Utility is used to migrate DB2 from one release to the next?

1 4883

What is Skeleton cursor table (SKCT)?

2 12693


Post New DB2 Questions

Un-Answered Questions { DB2 }

How is the value function used?

595


Define check constraint.

633


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

1884


What is bind and rebind in db2?

640


What is performance tuning db2?

603






What is explain in db2?

578


What is check constraint. Explain with example.

637


What is null indicator in db2?

593


what is utility for parm lib

1865


What is table space in db2?

570


What is database manager in db2?

543


Define declaration generator (dclgen).

658


What is load replace in db2?

557


Why do we use cursor?

589


Explain about rct in db2?

630