Like Mr. wrxz says, for strength AND heat resistance, JB Weld.
But nose cones are not subjected to that much of a heat soak, so most epoxies would be fine. They may have a high-temp spike for a few milliseconds, but not enough to effect the chemistry.
What strengthens the joint are the amendments (e.g., things you add to the epoxy; such as milled fiber, chopped carbon, fumed silica, Kevlar, even saw dust, etc.) that give it strength. That's because epoxy by itself is quite brittle.
I use JB Weld, Loctite 5-Minute, and Aeropoxy laminating and adhesive epoxies. Which one of those I use depends upon the application - "The right tool for the right job".
Greg