A it terminates if the system tablespace in the

This preview shows page 104 - 107 out of 152 pages.

A. It terminates if the SYSTEM tablespace in the source database is not autoextensible. B. It automatically makes necessary changes to Oracle environment variables. C. It automatically enables unified auditing in the upgraded database. D. It automatically adds new data files if there is not enough disk space to grow. Correct Answer: B Section: (none) Explanation Explanation/Reference: References: QUESTION 205 Identify two prerequisites for configuring Enterprise Manager Database Express (EM Express). A. Grant the APEX_PUBLIC_USER role to the SYSMAN user. B. Use the DBMS_XDB_CONFIG.SETHTTPPORT procedure to configure a port number for Oracle HTTP Server. C. Install Oracle HTTP Server. D. Configure at least one dispatcher for the TCP/IP protocol. E. Create a SYSMAN user with the SYSDBA privilege as an administrator for EM Express. Correct Answer: BD Section: (none) Explanation Explanation/Reference:
Image of page 104
QUESTION 206 Your production database PROD uses file system storage. You want to migrate storage including the Fast Recovery Area for the PROD database to Oracle Automatic Storage Management (ASM) by using RMAN. You back up the entire database. What should the next step be in this migration process? A. enabling row movement for the database B. disabling Oracle Flashback Database if enabled C. opening the database in exclusive mode D. placing all tablespaces in read-only mode Correct Answer: B Section: (none) Explanation Explanation/Reference: References: QUESTION 207 Your database supports a Decision Support System (DSS) workload that involves the execution of complex queries. Currently, the database is running with peak workload. You want to analyze some of the most resource-intensive statements cached in the library cache. What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance? A. Automatic Database Diagnostic Monitor (ADDM) B. SQL Tuning Advisor C. SQL Access Advisor D. SQL Performance Analyzer E. Automatic Workload Repository (AWR) report Correct Answer: C Section: (none) Explanation Explanation/Reference: References: QUESTION 208 In which situations does the Database Writer process ( DBWn ) write to data files? (choose two). A. when the RMAN recovery process starts B. when a user process commits a transaction C. when a tablespace is made read-only or taken offline D. when PMON cleans up dirty buffers in the database buffer cache E. when clean buffers for reading new blocks into the database buffer cache are not found easily Correct Answer: CE Section: (none) Explanation Explanation/Reference: References QUESTION 209 Which two statements are true about availability audit features after migration to unified auditing? (Choose
Image of page 105
two.) A. The ability of users to audit their own schema objects is not available in the post-migrated database.
Image of page 106
Image of page 107

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