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?

Question

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?

Accepted Answer

C. (201,Pluto)

Answer

A. (200.pluto)

Answer

B. (101,Pluto)

Answer

D. (300,Pluto)

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…