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)
C.
C, testes it.
id, Name
‘1’, ‘sun’
‘100’, ‘Earth’
‘201’, ‘pluto’
C
C
Hi Armir, did you pass the exam? Were these the questions or not.. thanks