Zend PHP 5.3 Certification Exam
Databases and SQL
Functions and Arrays
Object Oriented Programming
Data Format & Types
Strings and Patterns
Web Features 1
Which of the following joins will you use to display data that do not have an exact match in the column?
Answer option D is correct.
In non-equijoin, a query relates two tables using an operator other than the equality operator (=). As you have to display data that do not have an exact match in the column, you will use an operator other than the equality operator (=). Hence, you will use non-equijoin.
Answer option C is incorrect. Outer join returns all rows from one table and only the matching rows from the joining table.
Answer option B is incorrect. When a query relates two tables using an equality operator (=), it is known as inner join or equijoin.
Answer option A is incorrect. Self join is made on a single table. Each row of the table is combined with itself and with every other row of the table.
© 2013 Zend PHP Certification Exam