Will this query produce any error? – McqOptions

MCQOPTIONS

1.	Will this query produce any error?
A.	Depends
B.	Error
C.	No Error
D.	All of above
E.	None of these
Answer» C. No Error

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?