Index and Table Enhancement Q & A - Chapter 17 - Index and Table Enhancement

Q & A - Index and Table Enhancement Q & A - Chapter 17 - Index and Table Enhancement

Index and Table Enhancement Q & A Chapter 17 - Index and Table Enhancement

  • 1.

    Examine the following command:
    ALTER SYSTEM SET enable_ddl_logging=FALSE;
    Which statement is true?

    ANone of the data definition language (DDL) statements are logged in the trace file.

    BOnly DDL commands that resulted in errors are logged in the alert log file.

    CA new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.

    D Only DDL commands that resulted in the creation of new database files are logged.

  • 2.

    Examine the following command:
    ALTER SYSTEM SET enable_ddl_logging=FALSE;
    Which statement is true?

    ANone of the data definition language (DDL) statements are logged in the trace file.

    BOnly DDL commands that resulted in errors are logged in the alert log file.

    CA new log.xml file that contains the DDL statements is created, and the DDL command details are removed from the alert log file.

    DOnly DDL commands that resulted in the creation of new database files are logged.

  • 3.

    In order to exploit some new storage tiers that have been provisioned by a storage
    administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?
    Both local and global partitioned B-tree Indexes are defined on the table.
    A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.
    Minimal disrupt ion to availability is required.
    Which three statements are true about this requirement?
    A. The partitions can be moved online to new tablespaces.
    B. Global indexes must be rebuilt manually after moving the partitions.
    C. The partitions can be compressed in the same tablespaces.
    D. The partitions can be compressed in the new tablespaces.
    E. Local indexes must be rebuilt manually after moving the partitions.

    AA,B and C

    BB,C and D

    CC,D and E

    DD,E and A

    EA,B and D

© 2015 by Learncertification All Rights Reserved. The certification names are the trademarks of their respective owners. Terms & Privacy Policy