Ab-initio studies of electronic and spectroscopic properties of MgO, ZnO and CdO