多项选择题
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.
相关考题
-
多项选择题
WhichstatementsaretrueregardingtheconceptofproblemsandincidentsinthefaultdiagnosabilityinfrastructureforOracleDatabase11g？（）
A. Only the incident metadata and dumps are stored in the Automatic Diagnostic Repository （ADR）.
B. The problem key is the same as the incident number.
C. The database sends an incident alert to the Oracle Enterprise Manager Database Home page.
D. Every problem has a problem key， which is a text string that describes the problem.
E. The database makes an entry into the alert log file when problems and incidents occur. -
多项选择题
WhichthreestatementsaretrueregardingthefunctioningoftheAutotaskBackgroundProcess（ABP）？（）
A. It creates jobs without considering the priorities associated with them.
B. It translates tasks into jobs for execution by the scheduler.
C. It determines the list of jobs that must be created for each maintenance window.
D. It is spawned by the MMON background process at the start of the maintenance window.
E. It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks. -
多项选择题
You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario？（）
A. The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.
B. RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.
C. The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.
D. ASM compatibility controls which features for the ASM will be enabled.
