Honestly, it depends on the cat. I had one who would have learned the expectation immediately, then only broken it if she was annoyed at me, to make a point.

And another one that would have been scared of the tape and just avoided that room entirely.