DB2 interview questions – page 3

What is an intent lock?

What do you mean by NOT NULL? When will you use it?

What is EXPLAIN? ?

What is severity one error in production support?

When do you use the IMAGECOPY?

What is a DB2 bind?

What is a clustering index ?

What is CHECK PENDING ?

What is the picture clause of the null indicator variable? ?

What do you need to do before you do EXPLAIN?

When do you use a LIKE statement?

What is a synonym? How is it used?

How to load data to a table?

What is diff b/w QMF & Spoofi?

What is low values and high values?

What is a composite index and how does it differ from a multiple index?

What are some sql aggregates and other built-in functions?

After retrieving the elements from production,how can do the testing before moving the changes to production. Whether we have to create the JCL for testing or it will automatically tested and compiled?

At what stage db2 must be up?

How to know other person job status?

What is a DB2 access path?

Give some example of statistics collected during RUNSTATS?

What is 'LIKE' used for in WHERE clause? What are the wildcard characters?

What is the SQL Communications Area and what are some of its key fields?

In terms of DB2 indexing, what is the root page?

What happens to the PLAN if index used by it is dropped?

What is RUNSTATS?

What is the diff bet plan,package,dbrm?

How to pass return codes from Cobol to jcl?

In my jcl ,the 1st step is delete step, if the data set is existing, I want to delete, that one ,if dataset is no existing, I do not want abend the job, how can I code in disp?