Deleting a category from WordPress admin does it remove it completely from the database?

Yes, the categories are stored in wp_terms table which contains the term_id, name and slug. Deleting the category in admin panel removes the three values along with it.

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)