Which data set is inserted in the table?

Consider the table t1 created with this statement:
CREATE TABLE t1(
id INT NOT NULL AUTO_INCREMENT
PRIMARY KEY,
Name CHAR (20)
ENGINE=InnoDB;
After inserting three rows, the table contains:

These commands are executed:
DELETE FROM t1 WHERE id=200;
INSERT INTO t1 (name) VALUES (‘pluto’):
Which data set is inserted in the table?

Consider the table t1 created with this statement:
CREATE TABLE t1(
id INT NOT NULL AUTO_INCREMENT
PRIMARY KEY,
Name CHAR (20)
ENGINE=InnoDB;
After inserting three rows, the table contains:

These commands are executed:
DELETE FROM t1 WHERE id=200;
INSERT INTO t1 (name) VALUES (‘pluto’):
Which data set is inserted in the table?

A.
(200.pluto)

B.
(101,Pluto)

C.
(201,Pluto)

D.
(300,Pluto)



Leave a Reply 5

Your email address will not be published. Required fields are marked *


Jay

Jay

C, testes it.

id, Name
‘1’, ‘sun’
‘100’, ‘Earth’
‘201’, ‘pluto’

armir01

armir01

C

anis

anis

Hi Armir, did you pass the exam? Were these the questions or not.. thanks