Zend 100-500 Exam Questions Free Practice Test

Viewing page 6 out of 6 pages

Viewing questions 51-60 out of questions

Questions # 51:

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

Options:

getIdentity()

getCode()

isValid()

getMessages()

Expert Solution

Questions # 52:

You work as a Database Administrator for Dolliver Inc. The company uses an Oracle database. The database contains two tables, named Employees and Departments. You want to retrieve all matched and unmatched rows from both the tables. Which of the following types of joins will you use to accomplish this?

Options:

FULL OUTER JOIN

LEFT OUTER JOIN

RIGHT OUTER JOIN

CROSS JOIN

Expert Solution

Questions # 53:

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 of the following SELECT statements will Martin use to create the report?

Options:

SELECT Product_No, Prod_Category

FROM Products;

SELECT DISTINCT Product_No, Prod_Category

FROM Products;

SELECT Product_No, Prod_Category

FROM Products

GROUP BY Product_No;

SELECT Product_No, Prod_Category

FROM Products

GROUP BY Product_No ORDER BY Product_No;

Expert Solution

Questions # 54:

Symonds works as a Database Administrator for Blue Well Inc. The company uses an Oracle database. 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?

Options:

Outer join

Equijoin

Cross join

Self join

Expert Solution

Questions # 55:

Fill in the blank with the appropriate method name.

The________ method is used to check whether a date is valid or not.

Options:

isDate()

Expert Solution

Questions # 56:

Which of the following is a common feature of the Front Controller plugins and Action Helpers?

Options:

Scope of layout variables

preDispatch() and postDispatch() hooks

Isolation of layout view script from other view scripts

Rendering of the layout

Expert Solution

Questions # 57:

Which of the following inherits from Zend_Log_Writer_Abstract and is responsible for saving data to storage?

Options:

Filter

Writer

Formatter

Log

Expert Solution

Questions # 58:

Which of the following code snippets will you use if you want to connect to a Pop3 server using TLS?

Options:

<?php

$mail = new Zend_Mail_Storage_Pop3(array('host'

='example.com', 'user' ='user_name',

'protocol_used' = 'tls')); ?>

<?php

$mail = new Zend_Mail_Storage_Pop3(array('host'

='example.com', 'user' ='user_name',

'connectTo' = 'tls')); ?>

<?php

$mail = new Zend_Mail_Storage_Pop3(array('host'

='example.com', 'user' ='user_name',

'protocol_used' = 'ssl/tls')); ?>

<?php

$mail = new Zend_Mail_Storage_Pop3(array('host'

='example.com', 'user' ='user_name',

'ssl' = 'tls')); ?>

Expert Solution

Questions # 59:

Which of the following are the configuration files that are used in Zend_Config?

Options:

Zend_Config_Server

Zend_Config_Xml

Zend_Config_Db

Zend_Config_Ini

Expert Solution

Questions # 60:

You have created a table based on the following data:

EmpID NUMBER (5) PRIMARY KEY

EmpName VARCHAR2 (35) NOT NULL

Salary NUMBER (9, 2) NOT NULL

Commission NUMBER (4, 2)

ManagerName VARCHAR2 (25)

ManagerID NUMBER (5)

Now, you want to 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.

Options:

SELECT e.EmpName, m.ManagerName

FROM Employees e, Employeesm

WHERE e.EmpID = m.ManagerID;

SELECT e.EmpName, m.ManagerName

FROM Employees e SELF JOIN Employeesm

ON e.EmpID = m.ManagerID;

SELECT e.EmpName, m.ManagerName

FROM Employees e INNER JOIN Employeesm

ON e.EmpID = m.ManagerID;

SELECT e.EmpName, m.ManagerName

FROM Employees e LEFT OUTER JOIN Employees m

ON e.EmpID = m.ManagerID;

Expert Solution

Viewing page 6 out of 6 pages

Viewing questions 51-60 out of questions

Pass the Zend Zend Certification 100-500 Questions and answers with CertsForce