What happens to uploaded files if the associated record is deleted

What happens to uploaded files if the associated record is deleted

Hi,

if there is a record that has a file uploaded with it, what happens to the file when the record is deleted? Does it remain in the database and if so how would it be accessed?

thanks

Kevin