nerdexam
Zend

200-710 · Question #56

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 emai

The correct answer is A. The user 'bill' will be inserted, but the user 'john' will not be.. See the full explanation below for the reasoning.

Question

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(); }

Options

  • AThe user 'bill' will be inserted, but the user 'john' will not be.
  • BBoth user 'bill' and user 'john' will be inserted.
  • CNeither user 'bill' nor user 'john' will be inserted.
  • DThe user 'bill' will not be inserted, but the user 'john' will be.

How the community answered

(31 responses)
  • A
    81% (25)
  • B
    3% (1)
  • C
    10% (3)
  • D
    6% (2)

Community Discussion

No community discussion yet for this question.

Full 200-710 Practice