Cognizant Interview Question

Simple questions on SQL joins