Oracle 1Z0-058 問題集

質問 1：
An ASM diskgroup that contains database tablespaces with six disks and normal redundancy is nearing 90% capacity. You want to add additional capacity to the diskgroup. A set of six additional disks has been made available, and appears as CANDIDATE disks in the V$ASM_DISK view.
What steps are required to increase the diskgroup capacity?
A. Set the rebalance power limit (or allow it to default).
Add the disks to the diskgroup.
B. Shut down the database instances using the diskgroup.
Add the disks to the diskgroup.
Start the database instances using the diskgroup.
C. Export the database objects.
Drop the diskgroup.
Create a new diskgroup.
Import the database objects.
D. Shut down all database instances and ASM instances.
Back up the ASM diskgroup.
Start the ASM instances.
Add the disks to the diskgroup.
Issue a rebalance command.
Start the database instances.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which four statements are true about services and connection load balancing?
A. Services provide the ability to balance client connections across the instances in an Oracle RAC configuration.
B. In a RAC database environment, you should select only one load balancing method.
C. With server-side load balancing, the listener directs a connection request to the best instance that is currently providing the service based on the load-balancing options selected by the DBA.
D. Client-side load balancing balances the connection requests across the listeners.
E. There are two types of load balancing that you can implement; load balancing decisions can be made by the client and by the listener.
正解：A,C,D,E
解説: (Topexam メンバーにのみ表示されます)

質問 3：
You enter the following command: crsctl status resource MyApp
You get this output: NAME=MyApp
TYPE=cluster_resource TARGET=ONLINE STATE=ONLINE on RACNODE4
MyApp is a policy-managed resource using a server pool with two nodes called RACNODE3 and RACNODE4 and has a cardinality of 1.
What are the meanings of the target and state status values?
A. MyApp is currently active on RACNODE4 and is meant to be active only on RACNODE4.
B. MyApp is active on RACNODE4 and was manually started.
C. MyApp is meant to be active, is currently active on RACNODE4, but the Grid Infrastructure may start MyApp on RACNODE3 due to failovers.
D. MyApp should also be online on RACNODE3 because it is a cluster_resources type that must be active on at least two nodes in the cluster, thereby overriding the CARDINALITY attribute.
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 4：
I he ASM instance in your environment can support databases from version 10.2.0.4 through
11.2.0.1 You want to use all ASM functionality possible for each database, including OCR and voting files In the ASM. What is the proper setting for the ASM diskgroup attribute on diskgroups being used by all the instances?
A. Set compatible.asm to 10.2 and compatible.rdbms to 10.2
B. Set compatible.asm to 11.2 and compatible.rdbms to 11.2
C. Set compatible.asm to 11.2 and compatible.rdbms to 10.2
D. Set compatible.asm to 10.2 and compatible.rdbms to 11.2
正解：C
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which two Cluster ware stack administration actions must be performed as the root user?
A. starting the Clusterware manually on one node
B. checking the health and viability of the Clusterware on all nodes
C. checking the health of the Clusterware on one node
D. listing the location of the voting disks
E. disabling the Clusterware from automatic start at node reboot
正解：A,E
解説: (Topexam メンバーにのみ表示されます)

質問 6：
You notice that there is a very high percentage of wait time for the 'enq:HW-contention' event in your RAC database that has frequent insert operations.
Which two recommendations may reduce this problem?
A. using reverse key indexes
B. automatic segment space management
C. smaller extent sizes
D. uniform and large extent sizes
E. increasing sequence cache sizes
F. shorter transactions
正解：B,D
解説: (Topexam メンバーにのみ表示されます)

質問 7：
Which two statements are true about ACFS snapshots?
A. They can be created for ACFS file systems only if the ASM disk group hosting the ADVM volume file used by the file system has free space available.
B. They can be created only if the ASM disk group hosting the ADVM volume used by the file system has no other ASM files contained in the disk group.
C. They can be created for ACFS file systems only if the ADVM volume file used by the file system has free space available.
D. They are accessible only on the cluster node that was used when creating the snapshot.
E. They can be created when ACFS is used both on clusters and on stand-alone servers.
正解：C,E
解説: (Topexam メンバーにのみ表示されます)