Zend
ZF-100-500 · Question #194
Symonds works as a Database Administrato r 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…
The correct answer is D. Self join. See the full explanation below for the reasoning.
Question
Symonds works as a Database Administrato r 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
- AOuter join
- BEquijoin
- CCross join
- DSelf join
How the community answered
(48 responses)- A2% (1)
- B6% (3)
- C13% (6)
- D79% (38)
Community Discussion
No community discussion yet for this question.