A police officer who made racist remarks during a night out has been dismissed.