OCP 11 Space Management and Partitioning

Card Set Information

Author:
Tralala
ID:
213630
Filename:
OCP 11 Space Management and Partitioning
Updated:
2013-04-15 09:19:48
Tags:
OCP 11 Space Management Partitioning
Folders:

Description:
OCP 11 Space Management and Partitioning
Show Answers:

Home > Flashcards > Print Preview

The flashcards below were created by user Tralala on FreezingBlue Flashcards. What would you like to do?


  1. When creating a system-partitioned table, what do you specify?
    The partitions you want to define, but not a partitioning key
  2. What is the impact on memory usage when using table compression?
    Memory usage is lower.
  3. Which clause should you include with the CREATE TABLE statement to create a system-partitioned table?
    The PARTITION BY SYSTEM clause
  4. In 11g, which type of partitioning expands the functionality of range partitioning by automatically creating range partitions?
    Interval partitioning
  5. At which three levels can compression be enabled?
    The table, tablespace, and partition levels
  6. Which clause of the ALTER TABLE statement shrinks the EMP table and its dependent segments to release the unused space below and above the High Water Mark (HWM) of the segments?
    The SHRINK SPACE CASCADE clause
  7. When using interval partitioning, when are partitions for an interval automatically created?
    When the inserted data exceeds all of the table's existing range partitions
  8. Which two clauses should you include with the CREATE TABLE statement to create an interval-partitioned table?
    The PARTITION BY RANGE and INTERVAL clauses
  9. When using interval partitioning, what is the maximum number of partitioning key columns you can specify?
    One
  10. If you specify the COMPRESS clause of the ALTER TABLE statement but do not specify a FOR option, are rows inserted with an INSERT statement compressed?
    No, only those inserted during bulk load operations
  11. Which type of partitioning involves logically partitioning two tables that have a parent-child relationship?
    Reference partitioning
  12. When using reference partitioning and partition pruning and partitionwise joins, must query predicates be identical?
    No, they can be different.
  13. What are the three levels at which the Segment Advisor can be invoked?
    The segment level, the tablespace level, or the object level
  14. What is the impact on disk space when using table compression?
    It reduces the disk space used.
  15. When using interval partitioning, which requirement must partitions meet if you want to merge them using the ALTER TABLE...MERGE PARTITIONS statement?
    The partitions must be adjacent.
  16. What is the clause of the ALTER TABLE statement used to shrink a table?
    The SHRINK SPACE clause
  17. Which type of partitioning does not support partition pruning and partitionwise joins?
    System partitioning
  18. For which type of tables is interval partitioning not supported?
    Index-organized tables
  19. What is the result on an existing table's rows if you issue an ALTER TABLE...COMPRESS FOR ALL OPERATIONS; statement?
    Existing rows are not compressed, but future inserted and updated rows will be.
  20. When using interval partitioning, what must be the data type of the partitioning key column you specify?
    NUMBER or DATE
  21. Which type of tablespaces do not support the alerts based on the default threshold limits and the use of the DBMS_SERVER_ALERT package?
    Dictionary-managed tablespaces
  22. When using table compression, is more or less CPU used when performing DML and direct loading?
    More
  23. With a system-partitioned table, which DML statement requires special partition extended syntax?
    An INSERT statement
  24. Which type of partitioning allows you to partition a table into a specific number of partitions without using a partitioning key?
    System partitioning

What would you like to do?

Home > Flashcards > Print Preview