You lose all of the datafiles in your TEMP tablespace after the database shuts down. When the database starts again, what happens?

Answer: C

Explanation: If the database starts with a missing tempfile , the instance re-creates it and writes a message in the alert log. If the original location is not available, the DBA will have to create a new one manually after startup. A and B are incorrect because the database will start even if the tempfile location is not available. D is incorrect because the DBA does not need to re-create the tempfile (s) manually unless the original file system location is unavailable.