Is it possible for body to have its velocity and acceleration pointing in opposite directions?

Sure. Anything that's slowing down has velocity and acceleration in opposite directions.

-- A ball tossed up in the air has upward velocity and downward acceleration.

-- A car stopping for a red light has forward velocity and backward acceleration.