Oracle
1Z0-882 · Question #92
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…
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #92. The question stem and answer options stay visible for context.
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?
Options
- A(200.pluto)
- B(101,Pluto)
- C(201,Pluto)
- D(300,Pluto)
Unlock 1Z0-882 to see the answer
You've previewed enough free 1Z0-882 questions. Unlock 1Z0-882 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.