UBS interview question

Basic concepts about sql server