Bissoy.com
Doctors Medicines MCQs Q&A

Find the error in the following SQL statement?
CREATE TABLE person( person_id SMALLINT, name VARCHAR, LAST VARCHAR, Bith_date DATECONSTRAINTS pk_person PRIMARY KEY (person_id));INSERT INTO personVALUES( person_id, name, LAST, Birth_date)(1,’s’,’p’, 24-1991-01);

Find the error in the following SQL statement?

CREATE TABLE person( person_id SMALLINT, name VARCHAR, LAST VARCHAR, Bith_date DATECONSTRAINTS pk_person PRIMARY KEY (person_id));INSERT INTO personVALUES( person_id, name, LAST, Birth_date)(1,’s’,’p’, 24-1991-01);
Correct Answer In correct data value

Related Questions

Find the error in the following SQL statement?
CREATE TABLE person( person_id SMALLINT, name VARCHAR, LAST VARCHAR CONSTRAINTS pk_person PRIMARY KEY (person_id)); INSERT INTO person VALUES( person_id, name, LAST) (1, ’s’, ’p’); INSERT INTO person ( person_id, name, LAST) VALUES(1,’s’,’p’);
In the following SQL query, what does "person_id" stands for?
CREATE TABLE person(person_ id SMALLINT UNSIGNED,fname VARCHAR(20),lname VARCHAR(20),CONSTRAINT pk_person PRIMARY KEY (person_id));
Find out the logical error in the following MySQL code snippet?
CREATE TABLE person( person_id VARCHAR(20), Name VARCHAR (20), Address VARCHAR (20), Mobile_no SMALLINT );
Select the correct differences between char and varchar data types? i. varchar is non unicode and char is unicode character data type ii. char is ‘n’ bytes whereas varchar is actual length in bytes of data entered in terms of storage size iii. varchar is variable in length and char is the fixed length string iv. For varchar, if a string is less than the maximum length then it is stored in verbatim without any extra characters while for char if a string is less than the set length it is padded with extra characters to equalize its length to given length
Will the following SQL command produce any error?
INSERT INTO person(person_id, fname,lname)VALUES (1,’S’,’U’),VALUES (1,’T’,’U’);/* where person_id is a primary key */
Will the following SQL command produce any error?
INSERT INTO person(person_id, fname,lname)VALUES (1,’S’,’U’),VALUES (2,’T’,’U’);/* where person_id is a primary key */
In the following SQL command "person_id" can be . . . . . . . .
SELECT person_id, fname, lname, Birth_data FROM person WHERE person_id=1;
Given the following statements: S1: A foreign key declaration can always be replaced by an equivalent check assertion in SQL. S2: Given the table R (a, b, c) where a and b together form the primary key, the following is a valid table definition. CREATE TABLE S (                 a INTEGER,                 d INTEGER,                 e INTEGER,                 PRIMARY KEY (d)                 FOREIGN KEY (a) references R) Which one of the following statements is CORRECT?
In the following MySQL command how many rows will be deleted?
DELETE personWHERE person_id<10;/*person_id is a primary key */
In the following MySQL command how many rows will be updated?
UPDATE personSET lname=’s’,Fname=’p’,WHERE person_id<10;/* person_id is a primary key */