Zend 200-710 Zend Certified Engineer Exam Exam Practice Test Questions

• Question 1

  When a query that is supposed to affect rows is executed as part of a transaction, and reports no affected rows, it could mean that: (Choose 2)

  • The transaction failed
  • The transaction affected no lines
  • The transaction was rolled back
  • The transaction was committed without error

  Show Answer Answer: A, ,B Next

• Question 2

  An unbuffered database query will: (Choose 2)

  • Return the first data faster
  • Return all data faster
  • Free connection faster for others scripts to use
  • Use less memory

  Show Answer Answer: A, ,D Next

• Question 3

  Which of the following rules must every correct XML document adhere to? (Choose 2)

  • It has to be well-formed.
  • It has to be valid.
  • It has to be associated to a DTD.
  • It may only contain UTF-8 encoded characters.

  Show Answer Answer: A, ,B Next

• Question 4

  Which of the following statements is true?

  • All PHP database extensions support prepared statements
  • All PHP database extensions come with their own special helper functions to escape user data to be used in dynamic SQL queries
  • All PHP database extensions provide an OOP interface
  • All PHP database extensions appear in the output of php -m , if installed and enabled

  Show Answer Answer: D Next

• Question 5

  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'?

  • $datetime->format('%Y-%m-%d %h:%i:%s')
  • $datetime->format('%Y-%m-%d %h:%i:%s', array('year', 'month', 'day', 'hour', 'minute', 'second'))
  • $datetime->format('Y-m-d H:i:s')
  • $date = date('Y-m-d H:i:s', $datetime);

  Show Answer Answer: C Next