If the parent note is deleted, all attachments associated with that note will also be deleted.
This includes:
Files uploaded directly within the note.
Files added through the Attachments tab, but linked to that note.