Partial global indexes save space and improve

This preview shows page 68 - 70 out of 152 pages.

and access for the partitioned object. Partial Global Indexes save space and improve performance during loads and queries. This feature supports global indexes that include or index a certain subset of table partitions or subpartitions, and exclude the others. This operation is supported using a default table indexing property. When a table is created or altered, a default indexing property can be specified for the table or its partitions. QUESTION 121 You use the segment advisor to help determine objects for which space may be reclaimed. Which three statements are true about the advisor given by the segment advisor? (Choose three.) A. It may advise the use of online table redefinition for tables in dictionary managed tablespace. B. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows. C. It may advise the use of online table redefinition for tables in locally managed tablespaces D. It will detect and advise about chained rows. E. It may advise the use of segment shrink for free list managed tables. Correct Answer: ACD Section: (none) Explanation Explanation/Reference:
Image of page 68
QUESTION 122 You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index. Which two are possible if table updates are performed which affect the invisible index columns? (Choose two.) A. The index remains invisible. B. The index is not updated by the DML statements on the indexed table. C. The index automatically becomes visible in order to have it updated by DML on the table. D. The index becomes unusable but the table is updated by the DML. E. The index is updated by the DML on the table. Correct Answer: AE Section: (none) Explanation Explanation/Reference: Explanation: Unlike unusable indexes, an invisible index is maintained during DML statements. Note: * Oracle 11g allows indexes to be marked as invisible. Invisible indexes are maintained like any other index, but they are ignored by the optimizer unless the OPTIMIZER_USE_INVISIBLE_INDEXES parameter is set to TRUE at the instance or session level. Indexes can be created as invisible by using the INVISIBLE keyword, and their visibility can be toggled using the ALTER INDEX command. QUESTION 123 In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container: Which two statements are true? (Choose two.) A. The C # # ROLE1 role is created in the root database and all the PDBs. B. The C # # ROLE1 role is created only in the root database because the container clause is not used. C. Privileges are granted to the C##A_ADMIN user only in the root database. D. Privileges are granted to the C##A_ADMIN user in the root database and all PDBs. E. The statement for granting a role to a user fails because the CONTAINER clause is not used.
Image of page 69
Image of page 70

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