Just to keep this at one of the most simplistic level, your common house lamp is basically a flip and close down deal.
Low voltage lights are also for you to install. The yellow light simply takes advantage of the locations human and insect eyes. https://www.Trademama.com/light-motion-sensor/suppliers.html