A it provides a summary of the upgrade results b it

This preview shows page 113 - 116 out of 152 pages.

A. It provides a summary of the upgrade results. B. It recompiles all invalid PL/SQL and Java code. C. It generates a log file containing the fixes that can be made to the source database. D. It provides parallel upgrade options to finish the upgrade process with a reduced down time. E. It generates fix-up scripts to be run on the source database before upgrade. Correct Answer: D Section: (none) Explanation Explanation/Reference: References: QUESTION 231 Which statement is true about redo log files during instance recovery? A. All current, online, and archived redo logs are required to complete instance recovery. B. All redo log entries in the current and active logs are applied to data files to reconstruct changes made after the most recent checkpoint. C. All redo log entries in the current log are applied to data files until the checkpoint position is reached. D. All current, active, and inactive redo logs are required to complete instance recovery. Correct Answer: B Section: (none) Explanation Explanation/Reference: References
Image of page 113
QUESTION 232 A database uses Automatic Storage Management (ASM) as database storage, which has a diskgroup, DATA1 , which is created as follows: What happens when the FAILGRP1 failure group is corrupted? A. Mirroring of allocation units occurs within the FAILGRP2 failure group. B. Transactions that are using the diskgroup fail. C. ASM does not mirror any data and newly allocated primary allocation units (AU) are stored in the FAILGRP2 failure group. D. Data in the FAILGRP1 failure group is moved to the FAILGRP2 failure group and rebalancing is started. Correct Answer: D Section: (none) Explanation Explanation/Reference: QUESTION 233 Your database is running in ARCHIVELOG mode. You want to take a consistent whole database backup. Which two statements are true in this scenario? (Choose two.) A. The user-managed backup consists of only formatted data blocks. B. The database must be shut down to take a user-managed backup. C. The RMAN backup contains only data files. D. The RMAN backup can be performed while the database is open. E. The database must be in MOUNT state to take RMAN backup. Correct Answer: BE Section: (none) Explanation Explanation/Reference: QUESTION 234 Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken. RMAN is configured to perform control file autobackup. In which three scenarios do you need media recovery? (Choose three.) A. loss of all the copies of the control file B. loss of all the inactive online redo log group members C. loss of a data file that belongs to the active undo tablespace D. loss of data files that belong to the SYSTEM tablespace E. logical corruption of data that is caused by a wrong transaction F. abnormal termination of the database instance Correct Answer: ACD Section: (none) Explanation
Image of page 114
Explanation/Reference: QUESTION 235 You plan to install the Oracle Database 12c software. You want to use Oracle Automatic Storage Management (ASM) for storage and Oracle Restart for managing components. Oracle Grid Infrastructure
Image of page 115
Image of page 116

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