DB2 interview questions – page 5

My SQL statement SELECT AVG(SALARY) FROM EMP yields inaccurate results. Why?

What is dynamic SQL?

When you will use cursor with hold option?

Are views updateable ?

What are the three lock types?

Why SELECT * is not preferred in embedded SQL programs?

What is a DBRM, PLAN ?

What is stored in tables under creator SYSIBM?

Can you have more than one cursor open at any one time in a program ? ?

What is a cursor? why should it be used?

What is isolation level?

What are the advantages of using a PACKAGE?

What is the difference between primary key & unique index ?

There are two programs say A&B,A is only cobol program,B iscobol-db2 program, how to compile both programs?

What are the isolation levels possible ?

What do you accomplish by GROUP BY ... HAVING clause? ?

Is it mandatory to use DCLGEN? If not, why would you use it at all?

Can I use LOCK TABLE on a view?

Is DECLARE TABLE in DCLGEN necessary? Why it used?

Can anyone tell me when do we need a COLLECTION? I know the concept of PLAN and PACKAGE, but unable to understand about COLLECTION.

Where would you specify the DECLARE CURSOR statement? ?

What does the sqlcode of -818 pertain to?

What is diff b/w check pending and copy pending?

What is the cascade rule and how does it relate to deletions made with a subselect. The cascade rule will not allow deletions based on a subselect that references the same table from which the deletions are being made.

How do you find the maximum value in a column?

What is an inner join, and an outer join ?

How to Repair the table?

What is a clustered index?

How will the program knows which key has been pressed?

What is the FREE command?