The materia will be removed and lost. You materia will not be returned to your inventory, and there is no "are you sure?" screen. Have to admit, I was a little surprised the first time I did it. I'm just glad it was only one tier II materia.