Find The Error In The Following Sql Statementp Pre Langsql #464
Find the error in the following SQL statement?</p> <pre><code class="language-sql"> CREATE TABLE person ( person_id SMALLINT, name varchar, last varchar, Bith_date DATE CONSTRAINTS pk_person PRIMARY KEY (person_id)); INSERT INTO person VALUES( person_id, name, last, Birth_date) (1,’s’,’p’, 24-1991-01); </code></pre>
This multiple choice question (MCQ) is related to the book/course gs gs113 MySQL. It can also be found in gs gs113 Query Optimization - When Good Statements Go Bad - Quiz No.1.
Find the error in the following SQL statement?
CREATE TABLE person ( person_id SMALLINT, name varchar, last varchar, Bith_date DATE CONSTRAINTS pk_person PRIMARY KEY (person_id)); INSERT INTO person VALUES( person_id, name, last, Birth_date) (1,’s’,’p’, 24-1991-01);
In correct data value
No error
Any other error
None of the mentioned
Similar question(s) are as followings:
Online Quizzes of gs113 MySQL
MySQL Programs Using C - Using the Embedded Server Library - Quiz No.1
gs gs113 MySQL
Online Quizzes
System, Status and User Variables - User-Defined Variables - Quiz No.1
gs gs113 MySQL
Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.1
gs gs113 MySQL
Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.2
gs gs113 MySQL
Online Quizzes