79. Which two statements regarding the LOGGING clause of the CREATE TABLESPACE... statement are correct? (Choose two.)
A) This clause is not valid for a temporary or undo tablespace.
B) If the tablespace is in the NOLOGGING mode, no operation on the tablespace will generate redo.
C) The tablespace will be in the NOLOGGING mode by default, if not specified while creating a tablespace.
D) The tablespace-level logging attribute can be overridden by logging specifications at the table, index, materialized view, materialized view log, and partition levels.
答案：A，D
为什么是D？
第一次发帖，以前只看不会，没多少积分
------最佳解决方案--------------------------------------------------------
oracle的文档说的很清楚啊。基本都是官方的原文。
答案a/d没错.
a)创建temp和undo表空间不能指定logging子句.
d)表级定义可以覆盖表空间级定义的logging子句;
一下是官方原文：
Specify the default logging attributes of all tables, indexes, materialized views, materialized view logs, and partitions within the tablespace. LOGGING is the default. This clause is not valid for a temporary or undo tablespace.
The tablespace-level logging attribute can be overridden by logging specifications at the table, index, materialized view, materialized view log, and partition levels.
------其他解决方案--------------------------------------------------------
我没什么积分呢，但是很认真地问题
------其他解决方案--------------------------------------------------------
有懂的人，帮我看下吧
------其他解决方案--------------------------------------------------------
恩，谢谢，为什么你们总能找到呢？我也花了一些时间来找得。
------其他解决方案--------------------------------------------------------
ding