Microsoft Interview Question

Write a complete SQL trigger and discuss whether it is optimized.