Is the nikon z 40mm f 2 good in low light?

Here is what the site says about that.

From Nikon Z 40mm f/2: Nikon Z 40mm f/2: A prime lens by Nikon for Full frame cameras, 40mm f/2. Small, cheap and good: Nikon's everyday prime. Specs - Maker: Nikon - Focal length: 40mm (prime) - Maximum aperture: f/2 - Made for: Full frame sensors - Mounts: Nikon Z - Stabilised: no - Autofocus: yes What it frames like - On full frame (Nikon Z): as marked, 40mm. - On APS-C (Nikon Z): like 60mm on full frame; ...

From Nikon Z 35mm f/1.2 S: Nikon Z 35mm f/1.2 S: A prime lens by Nikon for Full frame cameras, 35mm f/1.2. A large, very fast 35mm for low light and shallow focus.

Quoted from this site's pages.