A change in the oracle database version b change in

This preview shows page 54 - 57 out of 152 pages.

A. Change in the Oracle Database version B. Change in your network infrastructure C. Change in the hardware configuration of the database server D. Migration of database storage from non-ASM to ASM storage E. Database and operating system upgrade Correct Answer: ACE Section: (none) Explanation Explanation/Reference: Explanation:
Image of page 54
Oracle 11g/12c makes further use of SQL tuning sets with the SQL Performance Analyzer, which compares the performance of the statements in a tuning set before and after a database change. The database change can be as major or minor as you like, such as: * (E) Database, operating system, or hardware upgrades. * (A,C) Database, operating system, or hardware configuration changes. * Database initialization parameter changes. * Schema changes, such as adding indexes or materialized views. * Refreshing optimizer statistics. * Creating or changing SQL profiles. QUESTION 96 Which two statements are true about the RMAN validate database command? (Choose two.) A. It checks the database for intrablock corruptions. B. It can detect corrupt pfiles. C. It can detect corrupt spfiles. D. It checks the database for interblock corruptions. E. It can detect corrupt block change tracking files. Correct Answer: AC Section: (none) Explanation Explanation/Reference: Explanation: Block corruptions can be divided Into Interblock corruption and intrablock corruption. In intrablock corruption. th« corruption occurs within the block itself and can be either physical or logical corruption. In interblock corruption, the corruption occurs between blocks and can only be logical corruption. (key word) * The VALIDATE command checks for intrablock corruptions only. Only DBVERIFY and the ANALYZE statement detect Interblock corruption. VALIDATE Command Output ••> List of Control File and SPFILE. File TYPE >»» SPFILE or Control File. Status >»» OK if no corruption, or FAILED If block corruption is found. Blocks Failing »»» The number of blocks that fail the corruption check. These blocks are newly corrupt. Blocks Examined »»» Total number of blocks in the file. Oracle' Database Backup and Recovery User's Guide 12c Release 1 (12.1) - 16 Validating Database Files and Backups QUESTION 97 You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name. Which statement is true? A. The ORACLE_BASE base parameter is not set. B. The installation is being performed by the root user. C. The operating system group that is specified should have the root user as its member. D. The operating system group that is specified must have permission to write to the inventory directory. Correct Answer: D Section: (none) Explanation Explanation/Reference: Explanation: Note: Providing a UNIX Group Name
Image of page 55
If you are installing a product on a UNIX system, the Installer will also prompt you to provide the name of the group which should own the base directory.
Image of page 56
Image of page 57

You've reached the end of your free preview.

Want to read all 152 pages?

  • Fall '19
  • Oracle Database

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors