Probing Lepton Number Violation and Majorana Nature of Neutrinos at the LHC