Which of the following methods is triggered when a dispatched action is done even if
apreDispatch() plugin has skipped the action and is mainly useful for cleanup?

Consider the PHP program (which includes a file specified by request):
<code>
<?php
$color = ‘blue’;
if (isset( $_GET[‘COLOR’] ) )
$color = $_GET[‘COLOR’];
require( $color . ‘.php’ );
?>
<form method=”get”>
<select name=”COLOR”>
<option value=”red”>red</option>
<option value=”blue”>blue</option>
</select>
<input type=”submit”>
</form>
</code>
A malicious user injects the following command:
<code>
/vulnerable.php?COLOR=C:\\notes.txt%00
</code>
Where vulnerable.php is a remotely hosted file containing an exploit. What does the malicious
user want to do?

What will be the output of the following PHP script?

<code>
<?php include(“xml.inc”);
if (!$dom = domxml_open_mem($xmlstr)) {
echo “Error while parsing the XML document \n”;
exit;
}
$a = $dom->document_element();
print_r($a);
?>
</code>

Which of the following methods are run by the Zend_Controller_Front::run($path) method at a
time? Each correct answer represents a complete solution. Choose all that apply.

Which of the following methods can be used to verify the authentication and ACLs prior to an
action?

Which of the following methods sends log data to a PHP stream?

Martin works as a Database Administrator for MTech Inc. He designs a database that has a table
named Products. He wants to create a report listing different product categories. He does not want
to display any duplicate row in the report. Which o f the following SELECT statements will Martin
use to create the report?

Angela works as a Database Administrator for AznoTech Inc. She writes the following query:
<code>
SELECT Dept_Name, Emp_Name
FROM Departments d1, Employees e1
WHERE d1.Dept_No = e1.Dept_No
ORDER BY Dept_Name, Emp_Name;
</code>
Which of the following joins is used in this query?

Which of the following statements correctly explain the working of Zend_Sera ch_Lucene?
Each correct answer represents a complete solution. Choose all that apply.

Ross creates a database for a school. He creates two tables named Students and Courses.
Which of the following SELECT statements will he use to define an outer join?