Question: what is the difference between offline and emergency state of a database?
Answer: Offline database can be easily brought back online. You don't need to tell the file locations to bring back it online. To attach a database again, you need to specify the location of the files in the attach statement. Emergency state database can be easily brought back online without specifying the file location.