D oracle software owners must be members of the same

This preview shows page 128 - 131 out of 152 pages.

D. Oracle software owners must be members of the same central oraInventory group, but they need not have this group as their primary group. Correct Answer: C Section: (none) Explanation Explanation/Reference: References QUESTION 274 Which three statements are true about Automatic Workload Repository (AWR)? (Choose three.) A. An AWR snapshot shows the SQL statements that are producing the highest load on the system, based on criteria such as elapsed time and CPU time. B. AWR data is stored in memory and in a database. C. All AWR tables belong to the SYSTEM schema. D. The manageability monitor (MMON) process gathers statistics and creates an AWR snapshot that is used by the self-tuning components in a database. E. An AWR snapshot contains system-wide tracing and logging information. Correct Answer: ABD Section: (none) Explanation Explanation/Reference: QUESTION 275 You want to import the schema objects of the HR user from the development database DEVDB to the production database PRODDB by using Oracle Data Pump. A database link devdb.us.oracle.com is created between PRODDB and DEVDB . You execute the following command on the PRODDB database server:
Image of page 128
What should you do to resolve the error? A. Add network_link = devdb.us.oracle.com. B. Add the SYSTEM user to the schemas option. C. Change the dumpfile option value to [email protected] D. Replace the schemas option with network_1ink = devdb.us.oracle.com. E. Replace the dumpfile option with network_1ink = devdb.us.oracle.com. Correct Answer: E Section: (none) Explanation Explanation/Reference: QUESTION 276 Which three statements are true about server-generated alerts? (Choose three.) A. Server-generated alerts notify administrators of problems that cannot be resolved automatically. B. Alerts are not issued for locally managed read-only tablespaces. C. Response actions cannot be specified for server-generated alerts. D. Stateful alerts can be queried only from the DBA_ALERT_HISTORY view. E. When an alert is cleared, it is moved to the DBA_ALERT_HISTORY view. Correct Answer: ABE Section: (none) Explanation Explanation/Reference: References QUESTION 277 Which two statements are true about Automatic Storage Management (ASM)? (Choose two.) A. It mounts databases and diskgroups to make ASM files available to database instances. B. It spreads files proportionally across all disks in a diskgroup, aiming to ensure that all the disks in a diskgroup have the same I/O load. C. It automatically places each disk from an external redundancy diskgroup in its own failure group. D. It divides files into extents and allows an extent to span disks. E. It mirrors data at the allocation unit (AU) level across failure groups within a normal or high redundancy diskgroup.
Image of page 129
Correct Answer: BE Section: (none) Explanation Explanation/Reference: QUESTION 278 You want to create a test database as a replica of your production database with minimum intervention from a DBA.
Image of page 130
Image of page 131

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