Oracle
1Z0-072 · Question #45
Examine this command: CREATE TEMPORARY TABLESPACE temp_tbs TEMPFILE 'temp01.dbf' SIZE 10M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED SEGMENT MANAGEMENT AUTO; Which two changes must you make so that…
The correct answer is A. Add the EXTENT MANAGEMENT LOCAL UNIFORM clause. F. Add MAXSIZE for the AUTOEXTEND ON clause. See the full explanation below for the reasoning.
Question
Examine this command: CREATE TEMPORARY TABLESPACE temp_tbs TEMPFILE 'temp01.dbf' SIZE 10M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED SEGMENT MANAGEMENT AUTO; Which two changes must you make so that temp_tbs is created? (Choose two.)
Options
- AAdd the EXTENT MANAGEMENT LOCAL UNIFORM clause.
- BAdd the NOLOGGING clause.
- CRemove the SEGMENT MANAGEMENT AUTO clause.
- DRemove the AUTOEXTEND ON clause.
- ERemove the ONLINE clause.
- FAdd MAXSIZE for the AUTOEXTEND ON clause.
How the community answered
(54 responses)- A78% (42)
- B13% (7)
- C6% (3)
- D2% (1)
- E2% (1)
Community Discussion
No community discussion yet for this question.