C it can be used to migrate a database only if the

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

C. It can be used to migrate a database only if the source database does not have any tablespace in read- only mode. D. It allows migration of a database directly over network links. Correct Answer: D Section: (none) Explanation Explanation/Reference: QUESTION 283 Your database is in ARCHIVELOG mode and you want to automate the backup scheduling for your database. Which two tools or utilities would you use to achieve this? (Choose two.)
Image of page 131
A. Oracle Enterprise Manager Database Express (EM Express) B. Oracle Enterprise Manager Cloud Control C. Database Configuration Assistant (DBCA) D. Recovery Manager (RMAN) script invoked by using scheduler Correct Answer: BD Section: (none) Explanation Explanation/Reference: QUESTION 284 Which two would you recommend to an application developer for reducing locking conflicts on tables in an Oracle database? (Choose two.) A. Create objects in locally managed tablespaces with Automatic Segment Space Management (ASSM) enabled. B. Avoid coding long-running transactions. C. Allow the database to handle locks ln default locking mode. D. Create objects in locally managed tablespaces with manual segment space management enabled. E. Enable undo retention guarantee. Correct Answer: BC Section: (none) Explanation Explanation/Reference: QUESTION 285 Which three functions can be performed by the SQL Tuning Advisor? (Choose three.) A. recommending creation of indexes based on SQL workload B. recommending restructuring of SQL statements that have suboptimal plans C. checking schema objects for missing and state statistics D. recommending optimization of materialized views E. generating SQL profiles Correct Answer: BCE Section: (none) Explanation Explanation/Reference: QUESTION 286 Examine the parameters:
Image of page 132
Users complain that their sessions for certain transactions hang. You investigate and discover that some users fail to complete their transactions, causing other transactions to wait on row-level locks. Which two actions would you take to prevent this problem? (Choose two.) A. Increase the maximum number of ITL slots for segments on which a blocking user performs a transaction. B. Decrease the SESSIONS_PER_USER limit in the profiles assigned to blocking users. C. Set a limit in the profiles of blocking users to control the number of data blocks that can be accessed in a session. D. Use Database Resource Manager to automatically kill the sessions that are idle and are blocking other sessions. E. Decrease the IDLE_TIME resource limit in the profiles assigned to blocking users. Correct Answer: DE Section: (none) Explanation Explanation/Reference: QUESTION 287 Which statement is true about the loss of a data file belonging to the default undo tablespace? A. The database remains open in read-only mode. B. The database is put in MOUNT state and requires recovery to be opened.
Image of page 133
Image of page 134

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