Find the errorCREATE TABLE Employee (Employee_id SMALLINT, name VARCHA – McqOptions

MCQOPTIONS

1.	Find the errorCREATE 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);
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

Discussion

No Comment Found

Related MCQs

Which of the following WHERE clauses is faster?1. WHERE col * 3 < 92. WHERE col < 9 / 3
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;
Find the errorCREATE 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);
Find the error?CREATE TABLE Employee( Employee_id SMALLINT, name VARCHAR, LAST VARCHAR CONSTRAINTS pk_Employee PRIMARY KEY (Employee_id)); INSERT INTO Employee VALUES( Employee_id, name, LAST) (1, s , p ); INSERT INTO person ( Employee_id, name, LAST) VALUES(1, s , p );
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?