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

Page 15 of 33

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

  1. isDate()

Answer(s): A



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.

  1. SELECT e.EmpName, m.ManagerName
    FROM Employees e, Employeesm
    WHERE e.EmpID = m.ManagerID;
  2. SELECT e.EmpName, m.ManagerName
    FROM Employees e SELF JOIN Employeesm
    ON e.EmpID = m.ManagerID;
  3. SELECT e.EmpName, m.ManagerNam e
    FROM Employees e INNER JOIN Employeesm
    ON e.EmpID = m.ManagerID;
  4. SELECT e.EmpName, m.ManagerName
    FROM Employees e LEFT OUTER JOIN Employees m
    ON e.EmpID = m.ManagerID;

Answer(s): A,C



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

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

Answer(s): A,C,D



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?

  1. FULL OUTER JOIN
  2. LEFT OUTER JOIN
  3. RIGHT OUTER JOIN
  4. CROSS JOIN

Answer(s): A






Post your Comments and Discuss Zend ZF-100-500 exam with other Community members:

ZF-100-500 Discussions & Posts