Describe referential integrity?

COBOL SQL Interview Questions

(Continued from previous question...)

Describe referential integrity?

Referential integrity refers to a feature in DB2 that is used to ensure consistency of the data in the database.

(Continued on next question...)

Other Interview Questions

• What is the result of this query if no rows are selected: SELECT SUM(SALARY) FROM EMP WHERE QUAL='MSC'; ?
• What is a results table?
• What is normalization and what are the five normal forms?
• What is the difference between IN subselects and EXISTS subselect?
• What does the term "grant privileges" mean?
• What techniques are used to retrieve data from more than one table in a single SQL statement?
• How would you retrieve row from a DB2 table in embedded SQL?
• How would you find out the total number of row in a table?
• Suppose I have five SQL SELECT statements connected by UNION/UNION ALL ...
• Is BETWEEN inclusive of the range values specified?
• More...