statement are correct?

Which two statements regarding the LOGGING clause of the CREATE TABLESPACE… statement are correct? (Choose two.)

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.
The tablespace-level logging attribute can be overridden by logging specifications at the table, index, materialized view, materialized view log, and partition levels.

C.
If the tablespace is in the NOLOGGING mode, no operation on the tablespace will generate redo.

D.
The tablespace will be in the NOLOGGING mode by default, if not specified while creating a tablespace.



Leave a Reply 0

Your email address will not be published. Required fields are marked *