Zend Zend Certifications 200-550 Questions & Answers

• Question 71:

  Which of the following rules must every correct XML document adhere to? (Choose 2) A. It has to be well-formed.

  B. It has to be valid.

  C. It has to be associated to a DTD.

  D. It may only contain UTF-8 encoded characters.

  Correct Answer: AB

• Question 72:

  What DOMElement method should be used to check for availability of a non-namespaced attribute?

  A. getAttributeNS()

  B. getAttribute()

  C. hasAttribute()

  D. hasAttributeNS()

  Correct Answer: C

• Question 73:

  What method can be used to find the tag via the DOM extension?

  A. getElementById()

  B. getElementsByTagName()

  C. getElementsByTagNameNS()

  D. getElementByName()

  E. findTag()

  Correct Answer: B

• Question 74:

  An unbuffered database query will: (Choose 2)

  A. Return the first data faster

  B. Return all data faster

  C. Free connection faster for others scripts to use

  D. Use less memory

  Correct Answer: AD

• Question 75:

  Which technique should be used to speed up joins without changing their results?

  A. Add indices on joined columns

  B. Add a WHERE clause

  C. Add a LIMIT clause

  D. Use an inner join

  Correct Answer: A

• Question 76:

  Consider the following XML code:

  PHP 5.5 in 42 Hours

  Learning PHP 5.5 The Hard Way

  Which of the following SimpleXML calls prints the name of the second book? (Let $xml =

  simplexml_load_file("books.xml"); .) (Choose 2)

  A. echo $xml->books->book[2];

  B. echo $xml->books->book[1];

  C. echo $xml->book[1];

  D. echo $xml->xpath("/books/book[@id=2]");

  E. $c = $xml->children(); echo $c[1];

  Correct Answer: CE

• Question 77:

  Transactions should be used to: (Choose 2)

  A. Prevent errors in case of a power outage or a failure in the SQL connection

  B. Ensure that the data is properly formatted

  C. Ensure that either all statements are performed properly, or that none of them are.

  D. Recover from user errors

  Correct Answer: AC

• Question 78:

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

  Which of the following superglobals does not necessarily contain data from the client?

  A. $_POST

  B. $_SESSION

  C. $_GET

  D. $_SERVER

  Correct Answer: B

• Question 80:

  Which of the following statements is true?

  A. All PHP database extensions support prepared statements

  B. All PHP database extensions come with their own special helper functions to escape user data to be used in dynamic SQL queries

  C. All PHP database extensions provide an OOP interface

  D. All PHP database extensions appear in the output of php -m , if installed and enabled

  Correct Answer: D