Banks have different variants of current accounts. If the type of current account that you choose doesn’t come with a debit card then you may not get a card. This is purely at the discretion of the respective bank.
Yes, banks provide you with a checkbook.