Oracle
1Z0-074 · Question #8
Which three tasks are performed automatically by Database Upgrade Assistant (DBUA) when the database to be upgraded is in archivelog mode and has the database flashback feature enabled? (Choose…
The correct answer is B. It creates a restore point to restore the database if the upgrade fails C. It drops all the invalid objects D. It calls the catctl.pl script to perform the upgrade process in parallel. Explanation/Reference:
Using Advanced SQL Features
Question
Which three tasks are performed automatically by Database Upgrade Assistant (DBUA) when the database to be upgraded is in archivelog mode and has the database flashback feature enabled? (Choose three.)
Options
- AIt changes Oracle kernel parameters if required
- BIt creates a restore point to restore the database if the upgrade fails
- CIt drops all the invalid objects
- DIt calls the catctl.pl script to perform the upgrade process in parallel
- EIt automatically resets the COMPATIBLE parameter value to 12.0.0
- FIt modifies or creates new tablespaces as required
How the community answered
(51 responses)- A10% (5)
- B84% (43)
- E2% (1)
- F4% (2)
Explanation
Explanation/Reference:
Topics
#DBUA#database upgrade#flashback restore point#catctl.pl
Community Discussion
No community discussion yet for this question.