You have a table created as follows:

create table foo (c1 int, c2 char(30), c3 int, c4 char(10))

If column c1 is unique, which of the following indexes would optimize the statement given below?

Select distinct (c1), c3 from foo where c1=10

Consider the following code segment:

1. < ?php

2. require_once ' Zend/Mail.php ' ;

3. ?????????????????????????

4. $mail- > setBodyText( ' This is the test email. ' );

5. $mail- > setFrom( ' somebody@example.com ' , ' Sender ' );

6. $mail- > addTo( ' somebody_else@example.com ' , ' Recipient ' );

7. $mail- > setSubject( ' TestSubject ' );

8. $mail- > send();

9. ? >

Which of the following code snippets will you use at line number 3 to initiate Zend_Mail?

Which of the following methods are used by Zend_Controller_Action_Helper_Abstract?

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

Which method is used to store the cache records into a SQLite database?

You want to set the form method in post and action to /uc/zend.php when you are using the Zend_Form class. Which of the following code snippets will you use to accomplish the task?

Which of the following functions can be used as a countermeasure to a Shell Injection attack?

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

Which one of the following is used to manage the data within a memory-limited environment?

You want to record the raw log data received in an array exposed as a public property. Which of the following will you use to accomplish the task?

Fill in the blank with the appropriate method name.

The__________ method is used to convert an existing money value to a localized currency formatted output.

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.