It isn't. Even discounting day 1 patches, every console assumes an internet connection. You're at the mercy of the game devs, and unless you are checking for "internet connection required" (and believing the lack of such on the box means you really don't need one), you can still end up with something that will refuse to boot unless it phones home.