177-Q35:
You lose all of the datafiles in your TEMP tablespace after the database shuts down. When the database starts again, what happens?
A. The database instance will not start and you must re-create the TEMP tablespace in MOUNT mode.
B. The database instance will not start and you will have to drop the old TEMP tablespace in NOMOUNT mode.
C. The tempfile is re-create at the original location, a message is written to alert log, and the database starts normally.
D. The database starts normally, a message is written to the alert log, and the DBA must manually re-create the TEMP tablespace.
Answer: C
在数据库关闭之后，你丢失了所有的临时表空间的数据文件。当数据库再次启动时，会发生什么？
A. 数据库实例无法启动，您必须重新创建MOUNT模式的临时表空间。
B. 数据库实例无法启动，你将不得不在NOMOUNT模式下删除旧的临时表空间。
C. 临时文件在原来的位置重新创建，一个消息写入日志和警报，数据库正常启动。
D. 数据库启动正常，一个消息写入日志和警报，DBA必须手动重新创建临时表空间。来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/81227/viewspace-2125014/ ，如需转载，请注明出处，否则将追究法律责任。
