Which clause in the SQL standard controls how NULL values in a compos – McqOptions

MCQOPTIONS

1.	Which clause in the SQL standard controls how NULL values in a composite foreign key are handled when comparing to a primary key.
A.	SET
B.	MATCH
C.	ON DELETE
D.	ON CASCADE
Answer» C. ON DELETE

Discussion

No Comment Found

Related MCQs

Which clause in the SQL standard controls how NULL values in a composite foreign key are handled when comparing to a primary key.
Which keyword is used to specify the foreign key after the table is created?
WHICH_KEYWORD_IS_USED_TO_SPECIFY_THE_FOREIGN_KEY_AFTER_THE_TABLE_IS_CREATED??$
Which_clause_in_the_SQL_standard_controls_how_NULL_values_in_a_composite_foreign_key_are_handled_when_comparing_to_a_primary_key.$
Which clause is used to remove a foreign key constraint?
If the storage engine InnoDB is not used, foreign key cannot be used.
Which clause names the parent table and the index columns in the table?
The property of InnoDB that enforces foreign key relationships stay intact is called _____________
Which storage engine in MySQL provides foreign key support?
Deletion of an employee from table also deletes that employee from another table. This kind of delete is called ____________