Zend Zend Certifications 200-550 Questions & Answers

• Question 171:

  Given the following DateTime object, which sample will NOT alter the date to the value '2014-02-15'? $date = new DateTime('2014-03-15');

  A. $date->sub(new DateInterval('P1M'));

  B. $date->setDate(2014, 2, 15);

  C. $date->modify('-1 month');

  D. $date->diff(new DateInterval('-P1M'));

  Correct Answer: D

• Question 172:

  Given a DateTime object that is set to the first second of the year 2014, which of the following samples will correctly return a date in the format '2014-01-01 00:00:01'?

  A. $datetime->format('%Y-%m-%d %h:%i:%s')

  B. $datetime->format('%Y-%m-%d %h:%i:%s', array('year', 'month', 'day', 'hour', 'minute', 'second'))

  C. $datetime->format('Y-m-d H:i:s')

  D. $date = date('Y-m-d H:i:s', $datetime);

  Correct Answer: C

• Question 173:

  Given the following DateTime objects, what can you use to compare the two dates and indicate that

  $date2 is the later of the two dates?

  $date1 = new DateTime('2014-02-03');

  $date2 = new DateTime('2014-03-02');

  A. $date2 > $date1

  B. $date2 < $date1

  C. $date1->diff($date2) < 0

  D. $date1->diff($date2) > 0

  Correct Answer: A

• Question 174:

  Which of the following will NOT instantiate a DateTime object with the current timestamp?

  A. $date = new DateTime();

  B. $date = new DateTime('@' . time());

  C. $date = new DateTime('now');

  D. $date = new DateTime(time());

  Correct Answer: D

• Question 175:

  Which of the following PHP values may NOT be encoded to a JavaScript literal using PHP's ext/json capabilities?

  A. 'Hello, world!'

  B. function(){ alert("Hello, world!"); }

  C. array('Hello, world!')

  D. array('message' => 'Hello, world!')

  Correct Answer: B

• Question 176:

  Given a PHP value, which sample shows how to convert the value to JSON?

  A. $string = json_encode($value);

  B. $string = Json::encode($value);

  C. $json = new Json($value); $string = $json->__toString();

  D. $value = (object) $value; $string = $value->__toJson();

  Correct Answer: A

• Question 177:

  Given a JSON-encoded string, which code sample correctly indicates how to decode the string to native PHP values?

  A. $json = new Json($jsonValue); $value = $json->decode();

  B. $value = Json::decode($jsonValue);

  C. $value = json_decode($jsonValue);

  D. $value = Json::fromJson($jsonValue);

  Correct Answer: C

• Question 178:

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

  $pdo->exec("INSERT INTO users (id, name, email) VALUES (7, 'john', '[email protected]')"); throw

  new Exception();

  } catch (Exception $e) {

  $pdo->rollBack();

  }

  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.

  Correct Answer: A

• Question 179:

  Consider the following table data and PHP code. What is a possible 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);

  $cmd = "SELECT name, email FROM users LIMIT 1";

  $stmt = $pdo->prepare($cmd);

  $stmt->execute();

  $result = $stmt->fetchAll(PDO::FETCH_BOTH);

  $row = $result[0];

  A. The value of $row is `array(0 => 'anna', 1 => '[email protected]')`.

  B. The value of $row is `array('name' => 'anna', 'email' => '[email protected]')`.

  C. The value of $row is `array(0 => 'anna', 'name' => 'anna', 1 => '[email protected]', 'email' => '[email protected]')`.

  D. The value of $result is `array('anna' => '[email protected]')`.

  Correct Answer: C

• Question 180:

  Consider the following table data and PHP code. 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 {

  $cmd = "INSERT INTO users (id, name, email) VALUES (:id, :name, :email)"; $stmt = $pdo->prepare

  ($cmd);

  $stmt->bindValue('id', 1);

  $stmt->bindValue('name', 'anna');

  $stmt->bindValue('email', '[email protected]');

  $stmt->execute();

  echo "Success!";

  } catch (PDOException $e) {

  echo "Failure!";

  throw $e;

  }

  A. The INSERT will succeed and the user will see the "Success!" message.

  B. The INSERT will fail because of a primary key violation, and the user will see the "Success!" message.

  C. The INSERT will fail because of a primary key violation, and the user will see a PDO warning message.

  D. The INSERT will fail because of a primary key violation, and the user will see the "Failure!" message.

  Correct Answer: B