Jamonero Blanco
Quiz by , created more than 1 year ago

OCA OCA Quiz on OCA-17-Upgrading to Oracle Database 12c, created by Jamonero Blanco on 30/01/2017.

47
2
0
Jamonero Blanco
Created by Jamonero Blanco over 7 years ago
Close

OCA-17-Upgrading to Oracle Database 12c

Question 1 of 20

1

1. When you are upgrading a database to Oracle Database 12c, which of the following
options are true?

Select one or more of the following:

  • 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.

Explanation

Question 2 of 20

1

2. Which is the best option for upgrading an Oracle 10g R2 database that is in its
terminal release to Oracle Database 12c?

Select one or more of the following:

  • 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.

Explanation

Question 3 of 20

1

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.)

Select one or more of the following:

  • 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.

Explanation

Question 4 of 20

1

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.

Select one or more of the following:

  • A. 2, 5, 1, 4, 2

  • B. 2, 4, 1, 5, 3

  • C. 4, 2, 1, 5, 3

  • D. 5, 2, 4, 1, 3

Explanation

Question 5 of 20

1

5. Which of the following statements regarding the Pre-Upgrade utility preupgrd.sql are
correct? (Choose two.)

Select one or more of the following:

  • 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.

Explanation

Question 6 of 20

1

6. Which two options are not true with the STARTUP UPGRADE mode instance startup?

Select one or more of the following:

  • 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.

Explanation

Question 7 of 20

1

7. When you click the Restore Database button on the Upgrade Results page, which
options must be true to perform a complete restore?

Select one or more of the following:

  • 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.

Explanation

Question 8 of 20

1

8. Which of the following database options must be upgraded individually when you’re
upgrading the database using the manual method?

Select one or more of the following:

  • A. JServer Java Virtual Machine

  • B. Oracle Real Application Clusters

  • C. Oracle XML Database

  • D. All of the above

  • E. None of the above

Explanation

Question 9 of 20

1

9. Which mechanism is used by Oracle to identify the components that need to be upgraded
while upgrading a database?

Select one or more of the following:

  • A. V$OPTION

  • B. V$LICENSE

  • C. DBMS_REGISTRY

  • D. DBMS_OPTIONS

Explanation

Question 10 of 20

1

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.

Select one or more of the following:

  • 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.

Explanation

Question 11 of 20

1

11. Which option provides the opportunity to defragment the database during the upgrade?

Select one or more of the following:

  • A. Manual upgrade

  • B. DBUA upgrade

  • C. Data Pump Export/Import

  • D. Transport Database

Explanation

Question 12 of 20

1

12. Complete the sentence. To run the Pre-Upgrade Information tool, the database must be
started _____.

Select one or more of the following:

  • A. From Oracle Database 12c home

  • B. From the original database home

  • C. With the STARTUP UPGRADE option

  • D. With the STARTUP PREUPGRADE option

Explanation

Question 13 of 20

1

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?

Select one or more of the following:

  • 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

Explanation

Question 14 of 20

1

14. During an upgrade using DBUA, which task cannot be performed by DBUA?

Select one or more of the following:

  • 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.

Explanation

Question 15 of 20

1

15. Which statement about DBUA upgrade is true?

Select one or more of the following:

  • 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.

Explanation

Question 16 of 20

1

16. Which option is not available for upgrading a database from 11.2.0.2 to 12.1.0?

Select one or more of the following:

  • 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.

Explanation

Question 17 of 20

1

17. Name the scripts used by the Pre-Upgrade Information and Post-Upgrade Status tools?

Select one or more of the following:

  • A. preupgrd.sql , postupgrd.sql

  • B. utlu121i.sql , utlu121s.sql

  • C. utlu121i.sql , postupgrd.sql

  • D. preupgrd.sql , utlu121s.sql

Explanation

Question 18 of 20

1

18. Which statement regarding Unified Auditing is true regarding a database after upgrade?

Select one or more of the following:

  • 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.

Explanation

Question 19 of 20

1

19. To improve upgrade performance and reduce the upgrade time, what tasks should be
completed before starting the upgrade? (Choose two.)

Select one or more of the following:

  • 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 .

Explanation

Question 20 of 20

1

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.)

Select one or more of the following:

  • 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.

Explanation

Previous
Next