多选题

What two statements are true regarding the recommendations received from the SQL Access Advisor?()

A It cannot generate recommendations that support multiple workload queries.

B It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type.

C It can recommend partitioning only on tables that have at least 10,000 rows.

D It can recommend only B-tree indexes and not bitmap or function-based indexes.

正确答案

来源:www.examk.com

答案解析

相似试题
  • What two are the prerequisites for enabling Flashback Database?() 

    多选题查看答案

  • What are the two different types of database duplication?()

    多选题查看答案

  • What are two types of distributed destinations that Oracle WebLogic Sever supports ?()

    多选题查看答案

  • What are the two advantages of RMAN Block Media Recovery (BMR) over file-level recovery?()

    多选题查看答案

  • What are the two proper locations of deployment descriptors files inside of archives deployed to WebLogic?()

    多选题查看答案

  • What are the two advantages of RMAN Block Media Recovery (BMR) over file/x7flevel recovery?()

    多选题查看答案

  • You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback?()

    多选题查看答案

  • What two statements are true about Oracle Enterprise Manager’s Java Diagnostic tool, which makes the tool suitable for production server diagnostics ?()

    多选题查看答案

  • You plan to use static database registration for a new listener when you create it.What could be the two reasons for this?()

    多选题查看答案