Anaqua interview question

Explain joins, triggers, views, reporting in SQL server, some behavioral questions