Question No 1

Celina works as a Database Administrator for Tech Mart Inc. The company uses an Oracledatabase. The database contains a table named Employees. Following is the structure of thetable: EmpID NUMBER (5) PRIMARY KEY EmpName VARCHAR2 (35) NOT NULLSalary NUMBER (9, 2) NOT NULL Commission NUMBER (4, 2) ManagerNameVARCHAR2 (25) ManagerID NUMBER (5) Celina wants to display the names of employeesand their managers, using a self join. Which of the following SQL statements will she use toaccomplish this? Each correct answer represents a complete solution. Choose two.

Choose the Choices:

SELECT e.EmpName, m.ManagerName FROM Employees e, Employeesm WHERE e.EmpID = m.ManagerID;

SELECT e.EmpName, m.ManagerName FROM Employees e INNER JOIN Employeesm ON e.EmpID = m.ManagerID;

SELECT e.EmpName, m.ManagerName FROM Employees e LEFT OUTER JOIN Employees m ON e.EmpID = m.ManagerID;

SELECT e.EmpName, m.Ma nagerName FROM Employees e SELF JOIN Employeesm ON e.EmpID = m.ManagerID;

Question No 2

Which of the following actions may fail if you have exceeded your quota limit?

Choose the Choices:

Question No 3

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

Choose the Choices:

Question No 4

Write the appropriate word to complete the sentence below. ___________is used for logging ofmultiple backends, formatting messages which are sent to the log, and filtering those messages,which should not be logged.

Choose the Choices:

Question No 5

Which of the following is used to crea te a new Memory Manager?

Choose the Choices:

Practice Zend ZF-100-500 Exam Questions

Question No 1

Question No 2

Question No 3

Question No 4

Question No 5

ZF-100-500 Exam Features

ZF-100-500 PDF Dumps