ZF-100-500 ZF-100-500 ZF-100-500 www.it-pruefungen.de
QUESTION 1
Fill in the blank with the appropriate PHP function. The_____________ function is used to replace the current session id with the new session id, and to keep information of the current session.
A. session_regenerate_id()
Answer: A
ZF-100-500 ZF-100-500 ZF-100-500
QUESTION 2
Celina works as a Database Administrator for Tech Mart Inc. The company uses an Oracle database. The database contains a table named Employees. Following is the structure of the table: 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) Celina wants to display the names of employees and their managers, using a self join. Which of the following SQL statements will she use to accomplish this? Each correct answer represents a complete solution.
Choose two.
A. SELECT e.EmpName, m.ManagerName
FROM Employees e, Employeesm
WHERE e.EmpID = m.ManagerID;
B. SELECT e.EmpName, m.ManagerName
FROM Employees e INNER JOIN Employeesm
ON e.EmpID = m.ManagerID;
C. SELECT e.EmpName, m.ManagerName
FROM Employees e LEFT OUTER JOIN Employees m
ON e.EmpID = m.ManagerID;
D. SELECT e.EmpName, m.Ma nagerName
FROM Employees e SELF JOIN Employeesm
ON e.EmpID = m.ManagerID;
Answer: AB
ZF-100-500 ZF-100-500 ZF-100-500
QUESTION 3
Which of the following actions may fail if you have exceeded your quota limit?
A. addTo()
B. send()
C. addBcc()
D. appendMessage()
Answer: D
