Zend ZF-100-500 Questions & Answers

• Question 41:

  Which of the following types of content is expected by Zend_Rest_Client when using a RESTservice?

  A. JSON

  B. HTML

  C. Simple text

  D. XML

  Correct Answer: D

• Question 42:

  Which of the following methods will you use to create movable objects?

  A. Zend_Memory_Manager::createLocked([$data])

  B. Zend_Memory_Manager::create([$data])

  C. getMemoryLimit()

  D. setMemoryLimit($newLimit)

  Correct Answer: B

• Question 43:

  Ross creates a database for a school. He creates two tables named Students and Courses. Which of the following SELECT statements will he use to define an outer join?

  A. SELECT Stud.Student_ID, Cou.Course_ID FROM Students Stud, Courses Cou WHERE Stud.Course_ID (+) = Cou.Course_ID;

  B. SELECT Stud.Student_ID, Cou.Course_ ID FROM Students Stud, Courses Cou WHERE Stud.Fees BETWEEN Cou.Min_Fees and Cou.Max_Fees;

  C. SELECT Stud.Student_ID, Cou.Course_ID FROM Students Stud, Courses Cou WHERE Stud.Course_ID = Cou.Course_ID;

  D. SELECT Stud.Student_ID, Cou.Course_ID FROM Students Stud, Courses Cou WHERE Stud.Student_ID = Cou.Course_ID;

  Correct Answer: A

• Question 44:

  Which of the following statements correctly explain the working of Zend_Sera ch_Lucene?

  Each correct answer represents a complete solution. Choose all that apply.

  A. It supports ranked searching, phrase queries, wildcard queries, and proximity queries.

  B. It is a text search engine.

  C. It requires the Zend_Db class to connect to a database server.

  D. It can also be used to search by any specific field, such as, title, author, etc.

  Correct Answer: ABD

• Question 45:

  Which of the following are the features of Zend_Controller_Front? Each correct answer represents a complete solution. Choose all that apply.

  A. By default, the ErrorHandler plugin and ViewRenderer action helper plugin are loaded inZend_Controller_Front.

  B. It is used to register a plugin broker, which allows calling a user code when certainevents occurin controller process.

  C. It is used to implement the Singleton pattern.

  D. It is used to handle the request and output.

  Correct Answer: ABC

• Question 46:

  You are using a database named SalesDB to keep all sales records. The SalesDB database contains a table named Orders. You are required to create a new t able named OldOrders and transfer all the data from the Orders table to the new table. Which of the following statements will you use to accomplish the task?

  A. IMPORT INTO

  B. INSERT INTO

  C. ADD INTO

  D. SELECT INTO

  Correct Answer: D

• Question 47:

  Angela works as a Database Administrator for AznoTech Inc. She writes the following query:

  SELECT Dept_Name, Emp_Name

  FROM Departments d1, Employees e1

  WHERE d1.Dept_No = e1.Dept_No

  ORDER BY Dept_Name, Emp_Name;

  Which of the following joins is used in this query?

  A. Non-equijoin

  B. Outer join

  C. Equijoin

  D. Self join

  Correct Answer: C

• Question 48:

  Which of the following methods can be used to verify the authentication and ACLs prior to an action?

  A. preDispatch()

  B. getHelper()

  C. aunthicate_ACL()

  D. authenticate()

  Correct Answer: A

• Question 49:

  Which of the following methods sends log data to a PHP stream?

  A. Zend_Log_Writer_Stream

  B. Zend_Log_Writer_Filestream

  C. Zend_Log_Writer_Abstract

  D. Zend_Log_Writer_Db

  Correct Answer: A

• Question 50:

  Martin works as a Database Administrator for MTech Inc. He designs a database that has a table named Products. He wants to create a report listing different product categories. He does not want to display any duplicate row in the report. Which o f the following SELECT statements will Martin use to create the report?

  A. SELECT Product_No, Prod_Category FROM Products;

  B. SELECT DISTINCT Product_No, Prod_Category FROM Products;

  C. SELECT Product_No, Prod_Category FROM Products GROUP BY Product_No;

  D. SELECT Product_No, Prod_Category FROM Products GROUP BY Product_No ORDER BY Product_No;

  Correct Answer: B