What is a predicate?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

What is a predicate?

A predicate is an element of a search condition that expresses or implies a comparison operation.

(Continued on next question...)

Other Interview Questions

• What happens to the PLAN if index used by it is dropped?
• When can you be sure that a quary will return onlyl one row ?
• What is the meaning of -805 SQL return code ?
• Where is the access path logic created by the DB2 Optimizer stored?
• What are the 4 environments which can access DB2?
• What is an intent lock?
• EXPLAN has output with MATCHCOLS ...
• What are foreign keys?
• What is the STOSPACE Utility used for ?
• What will the DB2 optimizer do?
• More...