Calrom Interview Question

Explain Selects, Joins, in SQL Server, general OOP .NET (abstraction, encapsulation, etc.)