Like Huldra said, the Hollywood trope of a person having zero idea that they're actually an agent until receiving some activation phrase is silly. However, PointAndClique pointed to a much more mundane scenario that would be considered sleeper agents. The latter definition reminds me of Operation Gladio.