Dayforce interview question

What is deadlock? What is inner join(SQL question)?