The post upgrade status tool reports an invalid

This preview shows page 95 - 97 out of 152 pages.

The Post-Upgrade Status Tool reports an INVALID status for some of the components after the upgrade. What must you do first in this situation to attempt to fix this problem? A. Run catuppst.sql to perform revalidation actions B. Run utluiobj.sql to filter out objects that were invalidated by the upgrade process. C. Run preupgrd.sql and then execute the generated “fix-up” scripts to resolve status issues. D. Run utlrp.sql to recompile stored PL/SQL and Java code and check the DBA_REGISTRY view. Correct Answer: A Section: (none) Explanation Explanation/Reference: QUESTION 181 What should you do to ensure that a job stores minimal job metadata and runtime data on disk, and uses only existing PL/SQL programs? A. Create an event-based job. B. Create a lightweight job. C. Specify the job as a member of a job class. D. Use a job array. Correct Answer: B Section: (none) Explanation Explanation/Reference: References: QUESTION 182 You plan to install the Oracle Database 12c software on a new server. The database will use Automatic Storage Management (ASM) and Oracle Restart. Oracle Grid Infrastructure for a standalone server is already installed on the server. You want to configure job role separation. You create the following operating system users and groups: - The user oracle as the owner of the Oracle database installation - The user grid as the owner of Oracle Grid Infrastructure - The group oinstall as an Oracle Inventory group - The group dba as the OSDBA group for Oracle database - The group asmdba as the OSDBA group for Oracle ASM - The group asmadmin as the administration privileges group for Oracle ASM - The group asmoper as the group for Oracle ASM
Image of page 95
Which two additional tasks should you perform with regard to the OS-level owners and groups? (Choose two.) A. creating a separate central inventory group for the Oracle Database 12c installation B. assigning oinstall as the primary group for the oracle user C. assigning asmadmin and asmoper as primary groups for the oracle user D. creating OS groups associated with the OSBACKUPDBA , OSDGDBA , and OSKMDBA system privileges E. assigning asmdba as the secondary group for the oracle user Correct Answer: BD Section: (none) Explanation Explanation/Reference: QUESTION 183 Examine the parameters for a database instance: Your database has three undo tablespaces and the default undo tablespace is not autoextensible. Resumable space allocation is not enabled for any sessions in the database instance. What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions? A. Transactions write their undo in the SYSTEM undo segment. B. Transactions fail. C. Transactions wait until space becomes available in UNDOTBS1 .
Image of page 96
Image of page 97

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