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?

Which of the following methods will you use to create movable objects?

Ross creates a database for a school. He creates two tables named Students and Courses.
Which of the following SELECT statements will he use to define an outer join?

Which of the following types of content is expected by Zend_Rest_Client when using a
RESTservice?

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 return the
sum of the values of every entry within an array.

Which of the following functions can you use to mitigate a command injection attack? Each correct
answer represents a complete solution. Choose all that apply.

Fill in the blank with the appropriate term. _______________is used to process all requests that
are received by the server and then dispatch them to the appropriate action controllers.

Which of the following functions will be called if there is an HTTP “404 Not Found” error?

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:
<code>
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;
</code>

Which of the following types of joins is used in the statement?