None oracle ignores any password file therefore

This preview shows page 51 - 53 out of 152 pages.

none Oracle ignores any password file. Therefore, privileged users must be authenticated by the operating system. Note: The REMOTE_OS_AUTHENT parameter is deprecated. It is retained for backward compatibility only. QUESTION 88 A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle); You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows. What could be a reason for this recommendation? A. The keep pool is not configured. B. Automatic Workarea Management is not configured. C. Automatic Shared Memory Management is not enabled. D. The data blocks in the SUBSCRIBE_LOG table are rarely accessed. E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view. Correct Answer: D Section: (none) Explanation Explanation/Reference: Explanation: The most of the rows in SUBSCRIBE_LOG table are accessed once a week. QUESTION 89 Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)? (Choose three.) A. Tracking the most recent read time for a table segment in a user tablespace B. Tracking the most recent write time for a table segment in a user tablespace C. Tracking insert time by row for table rows D. Tracking the most recent write time for a table block E. Tracking the most recent read time for a table segment in the SYSAUX tablespace F. Tracking the most recent write time for a table segment in the SYSAUX tablespace Correct Answer: ABD Section: (none) Explanation Explanation/Reference: Explanation: Incorrect: Not E, Not F When Heat Map is enabled, all accesses are tracked by the in-memory activity tracking module. Objects in the SYSTEM and SYSAUX tablespaces are not tracked. * To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and modification. Heat Map provides data access tracking at the segment-level and data modification tracking at the segment
Image of page 51
and row level. * To implement your ILM strategy, you can use Heat Map in Oracle Database to track data access and modification. You can also use Automatic Data Optimization (ADO) to automate the compression and movement of data between different tiers of storage within the database. References: QUESTION 90 Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c? (Choose two.) A. ALTER TABLE SPLIT PARTITION B. ALTER TABLE MERGE PARTITION C. ALTER TABLE TRUNCATE PARTITION D. ALTER TABLE ADD PARTITION E. ALTER TABLE DROP PARTITION F. ALTER TABLE MOVE PARTITION Correct Answer: CE Section: (none) Explanation Explanation/Reference: Explanation: Asynchronous Global Index Maintenance for DROP and TRUNCATE PARTITION This feature enables global index maintenance to be delayed and decoupled from a DROP and TRUNCATE partition without making a global index unusable. Enhancements include faster DROP and TRUNCATE partition operations and the ability to delay index maintenance to off-peak time.
Image of page 52
Image of page 53

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