Salesforce Interview Question

DB joins. Types? Sample query for few?