1. When you are upgrading a database to Oracle Database 12c, which of the following options are true?
A. Any version of an Oracle 10g or Oracle 11g database can be upgraded to Oracle Database 12c using DBUA.
B. Only the versions 10.2.0.5, 11.1.0.7, 11.2.0.2, 11.2.0.3, and 11.2.0.4 can be upgraded to 12.1.0.
C. Once upgraded to Oracle Database 12c, the upgraded database can only be downgraded to Oracle 11g.
D. When a 10.2.0.5 database is upgraded to Oracle Database 12c, it cannot be downgraded.
2. Which is the best option for upgrading an Oracle 10g R2 database that is in its terminal release to Oracle Database 12c?
A. Use Data Pump utilities to export and import.
B. Perform a direct upgrade using DBUA.
C. Upgrade to 11g 11.1.0.7 or 11.2.0.2 using DBUA, and then upgrade the database to 12.1.0 using Oracle Database 12c DBUA.
D. Run catctl.pl script on the Oracle 10g instance, and then start the instance in Oracle Database 12c.
3. When you’re using DBUA to upgrade a database from Oracle 10g, which of the following activities are not performed by DBUA? (Choose two.)
A. Perform the pre-upgrade steps.
B. Change listener.ora to configure the new Oracle home directory information.
C. Disable archiving during the upgrade.
D. Back up the database after the upgrade.
E. Recompile any invalid objects.
F. Lock the new user accounts that were created.
G. Adjust the initialization parameter values.
H. Remove the deprecated initialization parameters.
4. When you’re performing a manual upgrade to Oracle Database 12c, in what order are the following steps performed? 1. Run catctl.pl . 2. Run preupgrd.sql . 3. Run utlu121s.sql . 4. Start the database using the STARTUP UPGRADE option. 5. Start the database using the STARTUP NORMAL option.
A. 2, 5, 1, 4, 2
B. 2, 4, 1, 5, 3
C. 4, 2, 1, 5, 3
D. 5, 2, 4, 1, 3
5. Which of the following statements regarding the Pre-Upgrade utility preupgrd.sql are correct? (Choose two.)
A. It checks for space availability, user conflicts, role conflicts, initialization parameters, etc., and prepares fix-up scripts to take care of all issues.
B. The Pre-Upgrade Information utility does not make any changes to the database, but merely reports results.
C. preupgrd.sql is a standalone script and can be copied to another location to exe- cute on the database to be upgraded.
D. It recommends the amount of free space required in the SYSTEM and SYSAUX tablespaces.
6. Which two options are not true with the STARTUP UPGRADE mode instance startup?
A. It initiates the upgrade process automatically after the instance is started.
B. It suppresses spurious and unnecessary error messages, especially the ORA-00942 .
C. It handles certain system startup parameters that could interfere with the upgrade.
D. This option is more of a documentation purpose when the database is started for upgrade. Its functionality is no different than the default STARTUP option.
7. When you click the Restore Database button on the Upgrade Results page, which options must be true to perform a complete restore?
A. The database is upgraded from 11.2 release to Oracle Database 12c.
B. The database must be backed up using DBUA.
C. The COMPATIBLE parameter value must be 11.2.0.
D. The database must be backed up prior to the upgrade.
8. Which of the following database options must be upgraded individually when you’re upgrading the database using the manual method?
A. JServer Java Virtual Machine
B. Oracle Real Application Clusters
C. Oracle XML Database
D. All of the above
E. None of the above
9. Which mechanism is used by Oracle to identify the components that need to be upgraded while upgrading a database?
A. V$OPTION
B. V$LICENSE
C. DBMS_REGISTRY
D. DBMS_OPTIONS
10. Before manually upgrading an 11.1.0.7 database, what should be the appropriate value of the COMPATIBLE parameter? The current value is the default and is not specified in the parameter file.
A. 11.1.0.7
B. 10.2.0.5
C. 12.1.0
D. Do not specify the COMPATIBLE parameter in the parameter file.
11. Which option provides the opportunity to defragment the database during the upgrade?
A. Manual upgrade
B. DBUA upgrade
C. Data Pump Export/Import
D. Transport Database
12. Complete the sentence. To run the Pre-Upgrade Information tool, the database must be started _____.
A. From Oracle Database 12c home
B. From the original database home
C. With the STARTUP UPGRADE option
D. With the STARTUP PREUPGRADE option
13. In your Oracle Database 11g environment, the ORACLE_SID is set to my11g , the ORACLE_ BASE directory is set to /u01/app/oracle , and the ORACLE_HOME directory is set to /u01/ app/oracle/db/11.2.0 . When you run the Pre-Upgrade Information tool on this environ- ment from the /home/dba/preup directory, to which location are the log file and fix-up scripts written?
A. /u01/app/oracle/cfgtoollogs/my11g/preupgrade
B. /u01/app/oracle/db/11.2.0/cfgtoollogs/my11g/preupgrade
C. /home/dba/preup/cfgtoollogs/my11g/preupgrade
D. /home/dba/preup
14. During an upgrade using DBUA, which task cannot be performed by DBUA?
A. Configure listener.ora in the 12c Oracle home, if no listener.ora file exists.
B. Register the database with an existing listener in the 12c Oracle home.
C. Copy the tnsnames.ora file from an old Oracle home to the 12c Oracle home.
D. Migrate the listener running in the old Oracle home to the 12c Oracle home.
15. Which statement about DBUA upgrade is true?
A. You must shut down and start the source database using the UPGRADE option before invoking DBUA for upgrade.
B. The new home of the database must be added to oratab file.
C. DBUA displays the progress of the upgrade, but you have no way of knowing which step or phase is being executed.
D. Space requirements are identified by DBUA in the Fast Recovery Area; the SYSTEM and SYSAUX tablespaces must be fixed manually outside DBUA.
16. Which option is not available for upgrading a database from 11.2.0.2 to 12.1.0?
A. Full Database Export/Import using Data Pump.
B. Full Transportable Export/Import.
C. Manual upgrade using catctl.pl .
D. DBUA upgrade.
E. All of the above are available options.
17. Name the scripts used by the Pre-Upgrade Information and Post-Upgrade Status tools?
A. preupgrd.sql , postupgrd.sql
B. utlu121i.sql , utlu121s.sql
C. utlu121i.sql , postupgrd.sql
D. preupgrd.sql , utlu121s.sql
18. Which statement regarding Unified Auditing is true regarding a database after upgrade?
A. The predefined Unified Auditing policies are disabled by default after a manual upgrade.
B. Pre-12c audit configuration is disabled by default after the upgrade, and audit records are no longer written to the AUD$ table.
C. One of the predefined Unified Auditing policies is enabled by default after a DBUA upgrade.
D. Traditional pre-12c audit and 12c Unified Auditing policies cannot co-exist in the same database.
19. To improve upgrade performance and reduce the upgrade time, what tasks should be completed before starting the upgrade? (Choose two.)
A. Run dbms_stats.gather_dictionary_stats .
B. Run $ORACLE_HOME/rdbms/admin/emremove.sql .
C. Run dbms_stats.gather_database_stats .
D. Purge DBA_RECYCLEBIN .
20. You have a database in Oracle 8.1.7 .4 version. The database size is less than 5GB, including all tablespaces ( user data , system , temp , and rollback ). Which method would you choose to upgrade to Oracle Database 12c? (Choose the best answer.)
A. A two-phased upgrade. Upgrade to 10.2.0.5 first, and then upgrade to 12.1.0.
B. Use traditional export/import using exp/imp tools.
C. Use the transportable tablespace feature to copy the user_data tablespace to an Oracle Database 12c database.
D. Use DBUA to upgrade the 8.1.7.4 database directly to 12.1.0.
