Neither, really. It means "working", in a technical sense.
"Don't use the old recorder, it isn't operative".
Something is either operative or not, whereas things can have different degrees of efficiency or effectiveness.
It's not a commonly used word, as it is mostly used in technical language.
It can also be a noun, meaning a person that does a certain job.