• Description: Administration i
• Passing Score: 0%
• Practice Test - Number of questions: 139 questions
• Simulation Test - Number of questions: 139 questions
• Simulation Test Duration: 120 minutes
• Has explanations: No

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

Answer(s)

1. This clause is not valid for a temporary or undo tablespace.
2. If the tablespace is in the NOLOGGING mode, no operation on the tablespace will generateredo.
3. The tablespace will be in the NOLOGGING mode by default, if not specified while creating atablespace.
4. The tablespace-level logging attribute can be overridden by logging specifications at the table,index, aterialized view, materialized view log, and partition levels.

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, aterialized view, materialized view log, and partition levels.