Find out the logical error in the following query? – McqOptions

MCQOPTIONS

1.	Find out the logical error in the following query?
A.	Primary key is missing
B.	Lesser number of columns
C.	Incorrect definition
D.	All of above
E.	None of these
Answer» B. Lesser number of columns

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?