What is data partitioning and how does it help avoid full table scans?
Types of JOINs and their differences
What is a CROSS JOIN and what is its result?
What is a data storefront?