In which body of water are the Orkney islands?

The Orkney Islands are between the North Sea, The Atlantic Ocean, and the Pentland Firth.

Scapa Flow is a large semi-enclosed body of tidal water within the Orkney Islands. It is connected to all three of the above seas.