Question

Which clause names the parent table and the index columns in the table?

(a) REFERENCES

(b) ON DELETE

(c) CONSTRAINT

(d) FOREIGN KEY

The question was posed to me in homework.

I'm obligated to ask this question of Foreign Keys and Referential Integrity topic in portion Using SQL to Manage Data of MySQL

Answer 1

Right option is (a) REFERENCES

The explanation: In MySQL foreign key definition syntax, there are various components, namely, FOREIGN KEY, CONSTRAINT, REFERENCES and ON DELETE. The REFERENCES clause names the parent table and the index columns in the table.