Chapter 4

Data Manipulation — quiz

5 questions · ~4 min

Chapter 4 quiz

Question 1 of 5

A tester wants to add a test user for a smoke test. The users table has columns: id (auto-increment), email, name, created_at (default NOW()). Which INSERT is most concise and robust to schema changes?

INSERT INTO users VALUES ('test@x.com', 'Test', NOW())
INSERT INTO users (email, name) VALUES ('test@x.com', 'Test')
INSERT users SET email = 'test@x.com'
INSERT INTO users (id, email, name, created_at) VALUES (NULL, 'test@x.com', 'Test', NOW())