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"):
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’, ‘delta@example.com’)");
$pdo->begin();
$pdo->exec("INSERT INTO users (id, name, email) VALUES (7, ‘john’,
‘epsilon@example.com’)");
throw new Exception();
} catch (Exception $e) {
$pdo->roll Back();
A . The user ‘bill’ will be inserted, but the user ‘john’ will not be.
B . Both user ‘bill’ and user ‘john’ will be inserted.
C . Neither user ‘bill’ nor user ‘john’ will be inserted.
D . The user ‘bill’ will not be inserted, but the user ‘john’ will be.
Answer: A