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.

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?

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

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

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

You have created a table based on the following data:
EmpID NUMBER (5) PRIMARY KEY
EmpName VARCHAR2 (35) NOT NULL
Salary NUMBER (9, 2) NOT NULL
Commission NUMBER (4, 2)
ManagerName VARCHAR2 (25)
ManagerID NUMBER (5)
Now, you want to 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.

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

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?

You want to get the information of total number of documents stored in the index. You also want to
include the deleted documents. Which of the following methods will you use to accomplish the
task?

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?