PrepAway - Latest Free Exam Questions & Answers

Category: ZF-100-500

Exam ZF-100-500: Zend Framework Certification

Which of the following SQL statements will she use to accomplish this?

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:
<code>
EmpID NUMBER (5) PRIMARY KEY EmpName VARCHAR2 (35) NOT NULLSalary NUMBER (9,
2) NOT NULL Commission NUMBER (4, 2) ManagerNameVARCHAR2 (25) ManagerID NUMBER (5)
</code>
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.


Page 11 of 13« First...910111213