Question

Which among the following is the correct syntax for defining “Constraint Check” in Mysql?

(a) gender  char(1)  check( gender IN (‘M’, ‘F’)),

(b) gender char (1) check,

(c) gender char (1) check ( gender ),

(d) none of the mentioned

The question was posed to me in class test.

Asked question is from Table Creation topic in section Using SQL to Manage Data of MySQL

Answer 1

Correct choice is (a) gender  char(1)  check( gender IN (‘M’, ‘F’)),

Explanation: Check constraint constrains the allowable values for a particular column.