While I haven't heard the term "deadly ceiling" used with wreck diving, *any* ceiling could be accurately described as "deadly" under the right circumstances. In wrecks, you can get lost - this can happen within a few feet of an exit if you have a total silt-out, and has claimed several divers over the years. You can get stuck. This too can happen within a few feet of - or even at - the exit. A specific "deadly ceiling" may be referring to the case where your bubbles cause a silt-out behind you as you go, so when you turn around you are greeted with a very unpleasant and potentially fatal surprize.
Bottom line - overhead environments are *not* included in open water training at any level. Open water instructors have died a few feet inside caves because they lacked overhead environment training. If you are contemplating going inside wrecks or caves or doing extended range (anything other than open water less than 130' within "no decompression" limits) then take the course for it.
Rick