Zend ZF-100-500 Questions & Answers

• Question 91:

  Which of the following joins retrieves all rows from one table and only the matching rows from the joined table?

  A. Self join

  B. Outer join

  C. Equijoin

  D. Non-equijoin

  Correct Answer: B

• Question 92:

  Which of the following statements describes the use of a GROUP BY clause?

  A. A GROUP BY clause returns a single row of information for each group of rows.

  B. A GROUP BY clause automatically sorts the grouped result in ascending order, if DESCkeyword is not defined.

  C. A GROUP BY clause returns a single row of information for each group of rows, inaddition to all the rows.

  D. A GROUP BY clause automatically sorts the grouped result in descending order.

  Correct Answer: A

• Question 93:

  You are using a database named HumanResource. You have to delete some tables from the database using SQL statements. Which of the following statements will you use to accomplish the task?

  A. DELETE TABLE FROM DATABASE

  B. DELETE TABLE

  C. DROP TABLE

  D. DROP TABLE FROM DATABASE

  Correct Answer: C

• Question 94:

  Which of the following functions is the best choice to retrieve the fingerprint of a string?

  A. md5()

  B. fingerprint()

  C. crypt()

  D. hash()

  Correct Answer: A

• Question 95:

  Which of the following steps will you use to create a multi -lingual Website? Each correct answer represents a complete solution. Choose all that apply.

  A. Creating the View and integrate Zen d_Translate into the code

  B. Deciding which adapter to use

  C. Translating the source file to the desired language

  D. Putting the Zend_Translate into session

  E. Creating the source file from the code

  Correct Answer: ABCE

• Question 96:

  Which of the following retrieves the request URI, path, $_GET and $_POST parameters, etc. and tracks whether an action has been dispatched via Zend_Controller_Dispatcher?

  A. Zend_Controller_Get_Request

  B. Zend_Controller_Router

  C. Zend_Controller_Request_Abstract

  D. Zend_Controller_Response_Abstract

  Correct Answer: C

• Question 97:

  Which of the following functions in SimpleXML can be used to return an iterator containing a list of all subnodes of the current node?

  A. asXML()

  B. attributes()

  C. getName()

  D. children()

  Correct Answer: D

• Question 98:

  CORRECT TEXT

  Fill in the blank with the appropriate method name. ________is a method to create REST server.

  A. Zend_Rest_Server

  Correct Answer: A

• Question 99:

  Which of the following can be used as a countermeasure against the SQL injection attack? Each correct answer represents a complete solution. Choose two.

  A. session_regenerate_id()

  B. Prepared statement

  C. mysql_escape_string()

  D. mysql_real_escape_string()

  Correct Answer: BD

• Question 100:

  Which of the following statements correctly explains the behavior of Zend_Controller_Front? Each correct answer represents a complete solution. Choose all that apply.

  A. It registers a plug-in broker with itself.

  B. It uses the Singleton pattern.

  C. It processes all requests received by the server.

  D. The Zend_Controller_Front never loads any plugin by default.

  Correct Answer: ABC