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.
正确答案
答案解析
相似试题
(多选题)
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?()