What are the results of the following queries if col is an integer col – McqOptions

MCQOPTIONS

1.	What are the results of the following queries if col is an integer column? 1. SELECT * FROM student WHERE id = '6'; 2. SELECT * FROM student WHERE id = 6;
A.	1 is an error
B.	2 is an error
C.	same
D.	different
E.	None of these
Answer» D. different

Discussion

No Comment Found

Related MCQs

Which of the following WHERE clauses is faster?<br><pre class="prettyprint lang-c">1. WHERE col * 3 < 9<br>2. WHERE col < 9 / 3<br></pre>
What are the results of the following queries if col is an integer column?<br><pre class="prettyprint lang-c">1. SELECT * FROM student WHERE id = '6';<br>2. SELECT * FROM student WHERE id = 6;<br></pre>
Find the error<br><pre class="prettyprint lang-c">CREATE TABLE Employee<br> (Employee_id SMALLINT, name VARCHAR, LAST VARCHAR, Bith_date DATE<br> CONSTRAINTS pk_Employee PRIMARY KEY (Employee_id));<br> INSERT INTO Employee<br> VALUES(Employee_id, name, LAST, Birth_date)<br> (1, s , p , 24-1991-01);<br></pre>
Find the error?<br><pre class="prettyprint lang-c">CREATE TABLE Employee<br>( Employee_id SMALLINT, name VARCHAR, LAST VARCHAR<br> CONSTRAINTS pk_Employee PRIMARY KEY (Employee_id));<br> INSERT INTO Employee<br> VALUES( Employee_id, name, LAST)<br> (1, s , p );<br> INSERT INTO person<br> ( Employee_id, name, LAST)<br> VALUES(1, s , p );<br></pre>
Find the error
Which of the following are the valid database datatypes in Mysql?
To perform analysis of key values by the server, the statement used is __________.
What are the results of the following queries if col is an integer column?
Which of the following WHERE clauses is faster?