QUESTION: 57

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

isDate()

Answer(s): A

Reveal Solution Next Question

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

SELECT e.EmpName, m.ManagerName
FROM Employees e, Employeesm
WHERE e.EmpID = m.ManagerID;
SELECT e.EmpName, m.ManagerName
FROM Employees e SELF JOIN Employeesm
ON e.EmpID = m.ManagerID;
SELECT e.EmpName, m.ManagerNam e
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;

Answer(s): A,C

Reveal Solution Next Question

QUESTION: 59

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

It is the configuration of layout name, inflection, and path.
It can be used with ZF MVC components.
It is used to disable layouts and change scripts.
It has a separate scope for layout-related variables and content.

Answer(s): A,C,D

Reveal Solution Next Question

QUESTION: 60

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?

FULL OUTER JOIN
LEFT OUTER JOIN
RIGHT OUTER JOIN
CROSS JOIN

Answer(s): A

Reveal Solution Next Question

Free ZF-100-500 Exam Braindumps (page: 16)

QUESTION: 57

QUESTION: 58

QUESTION: 59

QUESTION: 60

ZF-100-500 Discussions & Posts