Zend ZF-100-500 Online Practice Questions and Exam Preparation

Zend ZF-100-500 Online Questions & Answers

• Question 91:

  Which of the following code segments can be used to check the form validity?

  A. if (Zend_Form::isValid($_Post)) { // success! } else { // failure! }
  B. if (Zend_Form->isValid($form)) { // success! } else { // failure! }
  C. if ($form->isValid($_POST)) { // success! } else { // failure! }
  D. if (Zend_Form::isValid($form)) { // success! } else { // failure! }
  C. if ($form->isValid($_POST)) { // success! } else { // failure! }

• Question 92:

  You want to get the information of total number of documents stored in the index. You also want to include the deleted documents. Which of the following methods will you use to accomplish the task?

  A. $search_index::count_document();
  B. $search_index::count();
  C. $search_index->count();
  D. $search_index->docCount();
  C. $search_index->count();

• Question 93:

  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?

  A. Outer join
  B. Equijoin
  C. Cross join
  D. Self join
  D. Self join

• Question 94:

  Which of the following methods dynamically loads the Adapter class file on demand using Zend_Loader::loadClass()?

  A. Zend_Db_Adapter_Pdo_Mysql()
  B. Zend_load_Adaptor()
  C. fetchAll()
  D. Zend_Db::factory()
  D. Zend_Db::factory()

• Question 95:

  You have been given the following PHP script:

  1.

  2.

  $xmlstring = <<

  3.

  4.

  5.

  [email protected]

  6.

  [email protected]

  7.

  Technical issue in Linux OS

  8.

  There is a technical issue in my Linux system. Please Fix it.

  9.

  10.

  XML;

  11.

  $xml = new SimpleXMLElement($xmlstring);

  12.

  foreach($xml->children() as $child)

  13.

  {

  14.

  15.

  }

  16.

  ?>

  Which of the following code snippets will you insert at line number 14 to get the following output?

  A. echo $child->getNamespaces() . ": " . $child . "";
  B. echo $child->getDocNamespaces() . ": " . $child . "";
  C. echo $child->getName() . ": " . $child . "";
  D. echo $child->asXML() . ": " . $child . "";
  C. echo $child->getName() . ": " . $child . "";

• Question 96:

  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 NULLSalary NUMBER (9, 2) NOT NULL Commission NUMBER (4, 2) ManagerNameVARCHAR2 (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.ManagerName FROM Employees e SELF JOIN Employeesm ON e.EmpID = m.ManagerID;
  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;

• Question 97:

  CORRECT TEXT

  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.

  A. toCurrency()
  A. toCurrency()

• Question 98:

  You are using a database named SalesDB to keep all sales records. The SalesDB database contains a table named Orders. You are required to create a new t able named OldOrders and transfer all the data from the Orders table to the new table. Which of the following statements will you use to accomplish the task?

  A. IMPORT INTO
  B. INSERT INTO
  C. ADD INTO
  D. SELECT INTO
  D. SELECT INTO

• Question 99:

  Which of the following can be used as a countermeasure against the SQL injection attack? Each correct answer represents a complete solution. Choose two.

  A. session_regenerate_id()
  B. Prepared statement
  C. mysql_escape_string()
  D. mysql_real_escape_string()
  B. Prepared statement
  D. mysql_real_escape_string()

• Question 100:

  Which of the following error constants gives all errors and warnings, except the E_STRICTerror level?

  A. E_RECOVERABLE_ERROR
  B. E_ALL
  C. E_ERROR
  D. E_WARNING
  B. E_ALL