https://forum.lowyat.net/topic/5041467/+4

https://forum.lowyat.net/topic/4309490/+3644 if making this kind of hole in wall you need rotary hammer.

If your ceiling light hole just a 20c coin in plaster ceiling any drill also can.

[attachmentid=10722432] this is how they normally construct high rise (with concrete floor slab).

Oh on the floor slab (concrete slab).
Then recommend to get rotary hammer. Rotary hammer drill for wall plug very easy 5 second per hole effortless. Normal drill / impact drill will take u forever like 5min per hole while user pressing body weight into the drill.

Elcheapo ones from Mr DIY overheat fast and thus may not be that great if need to wait long long for it to cool off if you need like 40-50 holes done in one shot. Coz I think you would probably be installing more than one light.

Cheap decent rotary hammer one can get the Daewoo as shown by hirano post which I just replied to earlier this morning. https://forum.lowyat.net/index.php?showtopi...post&p=99245906

One step up is those from bigger name Stanley Hikoki Bosch Makita.
Usually cheaper to get wired tool with just the rotary hammer. Bits you won't need whole collection of them for wall plug, 5.5/6mm for #8,#10 wall plugs shud be standard and will cover most wall plug. #12 wall plug need something bigger like 6.5mm bit (this is not so commonly used IMO). For sleeve anchor aka tv bracket you can then pick up the necessary 10mm or 12mm bit later on.

For wood or metal these no need impact or hammering so chuck adapter (for smooth round shank convert to SDS plus) needed ya. This adapter 10-20 bucks only.