Passwords and Security

I have a question regarding passwords. How are they stored in the database. How easy would it be to a) get to them, b) to decrypt them if someone where to be able to dump the db and gain access?