Oracle
1Z0-043 · Question #72
You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. You have two disk groups, DG1 and DG2 with one device each. In the parameter file of the…
The correct answer is A. When a new log group is added, it would have one member in each disk group. See the full explanation below for the reasoning.
Question
You are using an Automatic Storage Management (ASM) instance to manage the files of your production database. You have two disk groups, DG1 and DG2 with one device each. In the parameter file of the production database, the following parameters have been specified:
DB_CREATE_ONLINE_LOG_DEST_1 = '+dg1' DB_CREATE_ONLINE_LOG_DEST_2 = '+dg2' What would be the impact of this setting?
Options
- AWhen a new log group is added, it would have one member in each disk group.
- BWhen a new log group is added, it would have two members in each disk group.
- CWhen a new tablespace is added, it would have one data file in each disk group.
- DWhen a new log file is added, it would have one member spread across the disk groups.
How the community answered
(35 responses)- A77% (27)
- B14% (5)
- C6% (2)
- D3% (1)
Community Discussion
No community discussion yet for this question.