Zend Zend Certifications 200-710 Questions & Answers

• Question 41:

  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)

  A. The transaction failed

  B. The transaction affected no lines

  C. The transaction was rolled back

  D. The transaction was committed without error

  Correct Answer: AB

• Question 42:

  What is the preferred method for preventing SQL injection?

  A. Always using prepared statements for all SQL queries.

  B. Always using the available database-specific escaping functionality on all variables prior to building the SQL query.

  C. Using addslashes() to escape variables to be used in a query.

  D. Using htmlspecialchars() and the available database-specific escaping functionality to escape variables to be used in a query.

  Correct Answer: A

• Question 43:

  What is the output of the following code?

  class Bar {

  private $a = 'b';

  public $c = 'd';

  }

  $x = (array) new Bar();

  echo array_key_exists('a', $x) ? 'true' : 'false';

  echo '-';

  echo array_key_exists('c', $x) ? 'true' : 'false';

  A. false-false

  B. false-true

  C. true-false

  D. true-true

  Correct Answer: B

• Question 44:

  What function can be used to retrieve an array of current options for a stream context?

  A. stream_context_get_params

  B. stream_context_get_default

  C. stream_context_get_options

  D. The 'options' element of the stream_get_meta_data return value

  Correct Answer: C

• Question 45:

  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 46:

  Which elements does the array returned by the function pathinfo() contain?

  A. root, dir, file

  B. dirname, filename, fileextension

  C. dirname, basename, extension

  D. path, file

  Correct Answer: C

• Question 47:

  You work for a shared hosting provider, and your supervisor asks you to disable user scripts to dynamically load PHP extensions using the dl() function. How can you do this? (Choose 2)

  A. Set enable_dl to Off in the server's php.ini configuration file.

  B. Add dl to the current value of disable_functions in the server's php.ini configuration file.

  C. Add dl to the current value of disable_classes in the server's php.ini configuration file.

  D. Write a custom function called dl() , save it under the name prepend.inc and then set the auto_prepend_file directive to prepend.inc in php.ini.

  Correct Answer: AB

• Question 48:

  Which of these statements about PDO is NOT true?

  A. PDO has built-in support for Large Objects (LOBs).

  B. Placeholders within PDO prepared statements need to be named.

  C. When something goes wrong, PDO can throw an instance of its own exception class.

  D. PDO does not emulate missing database features.

  Correct Answer: B

• Question 49:

  What would be the output of the following code?

  namespace MyFramework\DB;

  class MyClass {

  static function myName() {

  return __METHOD__;

  }

  }

  print MyClass::myName();

  A. MyFramework\DB\myName

  B. MyFramework\DB\MyClass\myName

  C. MyFramework\DB\MyClass::myName

  D. MyClass::myName

  Correct Answer: C

• Question 50:

  Which parts of the text are matched in the following regular expression?

  $text = <<

  The big bang bonged under the bung.

  EOT;

  preg_match_all('@b.n?g@', $text, $matches);

  A. bang bong bung

  B. bang bonged bung

  C. big bang bong bung

  D. big bang bung

  Correct Answer: C