State Street Interview Question

asked about sql fundamentals; use of rollback segments etc