Bissoy.com
Doctors Medicines MCQs Q&A

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 (1,’T’,’U’);/* where person_id is a primary key */
Correct Answer Error

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’);
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 */
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 command "person_id" can be . . . . . . . .
SELECT person_id, fname, lname, Birth_data FROM person WHERE person_id=1;
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));
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 */
In the following MySQL command how many rows will be updated?
UPDATE personSET lname=’s’,Fname = ’p’,WHERE person_id = 1;/* person_id is a primary key */
In the following MySQL command how many rows will be deleted?
DELETE personWHERE person_id=1;/*person_id is a primary key */
In a village 50% of the villagers produce rice, 40% of the villagers produce apples and 50% of the villagers produce vegetables, 20% of the villagers produce rice and apples both, 25% of the villagers produce apples and vegetables both, 20% of the villagers produce rice and vegetables both and 10% of the villagers produce all three. Find the percentage of villagers who do not produce anything.