OCP 1 Installation and Upgrade Enhancements

Card Set Information

Author:
Tralala
ID:
213620
Filename:
OCP 1 Installation and Upgrade Enhancements
Updated:
2014-05-10 10:36:27
Tags:
OCP Installation Upgrade Enhancements
Folders:

Description:
OCP 1 Installation and Upgrade Enhancements
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user Tralala on FreezingBlue Flashcards. What would you like to do?


  1. In which location should you place the oranfstab file if you want the entries to be global for all Oracle databases?
    /etc
  2. Which graphical tool is used to upgrade a previous release database to Oracle 11g?
    The Database Upgrade Assistant (DBUA)
  3. In which location should you place the oranfstab file if you want the entries to be specific to a single database?
    $ORACLE_HOME/dbs
  4. Which command-line utility is used for hot patching and conventional patching to apply a patch?
    The opatch utility
  5. Which type of patching, hot patching or conventional patching, generally takes more time?
    Conventional patching
  6. Which package recompiles invalid database objects, including stored PL/SQL and Java code?
    The UTL_RECOMP package
  7. In Oracle 11g, which initialization parameter replaces the USER_DUMP_DEST, BACKGROUND_DUMP_DEST, and CORE_DUMP_DEST initialization parameters?
    The DIAGNOSTIC_DEST initialization parameter
  8. With regard to using multiple platforms, what are the main benefits of using Oracle Direct NFS?
    It provides a common NFS interface that simplifies manageability and can be used across all platforms.
  9. What effect does using the STARTUP UPGRADE command have on job queues?
    It turns off job queues.
  10. Which script should you use after upgrading an existing database in a multiprocessor environment to recompile invalid objects while maximizing performance?
    The utlrp.sql script
  11. Which file can you remove to disable the Direct NFS client?
    The oranfstab file
  12. From which database environment should you execute the utlu111i.sql script when performing an upgrade analysis?
    From the database to be upgraded
  13. Which view can you use to display open network paths being served by Direct NFS?
    The V$DNFS_CHANNELS view
  14. To be compliant with Optimal Flexible Architecture (OFA) guidelines, should the flash recovery area and data files be configured on one disk or separate disks?
    Separate disks
  15. When installing Oracle Database 11g, which environment variable is derived from the ORACLE_BASE environment variable and does not need to be specified?
    The ORACLE_HOME environment variable
  16. Which two steps must you take to enable Direct NFS?
    Mount the file systems using the kernel NFS driver, and replace the standard Oracle Disk Manager (ODM) library with one that supports Direct NFS Client.
  17. Which type of patching does not require you to shut down the instance, relink the Oracle binaries, and restart the instance?
    Hot patching
  18. How are NAS-based storage systems accessed?
    Using the kernel NFS driver for the given operating system
  19. Which script is used before upgrading to identify potential upgrade problems?
    The utlu111i.sql script
  20. Which type of patching, hot patching or conventional patching, uses more memory resources?
    Hot patching
  21. In which two locations can the oranfstab file be located?
    $ORACLE_HOME/dbs or /etc
  22. Which script is used to display post-upgrade information about a database upgraded to Oracle 11g?
    The utlu111s.sql script
  23. Which optional configuration file provides configuration settings for each NFS server when using Direct NFS?
    The oranfstab file
  24. Which view can you use to display files that are open using Direct NFS?
    The V$DNFS_FILES view
  25. Which type of patching is not available for all operating system platforms?
    Hot patching
  26. Which type of patching is available for all operating system platforms?
    Conventional patching
  27. Which Oracle Disk Manager (ODM) library does Oracle Database 11g use to enable Direct NFS?
    libnfsodm11.so
  28. To what does the term hot patching refer?
    Applying a patch on a running Oracle database without having to restart the instance
  29. To what does the term parallel recompilation refer?
    Using multiple processors when recompiling stored code
  30. If you specify an oranfstab file in both $ORACLE_HOME/dbs and /etc, which file does Direct NFS use first to identify mount settings?
    $ORACLE_HOME/dbs/oranfstab
  31. To be compliant with Optimal Flexible Architecture (OFA) guidelines, where should you set up the flash recovery area and data file?
    Under the Oracle base
  32. If you do not specify an oranfstab file in either $ORACLE_HOME/dbs or /etc, which file does Direct NFS use to identify mount settings?
    /etc/mtab
  33. After upgrading an Oracle 10g database to Oracle 11g and executing the utlrp.sql script, what is recompiled?
    Invalid objects, including PL/SQL modules and Java classes
  34. If you do not explicitly set the ORACLE_BASE environment variable when installing Oracle Database 11g and creating a database, in which file will a warning message be recorded?
    The alert log file
  35. If you start a database using the STARTUP UPGRADE command, what type of connections are allowed?
    Only AS SYSDBA connections
  36. When installing Oracle Database 11g, which environment variable should you explicitly specify to comply with Optimal Flexible Architecture (OFA) guidelines?
    The ORACLE_BASE environment variable
  37. Which database versions can be directly upgraded to Oracle 11g?
    9.2.0.4 or later, 10.1.0.2 or later, and 10.2.0.1 or later databases
  38. How does using the STARTUP UPGRADE command affect system triggers?
    It disables system triggers.
  39. How are file systems being served through Direct NFS mounted?
    By the kernel NFS system

What would you like to do?

Home > Flashcards > Print Preview