It's more about the lens you use. For example you could take 1 shot of say, a car, with a wide angle lens and end up with a single image that would print out at about A4 size at 350dpi.
However, if you shot from the same distance with a telephoto lens you would need to take many images to build up a mosaic of the same scene. You would need a panoramic tripod head and stitching software to achieve this properly - otherwise parallax errors will be evident.
Your resulting image would be much larger but still 350dpi.
So the longer the lens, the bigger the image.
With the single A4 image, you could technically drop the resolution to about 200dpi (
afaik) to make the shot physically bigger but as said this would lose detail. This wouldn't matter if the image isn't viewed close-up though.
As images get bigger you may also find you need more computer power and storage. Also, I found big frames hard to find.