Giriraj Digital interview question

difference between select & select many? store Procedure vs view