200-710 Question #56: Real Exam Question with Answer & Explanation

QUESTION 59 Consider the following table data and PHP code, and assume that the database supports transactions. What is the outcome? Table data (table name "users" with primary key "id"): id name email

---

1 anna [email protected] 2 betty [email protected] 3 clara [email protected] 5 sue [email protected] PHP code (assume the PDO connection is correctly established): $dsn = 'mysql:host=localhost;dbname=exam'; $user = 'username'; $pass = '********'; $pdo = new PDO($dsn, $user, $pass); try { $pdo->exec("INSERT INTO users (id, name, email) VALUES (6, 'bill', '[email protected]')"); $pdo->exec("INSERT INTO users (id, name, email) VALUES (7, 'john', '[email protected]')"); throw new Exception(); } catch (Exception $e) { $pdo->rollBack(); }