You can still gain achievements while playing; however, some multiplayer achievements cannot be gained unless certain multiplayer actions have been performed. If you can’t perform these actions with a system link game then those achievements cannot be gained.
If you are wondering about specific games ranking then it would depend on the game’s programming.
If your asking about rankings such as laptimes or similar things in games then no, you can’t compare your rankings with others while offline.