Explain an outer join ?

COBOL SQL Interview Questions

(Continued from previous question...)

Explain an outer join ?

An outer join includes rows from tables when there are no matching values in the tables.

(Continued on next question...)

Other Interview Questions

• What is an image copy?
• What is a Cartesian product?
• What is a synonym? How is it used
• What is a NULL value? What are the pros and cons of using NULLS ?
• What is the result of this query if no rows are selected: SELECT SUM(SALARY) FROM EMP WHERE QUAL='MSC'; ?
• Explain an outer join ?
• Why SELECT * is not preferred in embedded SQL programs ?
• What is a NULL value? What are the pros and cons of using NULLS ?
• What is a correlation name?
• What is a foreign key?
• More...