But then I came up with a question (probably very silly), what if this wallet.dat file is manually being deleted, is there any backup itself ?
Bitcoin Core does not make any automated backups. You need to either backup the wallet.dat file yourself (but only when Bitcoin isn't running), or use the Backup Wallet option in the menu. Backups should be created at least once for every 100 new receiving addresses created.
Some clients do perform automated backups (of course, backups to the same hard drive aren't all that useful...):
- Armory maintains one backup file.
- MultiBit Classic creates new backup files after each new receiving address is created.
- Blockchain.info by default keeps a local backup in addition to encrypted wallet stored on their servers, and they have options for other types of off-site backups as well.
- Armory and Electrum, being deterministic, both have backup-to-paper options which only need be done once at wallet creation.