Zend ZF-100-500 Questions & Answers

• Question 71:

  You work as a Database Administrator for Dolliver Inc. The company uses an Oracle database. The database contains two tables, named Employees and Departments. You want to retrieve all matched and unmatched rows from both the tables. Which of the following types of joins will you use to accomplish this?

  A. FULL OUTER JOIN

  B. LEFT OUTER JOIN

  C. RIGHT OUTER JOIN

  D. CROSS JOIN

  Correct Answer: A

• Question 72:

  Which of the following OOPS design patterns is used to encapsulate a data source so that accessing the data source components becomes hidden within the class that implements the pattern?

  A. Registry

  B. ActiveRecord

  C. Model-view-controller

  D. Factory

  Correct Answer: B

• Question 73:

  CORRECT TEXT

  Fill in the blank with the appropriate method name. The________ method is used to check whether a date is valid or not.

  A. isDate()

  Correct Answer: A

• Question 74:

  You have created a table based on the following data:

  EmpID NUMBER (5) PRIMARY KEYEmpName VARCHAR2 (35) NOT NULL Salary NUMBER (9, 2) NOT NULL CommissionNUMBER (4, 2) ManagerName VARCHAR2 (25) ManagerID NUMBER (5) Now, you wantto display the names of

  employees and their managers, using a self join.

  Which of the following SQL statements can you use to accomplish this? Each correct answer represents a complete solution. Choose two.

  A. SELECT e.EmpName, m.ManagerName FROM Employees e, Employeesm WHERE e.EmpID = m.ManagerID;

  B. SELECT e.EmpName, m.ManagerName FROM Employees e SELF JOIN Employeesm ON e.EmpID = m.ManagerID;

  C. SELECT e.EmpName, m.ManagerNam e FROM Employees e INNER JOIN Employeesm ON e.EmpID = m.ManagerID;

  D. SELECT e.EmpName, m.ManagerName FROM Employees e LEFT OUTER JOIN Employees m ON e.EmpID = m.ManagerID;

  Correct Answer: AC

• Question 75:

  Which of the following modes is the default Fetch mode for Adapter classes and returns data in an associative array on which the keys are the column names?

  A. Zend_Db::FETCH_BOTH

  B. Zend_Db::FETCH_ASSOC

  C. Zend_Db::FETCH_OBJ

  D. Zend_Db::FETCH_COLUMN

  Correct Answer: B

• Question 76:

  Which of the following is an abstract class that is used to provide the basic interface and functionality required by the helper broker?

  A. Zend_Db

  B. Zend_Auth

  C. Zend_Acl

  D. Zend_Controller_Action_Helper_Abstract

  Correct Answer: D

• Question 77:

  Which of the following methods of Zend_Auth returns TRUE if and only if the result represents a successful authentication attempt?

  A. getIdentity()

  B. getCode()

  C. isValid()

  D. getMessages()

  Correct Answer: C

• Question 78:

  Which of the following steps will you take to apply Zend_View? Each correct answer represents a part of the solution. Choose all that apply.

  A. Transfer control of the display to the View Script.

  B. Render the View.

  C. Assign the variables to the View via a Controller Script.

  D. Create an instance of the View.

  Correct Answer: BCD

• Question 79:

  CORRECT TEXT

  Fill in the blank with the appropriate method name. _________is used to make call of the remote methods in the same manner as native methods.

  A. Zend_Rest_Client

  Correct Answer: A

• Question 80:

  Consider the following XML file:

  PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

  "http://www.w3.org/TR/xhtml1/DTD/xhtml1 -transitional.dtd">

  Please go http: //www.PassGuide.com

  
  

  Which of the following statements will display the HREF attribute on the anchor tag if the SimpleXML object is $sxml?

  A. $sxml->body->h1->a->href

  B. $sxml->body->h1->a

  C. $sxml->body->h1->a['href']

  D. $sxml->h1->a->href

  Correct Answer: C