1Z0-083 practice question 20 of 35
Choose the best. How do you configure a CDB for local undo mode?
Full set: 286 questionsTo switch a multitenant container database (CDB) from the default shared undo mode to local undo mode, a specific procedure must be followed. The CDB instance must be shut down and then started in UPGRADE mode. While connected to the root container (CDB$ROOT), the ALTER DATABASE LOCAL UNDO ON; command is executed. After this command completes successfully, the CDB instance must be shut down and restarted for the change to take effect.
A. The command is executed in the root, not each PDB, and the database must be in UPGRADE mode, not restricted mode.
C. The ALTER DATABASE LOCAL UNDO ON command must be executed in the root container (CDB$ROOT), not in each individual PDB.
D. The correct mode for this operation is UPGRADE, not RESTRICTED. Restricted mode is for administrative tasks that do not involve database-wide structural changes like this.
E. This operation cannot be performed while the database is in READ ONLY mode, as it modifies the database's fundamental structure.
- Oracle Database Administrator's Guide, 19c, Chapter 35, "Managing Undo in a Multitenant Environment", Section: "Switching from Shared Undo Mode to Local Undo Mode". The guide explicitly outlines the steps: "Start up the CDB in upgrade mode. ... Execute the ALTER DATABASE LOCAL UNDO ON; statement. ... Restart the CDB."
Keep practicing
Take the free 1Z0-083 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-083 practice questions
- Question 1Which two are true about flashback features in Oracle Database 19c and later releases? (C…
- Question 2Which two statements are true about Resource Manager plans for individual pluggable datab…
- Question 3Choose three. Which are the three steps in the SQL tuning process for Oracle Database env…
- Question 4Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgra…
- Question 5Choose three. Which three capabilities require the use of the RMAN recovery catalog?
- Question 6Choose two. In which two situations can you use Database Upgrade Assistant?
