多项选择题
You are managing an Oracle 11g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE.ASM attribute is set to 11.1.
Which two statements are true in this scenario for the features enabled for ASM? （）
A. The ASM-preferred mirror read feature is enabled.
B. The ASM supports variable sizes for extents of 1, 8, and 64 allocation units.
C. The ASM disk is dropped immediately from a disk group when it becomes unavailable.
D. The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.
相关考题
-
单项选择题
You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online. Which statement about performing user-managed backups in a 24x7 environment is true?（）
A. You must have change tracking enabled in your database
B. Your database must be running in NOARCHIVELOG mode
C. To back up a tablespace, it must be in backup mode
D. To back up a tablespace, it must first be taken offline -
多项选择题
View the Exhibit to examine the replay settings for replay parameters.What is the implication for setting the values for replay parameters?（）
A. The COMMIT order in the captured workload is preserved during replay.
B. The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls.
C. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured.
D. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying.
E. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins. -
多项选择题
Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window?（）
A. generating the SQL profile
B. testing and accepting the SQL profile
C. generating a list of candidate SQLs for tuning
D. adding tuned SQL plans into the SQL plan baseline
E. tuning each SQL statement in the order of importance
F. generating baselines that include candidate SQLs for tuning
