DB2 interview questions – page 4

Commenly facing errors?

What is the difference between static and dynamic sql?

When will you chose to run RUNSTATS?

What is UNION,UNION ALL?

When would you prefer to use VARCHAR?

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause.)

When do you use subroutines?

How to retrieve n-th row ie n-th record of any table irrespective of the columns and the values present in the table without using ROWID(As it is not supported in DB@)

What are simple, segmented and partitioned table spaces ?

What is normalization and what are the five normal forms?

What will happened ,if the subprogram is called second time?

How do you retrieve the data from a nullable column? ?

Is BETWEEN inclusive of the range values specified? ?

What are some characteristics of columns that benefit from indexes?

What is the index ,types of index ?

Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?

Give the COBOL definition of a VARCHAR field.

What is maximum number of one storage group?

What is meant by index cardinality?

What is ALTER ?

Is DECLARE CURSOR executable?

What is index cardinality?

After bind i how can we run a cobol-db2 program?

What happens when you say OPEN CURSOR?

What are the 4 environments which can access DB2 ?

How would you print the output of an SQL statement from SPUFI? ?

How do you retrieve the first 5 characters of FIRSTNAME column of EMP table?

What is the use of VALUE function?

What is the difference between CS and RR isolation levels?

Give name some fields from SQLCA.