WGU DI 92 OFFICIAL EXAM
QUESTIONS AND ANSWERS 100%
VERIFIED ANSWERS 2026
1 . Which file is read by DBUA to determine which databases are
available on a server as candidates for upgrade?: /etc/oratab
or
/var/opt/oracle/oratab
2. What is the lowest release of the database that can be upgraded
to Oracle Database 12c using DBUA?•. 10.2.0.5
3. The output of the Pre-Upgrade Information tool is written to what
location?: $ORACLE BASE/cfgtoollogs/db_unique_name/preupgrade
4. When you run the preupgrd.sql script, to which table are the
invalid objects written?: registry$nonsys_inv_objs
5. Which script compares invalid objects before and after an
upgrade and lists only the invalids after the upgrade?: utluiobj.sql
6. What version of the time zone file is supplied with Oracle Database
12c software?: 18
1/51
,7. What happens to Enterprise Manager Database Control when
the database is upgraded?: Enterprise Manager Database Control is
dropped during the upgrade.
8. Before a database upgrade, AUD$ table should be owned by
and reside on tablespace.: SYS, SYSTEM
9. True or False: During a DBUA database upgrade, you have the
option to migrate data files to another location or to ASM.: True
10. True or False: If Flashback Database is not enabled on the database,
DBUA can enable Flashback Database and give you the option to
generate a restore point: False
1 1 . True or False: A DBUA upgrade can be restarted.: True
12. True or False: DBUA can be run in silent mode, without accepting
any input from the user.: True
13. True or False: Running the Pre-Upgrade Information tool is optional
before performing a DBUA upgrade.: True
14. True or False: Running the Pre-Upgrade Information tool is optional
before performing a manual upgrade.: False
15. When you run catupgrd.sql to upgrade the database, which
additional script must be run to complete the upgrade?:
catuppst.sql
2/51
,16. Which script is used to upgrade the database when run in manual
upgrade mode?: catctl.pl
17. What is the default parallelism used when running the catctl.pl script
without the -n option?: 4
18. Which script is used for the post-upgrade status information?:
utlu121s.sql
3/51
, 19. True or False: To enable Unified Auditing, you must set the
UNIFIED AUDIT TRAIL parameter to TRUE.•. False
20. In which mode should the database be when you
change MAX STRING SIZE to EXTENDED?:
STARTUP UPGRADE
21 . Which script is used to downgrade the database to its original
release?: -
catdwgrd.sql
22. After you run catdwgrd.sql to downgrade the database, which
script should you run to get the catalog in the correct version?:
catrelod.sql
23. Which script recompiles all invalid objects in the database?:
utlrp.sql
24. To use Full Transportable Export/lmport, the database must be at
least version.: 11.2.0.3
25. True or False: Oracle Database 12c supports legacy explimp tools
to migrate data.: True
26. Which memory area is shared by all server and background
processes?: System Global Area (SGA)
4/51
QUESTIONS AND ANSWERS 100%
VERIFIED ANSWERS 2026
1 . Which file is read by DBUA to determine which databases are
available on a server as candidates for upgrade?: /etc/oratab
or
/var/opt/oracle/oratab
2. What is the lowest release of the database that can be upgraded
to Oracle Database 12c using DBUA?•. 10.2.0.5
3. The output of the Pre-Upgrade Information tool is written to what
location?: $ORACLE BASE/cfgtoollogs/db_unique_name/preupgrade
4. When you run the preupgrd.sql script, to which table are the
invalid objects written?: registry$nonsys_inv_objs
5. Which script compares invalid objects before and after an
upgrade and lists only the invalids after the upgrade?: utluiobj.sql
6. What version of the time zone file is supplied with Oracle Database
12c software?: 18
1/51
,7. What happens to Enterprise Manager Database Control when
the database is upgraded?: Enterprise Manager Database Control is
dropped during the upgrade.
8. Before a database upgrade, AUD$ table should be owned by
and reside on tablespace.: SYS, SYSTEM
9. True or False: During a DBUA database upgrade, you have the
option to migrate data files to another location or to ASM.: True
10. True or False: If Flashback Database is not enabled on the database,
DBUA can enable Flashback Database and give you the option to
generate a restore point: False
1 1 . True or False: A DBUA upgrade can be restarted.: True
12. True or False: DBUA can be run in silent mode, without accepting
any input from the user.: True
13. True or False: Running the Pre-Upgrade Information tool is optional
before performing a DBUA upgrade.: True
14. True or False: Running the Pre-Upgrade Information tool is optional
before performing a manual upgrade.: False
15. When you run catupgrd.sql to upgrade the database, which
additional script must be run to complete the upgrade?:
catuppst.sql
2/51
,16. Which script is used to upgrade the database when run in manual
upgrade mode?: catctl.pl
17. What is the default parallelism used when running the catctl.pl script
without the -n option?: 4
18. Which script is used for the post-upgrade status information?:
utlu121s.sql
3/51
, 19. True or False: To enable Unified Auditing, you must set the
UNIFIED AUDIT TRAIL parameter to TRUE.•. False
20. In which mode should the database be when you
change MAX STRING SIZE to EXTENDED?:
STARTUP UPGRADE
21 . Which script is used to downgrade the database to its original
release?: -
catdwgrd.sql
22. After you run catdwgrd.sql to downgrade the database, which
script should you run to get the catalog in the correct version?:
catrelod.sql
23. Which script recompiles all invalid objects in the database?:
utlrp.sql
24. To use Full Transportable Export/lmport, the database must be at
least version.: 11.2.0.3
25. True or False: Oracle Database 12c supports legacy explimp tools
to migrate data.: True
26. Which memory area is shared by all server and background
processes?: System Global Area (SGA)
4/51
