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 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’);

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’);
Correct Answer Error, Duplicate value

Related Questions

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);
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 );
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 */
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
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?
Let relation R2 has a Foreign Key that refers to Primary Key of relation R1. Which of the following operations may cause violation of referential integrity constraints? I: insert into R1 II: insert into R2 III: delete from R1 IV: delete from R2
Consider a database table T containing two columns X and Y each of type integers. After the creation of the table, one record (X= 1, Y=l) is inserted in the table. Let MX and MY denote the respective maximum values of X and Y among all records in the table at any point in time. Using M X and MY, new records are inserted in the table 128 times with X and Y values being MX + 1, 2*MY + 1 respectively. It may be noted that each time after the insertion, values of MX and MY change. What will be the output of the following SQL query after the steps mentioned above are carried out? SELECT Y FROM T WHERE X=7;