Birlasoft Interview Question

about sql server 2005