Question: How to write store Procedure for insert of values by using COBOL,DB2 Programs?
Question: Explain the use of the WHERE clause. WHERE is used with a relational statement to isolate the object element or row.
Question: What are foreign keys?
Question: What is normalization and what are the five normal forms?
Question: What is a DB2 plan?
Question: What is a DB2 access path?
Question: What is a DB2 bind?
Question: What is an alias and how does it differ from a synonym?
Question: What is a synonym? How is it used?
Question: What is a NULL value? What are the pros and cons of using NULLS?
Question: What is the cascade rule and how does it relate to deletions made with a subselect. The cascade rule will not allow deletions based on a subselect that references the same table from which the deletions are being made.
Question: Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
Question: If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
Question: What is a LIKE table and how is it created?
Question: When can an insert of a new primary key value threaten referential integrity?
Question: What are delete-connected tables?
Question: What is the self-referencing constraint?
Question: What is a clustered index?