Zend ZF-100-500 ZF-100-500 Exam Practice Test

Which of the following is an example of a database connection that needs to be created once at the beginning of a script and then used throughout its code?

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.

Which component is used to offer an API to manipulate dates and times?

Which of the following is used for separation of hierarchies in Zend_config_Ini file?

You have given the following XML data in the tasks.XML file:

<?xml version="1.0" encoding="ISO-8859-1"?>

Validate data

Secure data

Now, you run the following PHP script:

<?php

$objDOM = new DOMDocument();

$objDOM->load("tasks.xml");

$note = $objDOM->getElementsByTagName("note");

foreach( $note as $value )

{

$tasks = $value->getElementsByTagName("tasks");

$task = $tasks->item(0)->nodeValue;

$details = $value->getElementsByTagName("details");

$detail = $details->item(0)->nodeValue;

echo "$task :: $detail
";

}

?>

What should be displayed when this script is executed?

Which of the following functions can you use to mitigate a command injection attack? Each correct answer represents a complete solution. Choose all that apply.

Which of the following are the limitations for the cross site request forgery (CSRF) attack?

Each correct answer represents a complete solution. Choose all that apply.

Angela works as a Database Administrator for AznoTech Inc. She writes the following query:

SELECT Dept_Name, Emp_Name

FROM Departments d1, Employees e1

WHERE d1.Dept_No = e1.Dept_No

ORDER BY Dept_Name, Emp_Name;

Which of the following joins is used in this query?

Which of the following will NOT display the value of $debug_variable? Each correct answer represents a complete solution. Choose all that apply.

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

Which of the following are the valid methods of the Zend_Date class? Each correct answer represents a complete solution. Choose all that apply.

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 code snippets will you use to destroy a log if the variable $logger contains the log record?

Fill in the blank with the appropriate PHP function. The___________ function is used to return the sum of the values of every entry within an array.

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

Which of the following methods will you use to retain the identity across requests according to the PHP session configuration?

Symonds works as a Database Administrator for Blue Well Inc. The company uses an Oracledatabase. The database contains a table named Employees. Following is the structure of the table:

EmployeeID NUMBER (5) PRIMARY KEY EmployeeName VARCHAR2 (35) NOT NULL Salary NUMBER (9, 2) NOT NULL Commission NUMBER (4, 2)

DepartmentID NUMBER (5)

Symonds queries the Employees table with the following statement:

SELECT e.EmployeeName, m.Salary

FROM Employees e, Employeesm

WHERE e.EmployeeID = m.EmployeeID;

Which of the following types of joins is used in the statement?

Fill in the blank with the appropriate method name. The__________ method is used to send an email in the HTML format.

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