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(); }
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)- A81% (25)
- B3% (1)
- C10% (3)
- D6% (2)
Community Discussion
No community discussion yet for this question.