What are foreign keys?

COBOL SQL Interview Questions

(Continued from previous question...)

What are foreign keys?

There are attributes of one table that have matching values in a primary key in another table, allowing for relationships between tables.

(Continued on next question...)

Other Interview Questions

• Describe a primary key?
• Can one add columns to a table after it has been defined?
• What is a synonym? How is it used
• What does the term "grant privileges" mean?
• What are the column name qualifiers?
• Why SELECT * is not preferred in embedded SQL programs ?
• Is DECLARE CURSOR executable?
• What do you accomplish by GROUP BY ... HAVING clause ?
• How would you find out the total number of row in a table?
• What authority is required to create a table?
• More...