Mechanical response of double-stranded DNA to dynamic excitation