The System Global Area (SGA) for the ASM instance contains distinct memory areas. Choose three areas that are contained within the ASM SGA. A. Shared Pool B. Buffer Cache C. Log Buffer D. Large Pool E. ASM Cache F. Streams…

You have two administrator-defined server pools on your eight-node cluster called OLTP and DSS. Hosts RACNODE3, RACNODE4, and RACNODE5 are currently assigned to the DSS Pool. Hosts RACNODE6, RACNODE7, and RACNODE8 are assigned to the OLTP Pool. Hosts RACNODE1 and…

The disk groups on the current ASM instance at version 11.2 were configured to support a version 10.2 database instance. The 10.2 instance has the COMPATIBLE parameter defined as 10.2.0. The compatible.asm attribute is set to 11.2 for each disk…

You are allocating space from the ASM disk group for an ADVM volume. What will be the volume extent and Volume Allocation Unit (VAU) if the stripe column is 4 and AU is 1 MB, which are the default values?…

Your network administrator informs you that the Internet service provider is being changed in a month’s time in conjunction with a data center move. You are asked to plan for the changes required in the Oracle Grid Infrastructure, which is…