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

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?

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

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

You want to record the raw log data received in an array exposed as a public property. Which of
the following will you use to accomplish the task?

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

Which of the following will NOT display the value of $debug_variable? Each correct answer
represents a complete solution. Choose all that apply.

Fill in the blank with the appropriate term. __________is used to implement a classic Two-Step
View pattern that allows a user to wrap the application content within another view.

A table named employees is given below:

Which of the following statements would return the employees names , in ascending order, based
on their last name and first name? Each correct answer represents a complete solution. Choose
all that apply.

Which of the following code snippets will you use to destroy a log if the variable $logger contains
the log record?