Correct answer d section none explanation references

This preview shows page 93 - 96 out of 152 pages.

Correct Answer: D Section: (none) Explanation Explanation/Reference: References: (4.4.1.2) QUESTION 176 Which two actions does an incremental checkpoint perform? (Choose two.) A. It signals CKPT to write the checkpoint position to the data file headers. B. It writes the checkpoint position to the data file headers. C. It advances the checkpoint position in the checkpoint queue. D. It writes the checkpoint position to the control file. Correct Answer: CD
Image of page 93
Section: (none) Explanation Explanation/Reference: References: QUESTION 177 You want to prevent a group of users in your database from performing long-running transactions that consume huge amounts of space in the undo tablespace. If the quota for these users is exceeded during execution of a data manipulation language (DML) statement, the operation should abort and return an error. However, queries should still be allowed, even if users have exceeded the undo space limitation. How would you achieve this? A. Specify the maximum amount of quota a user can be allocated in the undo tablespace. B. Decrease the number of Interested Transaction List (ITL) slots for the segments on which these users perform transactions. C. Implement a profile for these users. D. Implement a Database Resource Manager plan. Correct Answer: D Section: (none) Explanation Explanation/Reference: QUESTION 178 A database instance is started by using an SPFILE. The database is configured in ARCHIVELOG mode and the control file autobackup is configured. Daily full database backups are performed by using RMAN. You lost all control files due to media failure. Given the steps to recover from the error in random order: 1. Shut down the instance, if it is not already down. 2. Restore the control file from autobackup to a new location. 3. Start the database instance to NOMOUNT state. 4. Recover the database to the point of failure of the control file. 5. Open the database with the RESETLOGS option. 6. Mount the database. 7. Update the SPFILE with the new location of the control file by using the ALTER SYSTEM command. Identify the correct sequence of the required steps. A. 1, 3, 2, 6, 7, 4, 5 B. 1, 3, 7, 2, 6, 4, 5 C. 1, 3, 2, 4, 5 D. 1, 2, 6, 4, 5 E. 1, 6, 2, 4, 5 Correct Answer: A Section: (none) Explanation Explanation/Reference: QUESTION 179 What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?
Image of page 94
A. statistics recommendations B. SQL profile recommendations C. SQL statement restructure recommendations D. creation of materialized views to improve query performance Correct Answer: B Section: (none) Explanation Explanation/Reference: QUESTION 180 You have just completed a manual upgrade of an Oracle 11g Database to Oracle Database 12c.
Image of page 95
Image of page 96

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