Are resources unlimited?
No, resources such as oil will deplete and eventually run out. They can however be imported
Will there be any future technology?
You can go a little way into the future so there are plausible inventions such as fusion power plants.
Will there be agriculture?
Yes. This is a sub category of the Industrial zone.