1Z0-082 practice question 19 of 25
Examine this command: CREATE UNDO TABLESPACE undotbs01 DATAFILE ‘undotbs_01.dbf’ SIZE 100M AUTOEXTEND ON; Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)
Full set: 142 questionsFor an undo tablespace to become the database’s default, the instance must be running in Automatic Undo Management (AUM) mode (UNDOMANAGEMENT = AUTO) and the initialization parameter UNDOTABLESPACE must be set to the new tablespace’s name (UNDOTBS01). Merely creating the tablespace with CREATE UNDO TABLESPACE is insufficient; these two parameter settings are mandatory.
A – SEGMENT SPACE MANAGEMENT AUTO applies to regular tablespaces; undo tablespaces ignore this clause. C – NOLOGGING is disallowed for undo tablespaces (Oracle returns ORA-30022). E – ONLINE is the default for CREATE UNDO TABLESPACE and does not make it the default undo tablespace.
1. Oracle Database Concepts 19c
“Managing Undo”
Sec. 13.3.3 “Setting Up Automatic Undo Management” – requirement for UNDOMANAGEMENT = AUTO and UNDOTABLESPACE.
2. Oracle Database SQL Language Reference 19c
“CREATE UNDO TABLESPACE” syntax – notes on default ONLINE and disallowed NOLOGGING
Doc ID F17309-04.
Keep practicing
Take the free 1Z0-082 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-082 practice questions
- Question 1Which three statements are true about using SQL*Plus?
- Question 2Which three statements are true about advanced connection options supported by Oracle Net…
- Question 3Which statement is true about the INTERSECT operator used in compound queries?
- Question 5Which two statements are true about the ORDER BY clause when used with a SQL statement co…
- Question 6Which three statements are true about the tools used to configure Oracle Net Services? (C…
- Question 7In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespace…
