What is the role of CONSTRAINS in defining a table in Mysql? – McqOptions

MCQOPTIONS

1.	What is the role of CONSTRAINS in defining a table in Mysql?
A.	Declaring Foreign Key
B.	Restrictions on columns
C.	Declaring primary key
D.	All of above
E.	None of these
Answer» E. None of these

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?