I assume you mean "sketch" when you say "app" or "firmware."
A sketch is what you write in the provided IDE and upload to the Arduino through USB. When you upload a sketch, the Arduino stores the program data and it is started again when you power it up, even from external sources; you don't need a computer to run it, just to upload it.