New Year Special 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: bestdeal

Free Zend ZF-100-500 Practice Exam with Questions & Answers

Questions 1

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

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

<tasklist>

<note>

<tasks>Validate data

<details>String Validation

</note>

<note>

<tasks>Secure data

<details>Encryption</details>

</note>

</tasklist>

Now, you run the following PHP script:

$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?

Options:
A.

The contents of the whole XML document

B.

The XML of every tasks and details nodes

C.

The contents of every tasks and details nodes

D.

The XML of whole XML document

Zend ZF-100-500 Premium Access
Questions 2

You are using a database named HumanResource. You have to delete some tables from the database using SQL statements. Which of the following statements will you use to accomplish the task?

Options:
A.

DELETE TABLE FROM DATABASE

B.

DELETE TABLE

C.

DROP TABLE

D.

DROP TABLE FROM DATABASE

Questions 3

Consider the following script:

<html>

<head>

<title>

This is a test script.

</title>

</head>

<body>

echo 'This is some sample text';

?>

</body>

</html>

Which of the following tags is used in the php script?

Options:
A.

ASP tag

B.

Short tag

C.

Script tag

D.

Standard tag

Questions 4

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

Options:
A.

echo Zend_Debug::dump($debug_variable, 'debug_variable', false);

B.

print(Zend_Debug::dump($debug_variable, 'd ebug_variable', true));

C.

ob_start(); Zend_Debug::dump($debug_variable, 'debug_variable', false); ob_end_flush();

D.

Zend_Debug::dump($debug_var iable, 'debug_variable', true);

Questions 5

Which of the following joins retrieves all rows from one table and only the matching rows from the joined table?

Options:
A.

Self join

B.

Outer join

C.

Equijoin

D.

Non-equijoin

Questions 6

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

Options:
Questions 7

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.

Options:
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;

Questions 8

Which property is used to operate the memory object data?

Options:
A.

object

B.

data

C.

method

D.

value

Questions 9

You have a table created as follows:

create table foo (c1int, 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

Options:
A.

create unique index foox on foo (c1) include (c3)

B.

create index foox on foo (c1)

C.

create index foox on foo (c1,c3)

D.

create unique index foox on foo (c1,c3)

Questions 10

Maria writes a query that uses outer join between two tables. Which of the following operators are not allowed in the query? Each correct answer represents a complete solution. Choose two.

Options:
A.

OR

B.

IN

C.

=

D.

AND

Exam Code: ZF-100-500
Certification Provider: Zend
Exam Name: Zend Framework CertificationVersion 4.0
Last Update: Mar 28, 2025
Questions: 128

Zend Related Exams

How to pass Zend 200-500 - Zend PHP 5 Certification Exam
How to pass Zend 200-530 - Zend PHP 5.3 Certification Exam
200-710 - Zend Certified Engineer
200-550 - Zend Certified PHP Engineer
Zend Free Access
Get Zend Full Access

Zend Free Exams
Zend Free Exams
Enhance your Zend exam prep with free resources and practice tests from Examstrack. Achieve Zend certification success by exploring Examstrack.