首页计算机考试Oracle认证
(单选题)

In which cases is reference partitioning effective in enhancing performance?()  

A It is effective only in partition pruning.

B It is effective only in partitionwise joins provided that the query predicates are different from the partitioning key.

C It is effective in both partition pruning as well as partitionwise joins provided that the query predicates are identical to the partitioning key.

D It is effective in both partition pruning as well as partitionwise joins irrespective of whether the query predicates are different from or identical to the partitioning key.

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    Which built-in do you use to determine which timer in form module has expired?()

    答案解析

  • (多选题)

    In which three cases does a checkpoint occur? ()

    答案解析

  • (多选题)

    In which scenarios would you rebuild an index?()

    答案解析

  • (多选题)

    In which two conditions are resumable statements suspended?()

    答案解析

  • (多选题)

    In which three situations is incomplete recovery required?()

    答案解析

  • (单选题)

    Which capability exists only in java.io.FileWriter?()

    答案解析

  • (单选题)

    In which scenario will you create a hash cluster?()

    答案解析

  • (单选题)

    In which scenario will you perform an incomplete recovery?()

    答案解析

  • (多选题)

    Identify two situations in which the block header grows in a data block. ()

    答案解析

快考试在线搜题