READ Free Dumps For Oracle- 1z0-050
| Question ID 6025 | You are managing an Oracle 11 g 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? (Choose two.) |
| Option A | The ASM-preferred mirror read feature is enabled. |
| Option B | The ASM supports variable sizes for extents of 1. 8. and 64 allocation units. |
| Option C | The ASM disk is dropped immediately from a disk group when it becomes unavailable. |
| Option D | The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group. |
| Correct Answer | A,B |
| Question ID 6026 | You set the following parameters in the parameter file and restarted the database: MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90M SGA TARGET=270M Which two statements are true regarding these parameters after the database instance is restarted? (Choose two.) |
| Option A | The MEMORY_MAX_TARGET parameter is automatically set to 500 MB. |
| Option B | The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually. |
| Option C | The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero. |
| Option D | The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB and 270 MB, respectively. |
| Correct Answer | A,D |