Oracle Partitioning

12 Questions

Settings
Please wait...
Oracle Quizzes & Trivia

Questions and Answers
  • 1. 
    Which of the following is an advantage of partitioning?
    • A. 

      Complexity

    • B. 

      Inconsistent access speed

    • C. 

      Extra space

    • D. 

      Security

  • 2. 
    Partitioning can dramatically degrade performance…
    • A. 

      TRUE

    • B. 

      FALSE

  • 3. 
    Who Partitions?
    • A. 

      DBA

    • B. 

      Developer

    • C. 

      Project Manager

    • D. 

      None

  • 4. 
    What is the max limit of partitions in a table?
    • A. 

      1000

    • B. 

      100

    • C. 

      1 mn

    • D. 

      1 bn

  • 5. 
    Which of the below is not part of partitioning?
    • A. 

      HASH

    • B. 

      Interval

    • C. 

      System

    • D. 

      Virtual Column

    • E. 

      REF

    • F. 

      Logical

  • 6. 
    Cardinality is important for choosing a key for hash partitioning.
    • A. 

      True

    • B. 

      False

  • 7. 
    Hash Portioning allows following operation/s (Multiple)
    • A. 

      Splitting partitions.

    • B. 

      Dropping partitions

    • C. 

      Merging partitions

    • D. 

      Adding partitions

    • E. 

      Coalesced partitions

  • 8. 
    Range partition table can be converted to INTERVAL partitioning. This statement is
    • A. 

      False

    • B. 

      True

  • 9. 
    Interval Partitioning can be used for IOTs
    • A. 

      False

    • B. 

      True

  • 10. 
    We can partition without partition key
    • A. 

      True

    • B. 

      False

  • 11. 
    We can relate partitions in parent-child relation with PK and FK in
    • A. 

      System Partitioning

    • B. 

      Constraint Partitioning

    • C. 

      Ref Partitioning

    • D. 

      None of above

  • 12. 
    We can add multiple partitions in a single ALTER statement
    • A. 

      False

    • B. 

      True