Clustox interview question

Databases/ OS - Process vs threads - Inner Join vs Left Join - Transactions and its properties - Deadlock? How to resolve