Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

Which of the following is the method that is used to check whether the version required for running the application exists or not?

A.

Zend_Version::VERSION

B.

$var = Zend_Version->compareVersion($version)

C.

Zend_Version::compareVersion($version)

D.

Zend_compareVersion($version)

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

A.

Zend_Config_Server

B.

Zend_Config_Xml

C.

Zend_Config_Db

D.

Zend_Config_Ini

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 NULL

Salary NUMBER (9, 2) NOT NULL

Commission NUMBER (4, 2)

ManagerName VARCHAR2 (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;

Which of the following code snippets will you use to destroy a log if the variable $logger contains the log record?

A.

remove($logger);

B.

$logger=null;

C.

delete($logger);

D.

$logger->null;

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();

Which of the following code snippets will you use to create a transport while considering the following PHP code segment?

require_once 'Zend/Mail.php';

require_once 'Zend/Mail/Transport/Smtp.php';

??????????????????????????????????

for ($i = 0; $i > 5; $i++) {

$mail = new Zend_Mail();

$mail->addTo('someone@example.com', 'Test');

$mail->setFrom(' someone@example.com', 'Test');

$mail->setSubject('Multiple Mails');

$mail->setBodyText('Messages');

$mail->send($transport);

}

A.

$transport = new transport();

B.

$transport = new Zend_Mail_Transport_Smtp('localhost');

C.

$transport = new Zend_Mail_Transport('localhost');

D.

$transport -> new Zend_Mail_Transport;

Which of the following code snippets will you use to instantiate Zend_XmlRpc_Server?

A.

$server = Zend_Xml::Zend_XmlRpc_Server()

B.

$server = new Zend_Xml();

C.

$server = create_new_Zend_XmlRpc_Server()

D.

$server = new Zend_XmlRpc_Server();

Which of the following functions in SimpleXML can be used to return an iterator containing a list of all subnodes of the current node?

A.

asXML()

B.

attributes()

C.

getName()

D.

children()

Which of the following clauses is used to specify a column or an array of columns by which to sort?

A.

Order By

B.

WHERE

C.

FROM

D.

LIMIT

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?

A.

SELECT DISTINCT Product_No, Prod_Category

FROM Products;

B.

SELECT Product_No, Prod_Category

FROM Products;

C.

SELECT Product_No, Prod_Category

FROM Products

GROUP BY Product_No ORDER BY Product_No;

D.

SELECT Product_No, Prod_Category

FROM Products

GROUP BY Product_No;