Which among the following is the correct syntax for defining Constrai – McqOptions

MCQOPTIONS

1.	Which among the following is the correct syntax for defining Constraint Check in Mysql?
A.	gender char (1) check,
B.	gender char (1) check ( gender ),
C.	gender char(1) check( gender IN ( M , F )),
D.	All of above
E.	None of these
Answer» D. All of above

Discussion

No Comment Found

Related MCQs

Will this query produce any error?INSERT INTO Employee(Emp_id, fname,lname)VALUES (101, Sujit ,'Gupta'),VALUES (102, Ajit , Gupta );/* where person_id is a primary key */
In the following query, what does person_id stands for? CREATE TABLE Student (id SMALLINT UNSIGNED, fname VARCHAR(20), lname VARCHAR(20) , CONSTRAINT pk_Student PRIMARY KEY (Student_id));
In the following query, what does person stands for:INSERT INTO Student (id, fname, lname) VALUES (1, Ajit , Gupta );
Find out the logical error in the following query?CREATE TABLE Employee ( Emp_id VARCHAR(50), Emp_Name VARCHAR (50), Emp_Address VARCHAR (50), Emp_Mobile_no SMALLINT );
Will this query produce any error?INSERT INTO Employee (Emp_id, fname,lname) VALUES (101, Sujit , Gupta ), VALUES (101, Ajit , Gupta ); /* where person_id is a primary key */
Which among the following are the correct definitions for NULL in Mysql?
In the following query, what does person stands for:
What is meaning of REFERENCES in table definition?
Find out the logical error in the following query?
Which among the following is the correct syntax for defining ENUM in Mysql?