What is the outcome?

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’, ‘[email protected]’)");

$pdo->begin();

$pdo->exec("INSERT INTO users (id, name, email) VALUES (7, ‘john’,

‘[email protected]’)");

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.

View Answer

Answer: A