Online Access Free 1Z0-058 Exam Questions

Which three statements are true about cluster (OCR) and local registries (OLR)?

• A.The ocrdump command can be used to dump the contents of either the cluster registry (OCR) or the local registry (OLR).
• B.After the cluster is created, the size of the OCR is static unless the Clusterware software Is upgraded.
• C.The ocrdump command can be used to dump information for a single OCR key.
• D.Information in the OCR is organized by keys that are associated with privileges. Therefore, the root user will see more information when using ocrdump than the grid user.

You have a four-node cluster with four node VIPS and three scan VIPS already In use after Oracle Grid Infrastructure installation.
You plan to manage a customer-developed, web-based application with the Oracle Grid Infrastructure to provide high availability.
Which two statements are true about the vip application resource that must be created?

• A.The vip application must be active on the same subnet and ethernet adaptor as the public ip Address.
• B.The vip application must be active on the same subnet and ethernet adaptor as the Interconnect.
• C.The vip application must not be online on the same node as any of the scan vips.
• D.The vip application must be active on a different node than the application depending on Che by using the dispersion start dependency in the resource definition.
• E.The vip application must be enabled to run as the root user.

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 set up to use GNS.
The IP addresses and subnets of the public network are to change.
Which two must be done in the Oracle Grid Infrastructure network setup to accommodate this change using the command-line Interfaces available?

• A.The interconnect must be reconfigured by using oifcfg, crsctl, and ifconfig.
• B.The SCAN VIPs and node VIPs must be reconfigured using srvctl.
• C.The Interconnect must be reconfigured by using srvctl.
• D.The SCAN VIPs and node VIPs must be reconfigured by using oifcfg.
• E.The SCAN VIPs and SCAN listener resources must be removed and added to obtain the new SCAN IP addresses from DHCP.

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.increasing sequence cache sizes
• C.smaller extent sizes
• D.shorter transactions
• E.automatic segment space management
• F.uniform and large extent sizes

You are managing a three-Instance RAC database. In the AWR report, you notice a gc current block busy wait event on one of the database Instances, in the cluster top timed events section.
What are two possible reasons for this wait event?

• A.Access to blocks was delayed as the blocks were pinned In exclusive mode for updates by some sessions.
• B.CPU shortages.
• C.Access to blocks was delayed by log writes on remote Instance.
• D.Frequently used select statements are causing high disk Input/output contention.