单项选择题

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.

点击查看答案

上一题目录下一题

相关考题

单项选择题

You executed the following commands in a database session:

What could have caused the recycle bin to clean up?（）

A. There is demand for space from the new table
B. The undo tablespace does not have sufficient free space
C. The new table name is the same as the table name in the recycle bin
D. The temporary tablespace that is assigned to you does not have sufficient free space

单项选择题

Which setting enables the baselines by default in Oracle Database 11g？（）

A. setting the STATISTICS_LEVEL parameter to TYPICAL
B. adding filters to the Automatic Database Diagnostic Monitor （ADDM）
C. enabling Automated Maintenance Task using Oracle Enterprise Manager
D. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE

多项选择题

Which two statements are true regarding the SQL Repair Advisor？（）

A. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.
B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.
C. The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.
D. The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.