Oracle 1Z0-058 問題集

質問 1：
Which three statements are true about services and the Resource Manager?
A. The Resource Manager can manage the relative priority of services within an instance by binding services directly to consumer groups if services are mapped to consumer groups by the DB
B. When a client connects using a service, the service can be mapped to a consumer group, enabling the Resource Manager to manage work requests by service in the order of their importance.
C. The Resource Manager offers benefits In managing workloads because priority is given to business functions rather than the sessions that support those business functions.
D. The srvctl utility is used to map services to consumer groups.
正解：A,B,C
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Examine the following output:
[oracle@gr5153~]$srvctl add service -d RACDB -s erp -g pool1 -c uniform -y manual
[oracle0gr5153~]$srvctl start service -d RACDB -s ERP
[oracle@gr5153~]$crsctl stat res ora.racdb.erp.svc NAME=ora.racdb.erp.svc TYPE=ora.service.type
TARGET=ONLINE, ONLINE, ONLINE STATE=ONLINE on gr5118, ONLINE on gr5152, ONLINE on gr5153
[oracle@gr5153~]$ srvctl config database -d RACDB
Database unique name: RACDB
Database name: RACDB Oracle home:/u01/app/oracle/product/11.2.0/dbhome_1 Oracle user:oracle Spfile:+DATA/RACDB/spfileRACDB.ora Domain: Start options:open Stop options:immediate Database role:PRIMARY Management policy:AUTOMATIC Server pools:POOL 1 Database instances: Disk Groups:DATA, FRA Services:ERP
Database is policy managed $srvctl stop database -d RACDB -o immediate
Which two statements are true regarding the srvctl stop command?
A. It will shut down only the database instance on the node on which the command is executed.
B. It will shut down only the RACDB instance and the ERP service on the node on which the Command is executed.
C. It will stop the ERP service related to the RACDB database on all the nodes.
D. It will shut down all the instances of the RACDB database.
正解：C,D
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Examine the following details for a six-Instance RAC database: What is the most prominent problem indicated by the above output?

A. CPU saturation and memory depletion
B. large number of untuned queries from one of the nodes
C. high input/output (I/O) delays
D. misconfigured or faulty interconnect
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 4：
The Oracle Grid Infrastructure administrator decides to make more copies of the voting disks that are currently stored in the ASM disk group +VOTE. How can this be done?
A. by running crsctl replace votedisk +asm_disk_group on another disk group that has greater redundancy, thereby causing additional copies to be created
B. by running crsctl add css votedisk <path_to_new_voting_disk> to make a copy to a shared location on a shared device or file system
C. by running crsctl add css votedisk +VOTE, thereby adding another copy of the voting disk to the +VOTE disk group
D. by running srvctl replace votedisk +asm_disk_group on another disk group that has greater redundancy, thereby causing additional copies to be created
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which three statements are true about the management of Oracle Services?
A. Oracle Enterprise Manager or SRVCTL should be used to control cluster-managed services, not DBMS_SERVICE.
B. To manage workloads or a group of applications, you can define services for a particular application or a subset of an application's operations.
C. Similar work can be categorized under services to ease workload management.
D. Users who share a service should have different service-level requirements.
正解：A,B,C
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which three statements ate true about services and Transparent Application Failover (TAF)?
A. TAF can restart a query after failover has completed but for other statements, such as INSERT, UPDATE, or DELETE, the application must resubmit the transaction.
B. Services simplify the deployment of TAF because by defining a TAF policy for a service, all connections using this service will automatically have TAF enabled.
C. If TAF has been configured for a service, sessions using that service fail over to a surviving instance when an outage occurs.
D. The TAF setting for a client connection overrides any TAF setting in the service definition.
E. The TAF setting on a service can be NONE, BASIC, PRECONNECT, or POSTCONNECT, and overrides any TAF setting in the client connection definition.
正解：B,C,E
解説: (Topexam メンバーにのみ表示されます)

質問 7：
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 SCAN listener resources must be removed and added to obtain the new SCAN IP addresses from DHCP.
C. The SCAN VIPs and node VIPs must be reconfigured by using oifcfg.
D. The SCAN VIPs and node VIPs must be reconfigured using srvctl.
E. The Interconnect must be reconfigured by using srvctl.
正解：A,C
解説: (Topexam メンバーにのみ表示されます)