Zend Framework Certification - ZF-100-500 Exam Practice Test

Question 1

Which of the following error constants gives all errors and warnings, except the E_STRICT error level?

A. E_ALL

B. E_ERROR

C. E_RECOVERABLE_ERROR

D. E_WARNING

Correct Answer: A

Question 2

Which of the following clauses is used to specify a column or an array of columns by which to sort?

A. LIMIT

B. Order By

C. FROM

D. WHERE

Correct Answer: B

Question 3

Which of the following code snippets will you use to instantiate Zend_XmlRpc_Server?

A. $server = Zend_Xml::Zend_XmlRpc_Server()

B. $server = new Zend_XmlRpc_Server();

C. $server = create_new_Zend_XmlRpc_Server()

D. $server = new Zend_Xml();

Correct Answer: B

Question 4

Which of the following statements describe s 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 returns a single row of information for each group of rows, in addition to all the rows.

C. A GROUP BY clause automatically sorts the grouped result in ascending order, if DESC keyword is not defined.

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

Correct Answer: A

Question 5

Fill in the blank with the appropriate PHP function. The_____________ function is used to replace the current session id with the new session id, and to keep information of the current session.

A. session_regenerate_id()

Correct Answer: A

Question 6

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 of the following SELECT statements will Martin use to create the report?

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

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

C. SELECT Product_No, Prod_Category
FROM Products;

D. SELECT DISTINCT Product_ No, Prod_Category
FROM Products;

Correct Answer: D

Question 7

Fill in the blank with the appropriate PHP function. The____________ function is used to replace the current session id with the new session id, and to keep information of the current session.

A. session_regenerate_id()

Correct Answer: A

Question 8

Symonds works as a Database Administrato r for Blue Well Inc. The company uses an Oracle database. The database contains a table named Employees. Following is the structure of the table: EmployeeID NUMBER (5) PRIMARY KEY EmployeeName VARCHAR2 (35) NOT
NULL Salary NUMBER (9, 2) NOT NULL Commission NUMBER (4, 2)
DepartmentID NUMBER (5)
Symonds queries the Employees table with the following statement:
SELECT e.EmployeeName, m.Salary
FROM Employees e, Employeesm
WHERE e.EmployeeID = m.EmployeeID;
Which of the following types of joins is used in the statement?

A. Cross join

B. Outer join

C. Self join

D. Equijoin

Correct Answer: C

Question 9

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

A. Zend_Log_Writer_Filestream

B. Zend_Log_Writer_Abstract

C. Zend_Log_Writer_Stream

D. Zend_Log_Writer_Db

Correct Answer: C

Zend-Technologies Zend Framework Certification - ZF-100-500 Exam Practice Test

Latest Update

Useful Links

Contact Us