Exam 200-710 topic 1 question 42 discussion

Actual exam question from Zend's 200-710

Question #: 42
Topic #: 1

Consider the following table data and PHP code. What is the outcome?
Table data (table name "users" with primary key "id"):

PHP code (assume the PDO connection is correctly established):

A. The INSERT will succeed and the user will see the "Success!" message.
B. The INSERT will fail because of a primary key violation, and the user will see the "Success!" message.
C. The INSERT will fail because of a primary key violation, and the user will see a PDO warning message.
D. The INSERT will fail because of a primary key violation, and the user will see the "Failure!" message.

Show Suggested Answer

Suggested Answer: B 🗳️

by sjranjan at Sept. 30, 2021, 7:27 p.m.