Which clause in the SQL standard controls how NULL values in a composite foreign key are handled when comparing to a primary key. - MySQL MCQs

B

Brijesh Goswami • 9.45K Points
Tutor III

Q. Which clause in the SQL standard controls how NULL values in a composite foreign key are handled when comparing to a primary key.

(A) ON CASCADE
(B) ON DELETE
(C) SET
(D) MATCH

Correct Answer - Option(D)
Views: 138
Filed under category MySQL

No solution found for this question.
Add Solution and get +2 points.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs on MySQL

Q. The mode of search is the search string parsed into words and the search looks for rows is . . . . . . . .

Q. The option that specifies the data directory location at server startup is . . . . . . . .

Q. The privilege that must be given to the database to create a stored function or procedure is . . . . . . . .

Q. Which mode prevents MySQL to perform full checking of date parts?

Q. Which clause is used to display information that matches a given pattern?

Q. Which program is used as a utility for MyISAM table maintenance?

Q. The option which finds the startup options supported by the server through mysqld is . . . . . . . .

Q. If the storage engine InnoDB is not used, foreign key cannot be used.

Q. The option that supplies the pathname to root directory of MySQL installation is . . . . . . . .

Q. Is there any error in the following MySQL statement? SELECT e.emp_id, e.fname,e.lname,d.name FROM employee e INNER JOIN department d ON e.dept_id=e.dept_id;

Learn All MySQL MCQs

Question analytics