Frage im Vorstellungsgespräch bei Amdocs

Intro, Questions on SQL joins and moving all elements in an array in a clockwise direction inside array i.e one element moving towards right by one place.