Squla interview question

1. Database transaction 2. How to use select() on socket 3. How do I optimize a DB?