DB2 interview questions – page 7

What techniques are used to retrieve data from more than one table in a single SQL statement?

What is difference between Collection and Version?

What is QUIESCE?

Explain the use of the WHERE clause. WHERE is used with a relational statement to isolate the object element or row.

When can an insert of a new primary key value threaten referential integrity?

What is a NULL value? What are the pros and cons of using NULLS?

Can u see s9(4)comp3 data?

What does it mean if the null indicator has -1, 0, -2? ?

What is cursor stability?

Where is the output of EXPLAIN stored? ?

Initial position of cursor of the exucuton of open statements?

What will happened .if the file is open in extend mode and corresponding is equal to old in jcl?

What are the various locks available?

What is lock escalation?

What is FREEPAGE and PCTFREE in TABLESPACE creation?

How does Db2 use multiple table indexes?

What is the meaning of underscore ( ?_? ) in the LIKE statement? ?

When you COMMIT, is the cursor closed?

What is the roll of INDEX in a query?

What are foreign keys?

What is IMAGECOPY ?

Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?

Consider the employee table with column PROJECT nullable. How can you get a list of employees who are not assigned to any project?

If I have a view which is a join of two or more tables, can this view be updateable?

How do you insert a record with a nullable column?

What is ACQUIRE/RELEASE in BIND?

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

How to read last record in vsam file.,I don't know how many records are there?

What are PACKAGES ? ?

What is a precompiler?