B they instruct the maintenance job to collect

This preview shows page 73 - 76 out of 152 pages.

B. They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan. C. They are used to gather only missing statistics. D. They are created for a query expression where statistics are missing or the cardinality estimates by the
Image of page 73
optimizer are incorrect. E. They instruct the optimizer to create only column group statistics. F. Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace. Correct Answer: BDF Section: (none) Explanation Explanation/Reference: QUESTION 132 You want to flash back a test database by five hours. You issue this command: SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24); Which two statements are true about this flashback scenario? (Choose two.) A. The database must have multiplexed redo logs for the flashback to succeed. B. The database must be MOUNTED for the flashback to succeed. C. The database must use block change tracking for the flashback to succeed. D. The database must be opened in restricted mode for the flashback to succeed. E. The database must be opened with the RESETLOGS option after the flashback is complete. F. The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN. Correct Answer: BE Section: (none) Explanation Explanation/Reference: Explanation: QUESTION 133 Examine these two statements: Which three are true about the MRKT tablespace? (Choose three.) A. The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files. B. The MRKT tablespace may be dropped if it has no contents. C. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace. D. No more data files can be added to the tablespace. E. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.
Image of page 74
Correct Answer: CDE Section: (none) Explanation Explanation/Reference: Explanation: QUESTION 134 In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time. How would you accomplish this? A. Setting a metric threshold B. Implementing Database Resource Manager C. Enabling resumable timeout for user sessions D. Decreasing the value of the IDLE_TIME resource limit in the default profile Correct Answer: B Section: (none) Explanation Explanation/Reference: QUESTION 135 You Execute the Following command to create a password file in the database server: $ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’ Which two statements are true about the password file? (Choose two.) A. It records the usernames and passwords of users when granted the DBA role.
Image of page 75
Image of page 76

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