MCQOPTIONS
Bookmark
Saved Bookmarks
→
Mysql
→
Data Types in Mysql
→
Find the error..
1.
Find the error
A.
No error
B.
Any other error
C.
In correct data value
D.
All of above
E.
None of these
Answer» D. All of above
Show Answer
Discussion
No Comment Found
Post Comment
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?
Reply to Comment
×
Name
*
Email
*
Comment
*
Submit Reply