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?

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?

Which of the following statements correctly explain the working of Zend_Serach_Lucene?
Each correct answer represents a complete solution. Choose all that apply.

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

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 table 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?

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

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?

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

Fill in the blank with the appropriate method name.
The__________ method is used to convert an existing money value to a localized currency

formatted output.

Fill in the blank with the appropriate PHP function.
The___________ function is used to return the sum of the values of every entry within an array.