多项选择题
Which two statements are true regarding an Automatic Storage Management (ASM) instance?（） (Choose two.)
A. As ASM instance mounts an ASM control file
B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group
C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly
D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started
相关考题
-
单项选择题
WhichofthefollowingisapotentialperformancetuningrecommendationfromtheSQLAccessAdvisor？（）
A. Create new indexes.
B. Modify existing indexes.
C. Implement partitioning on a nonpartitioned table.
D. Create materialized views.
E. All of the above -
单项选择题
WhichoftheseappropriatelydescribestheresultsofamanualSQLTuningAdvisortask？（）
A. A list of SQL statements and recommendations for tuning
B. A list of SQL statements that have been tuned by the Advisor，with before and after metrics
C. Graphs showing the actual performance improvement made by the Advisor after it implemented the recommended changes
D. All of the above -
单项选择题
You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you are asked to change the retention period from 5 years to 3 years. To accomplish this, you issued the following command: ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEARS; What is the outcome of this command?（）
A. The command produces an error because the retention period cannot be reduced
B. All historical data older than 3 years is purged from the flashback archive FLA1
C. All historical data is retained but the subsequent flashback data archives are maintained for only 3 years
D. All historical data is transferred to flashback logs and the flashback archive is refreshed to set a new retention time
