Home » MYSQL » Mysql Query Optimization » Question
  1. Find the error
    CREATE TABLE Employee
    (Employee_id SMALLINT, name VARCHAR, LAST VARCHAR, Bith_date DATE
    CONSTRAINTS pk_Employee PRIMARY KEY (Employee_id));
    INSERT INTO Employee
    VALUES(Employee_id, name, LAST, Birth_date)
    (1,’s’,’p’, 24-1991-01);
    1. No error
    2. Any other error
    3. In correct data value
    4. All of above
    5. None of these
Correct Option: C

Format for DATE datatype is YYYY-MM-DD.



Your comments will be displayed only after manual approval.