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?<br><pre class="prettyprint lang-c">INSERT INTO Employee<br>(Emp_id, fname,lname)<br>VALUES (101, Sujit ,'Gupta'),<br>VALUES (102, Ajit , Gupta );<br>/* where person_id is a primary key */<br></pre>
In the following query, what does person_id stands for?<br><pre class="prettyprint lang-c"> CREATE TABLE Student<br> (id SMALLINT UNSIGNED,<br> fname VARCHAR(20),<br> lname VARCHAR(20) ,<br> CONSTRAINT pk_Student PRIMARY KEY (Student_id));<br></pre>
In the following query, what does person stands for:<br><pre class="prettyprint lang-c">INSERT INTO Student<br> (id, fname, lname) <br> VALUES (1, Ajit , Gupta );<br></pre>
Find out the logical error in the following query?<br><pre class="prettyprint lang-c">CREATE TABLE Employee<br> ( Emp_id VARCHAR(50),<br> Emp_Name VARCHAR (50),<br> Emp_Address VARCHAR (50),<br> Emp_Mobile_no SMALLINT <br> );<br></pre>
Will this query produce any error?<br><pre class="prettyprint lang-c">INSERT INTO Employee<br> (Emp_id, fname,lname)<br> VALUES (101, Sujit , Gupta ),<br> VALUES (101, Ajit , Gupta );<br> /* where person_id is a primary key */<br></pre>
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?