单选题

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. ()

    多选题查看答案