1Z0-058 | All About Practical 1Z0-058 exam question
Q1. Assuming a RAC database called ORCL, select three statements that correctly demonstrate management actions for the AP service.
A. To start the AP service, execute: srvctl start service -d ORCL -s AP
B. To disable the AP service on the ORCL4 instance, execute: srvctl disable service -d ORCL -s AP -i ORCL4
C. To stop the AP service, execute: srvctl stop service -s AP
D. To make ORCL5 a preferred instance for the AP service, execute: srvctl set service -d ORCL -s AP -i ORCL5 -r
E. To relocate the AP service from the ORCL5 instance to the ORCL4 instance, execute: srvctl relocate service -d ORCL -s AP -i ORCL5 -t ORCL4
Answer: A,B,E
Explanation:
SRVCTL Command Reference
srvctl start service -d db_unique_name
[-s "service_name_list" [-n node_name | -i instance_name]]
[-o start_options]
srvctl disable service -d db_unique_name
-s "service_name_list" [-i instance_name | -n node_name]
srvctl stop service -d db_unique_name [-s "service_name_list"
[-n node_name | -i instance_name] [-f]
srvctl relocate service -d db_unique_name -s service_name
{-c source_node -n target_node | -i old_instance_name -t new_instance_name}
[-f]
Oracle. Real Application Clusters Administration and Deployment Guide
11g Release 2 (11.2)
Q2. Under which account(s) can the Oracle Clusterware processes run for the Linux platform?
A. only the root account
B. only the Grid Infrastructure owner account
C. only the database software owner account
D. some under the Grid Infrastructure owner account and some under the root account
E. some under the database software owner account and some under the root account
Answer: D
Explanation: Because Oracle Clusterware works closely with the operating system, system administrator privileges are required for some installation tasks. In addition, some Oracle Clusterware processes must run as the special operating system user, root.
Oracle Database 2 Day + Real Application Clusters Guide
Q3. When creating an Oracle Cluster database using DBCA the "Memory size (SGA and PGA)” field is supplied on value of 2000 MB. Identify the default block Size used for the database.
A. 2 KB
B. 4 KB
C. 8 KB
D. 16 KB
E. 32 KB
Answer: C
Explanation: Type of LimitLimit Value
Minimum2k.Must be a multiple of operating system physical block size MaximumOperating system dependent, but never more than 32 KB
DBCA tab sizing
In this tab, you specify the smallest block size and the maximum number of operating system user processes that can simultaneously connect to the database. In the Block Size list, enter the size in bytes or accept the default. Oracle Database data is stored in these blocks. One data block corresponds to a specific number of bytes of physical space on disk. While using pre-defined templates, this field is not enabled since the database will be created with the default block size of 8 KB. But while using the custom option, you can change block size. Selecting a block size other than the default 8 KB value requires advanced knowledge and should only be done when absolutely required.
Oracle. Database 2 Day DBA
Q4. Examine the set of commands given below: Which statement is true in this scenario?
A. All the instances of the RACDB will have the TRACE_ENABLED parameter with the value TRUE because this parameter must have the same value on all the instances.
B. All the instances of the RACDB will have the TRACE_ENABLED parameter with the value TRUE except the RACDB_1 instance, which will have the value FALSE for this parameter.
C. All the instances of the RACDB will have the TRACE_ENABLED parameter with the value TRUE because the first ALTER statement has higher precedence.
D. All the instances of the RACDB will nave the TRACE_ENABLED parameter with the value FALSE because the second ALTER statement has higher precedence.
Answer: B
Explanation: Section: (none)
SPFILE Parameter Values and RAC
untitled
Q5. The DBA has executed the command:
srvctl add service -d PROD -s BATCH -g SP2 -c singleton -y manual
What is the result of this command?
A. Creates a singleton service named batch using the server pool sp2 with a manual service management policy.
B. Creates a singleton service named batch for the prod database by using only server pool SP2 with a manual service management policy.
C. Creates a singleton service named batch, which runs by default in the prod database by using the server pool SP2 with a manual service management policy, but can fail over to other databases.
D. Creates a singleton service, which is only used for batch workloads for the prod database by using only server pool sp2 with a manual service management policy.
Answer: B
Explanation:
srvctl add service Adds services to a database and assigns them to instances. If you have multiple instances of a cluster database on the same node, then always use only one instance on that node for all of the services that node manages.
untitled
Oracle. Real Application Clusters Administration and Deployment Guide 11g Release 2 (11.2)
Q6. A policy-managed RAC database that hosts the ACCOUNTS service has only three instances running rather than the usual four on a six-node cluster.
Five of the six cluster nodes are active and the sixth (RACNODE6) is down for maintenance.
You decide to check the state of the servers in the server pools to see if there are problems with the OLTP pool to which the ACCOUNTS service has been assigned.
You used the ctsctl status server -f command and see that the RACNODE3 node has STATE=VISIBLE.
What is true about this situation?
A. The Cluster Synchronization Services Daemon (CSSD) is running RACNODE3 is considered to be part of the cluster, but the Cluster Ready Services Daemon (CRSD) is currently not running.
B. Both the Cluster Ready Services Daemon (CRSD) and the Cluster Synchronization Services Daemon (CSSD) are running on RACNODE3, but RACNODE3 is currently being moved to another server pool.
C. The Cluster Ready Services Daemon (CRSD) is running and RACNODE3 is considered to be part of the cluster, but the Cluster Synchronization Services Daemon (CSSD) is currently not running.
D. Neither the Cluster Ready Services Daemon (CRSD) nor the Cluster Synchronization Services Daemon (CSSD) is running on RACNODE3.
Answer: A
Explanation:
untitled
Oracle. Clusterware Administration and Deployment Guide 11g Release 2 (11.2)
Q7. A third party application has provided files containing the command syntax required to register and manage the application for high availability with Oracle Grid Infrastructure.
The command to define the application is as follows:
crsctl add resource LongApp -type cluster_resource -attr "ACTION_SCRIPT=’/u01/ogi/scripts/longapp.scr’ , PLACEMENT=’restricted’ , HOSTING_MEMBERS=’RACNODE1 RACNODE2 , CHECK_INTERVAL=’30 ,START_DEPENDENCIES=’hard(LongAppvip)’ , STOP_DEPENDENCIES=’hard (LongAppvip)’, RESTART_ATTEMPTS=’2"
Which two statements are true about the behavior of this resource after it is added?
A. It will be a policy-managed resource using the server pool containing nodes RACNODE1 and RACNODE2.
B. The LongAppvip vip resource must be activated to successfully activate this resource, but wl not be activated automatically if not already active.
C. The LongAppvip vip resource must be stopped before this resource is stopped.
D. It will be an administrator-managed resource hosted by nodes RACNODE1 and RACNODE2.
Answer: B,D
Explanation:
Configurable Resource Attributes
HOSTING_MEMBERS
A space-separated, ordered list of cluster server names that can host a resource. This attribute is required only when using administrator management, and when the value of the PLACEMENT attribute is set to favored or restricted. When registering applications as Oracle Clusterware resources, use the SERVER_POOLS attribute, instead.
START_DEPENDENCIES
hard([intermediate:][global:]{resource_name | type:resource_type})—Specify a hard start dependency for a resource when you want the resource to start only when a particular resource or resource of a particular type starts. weak([concurrent:][global:][uniform:]{resource_name | type:resource_type})—Specify a weak start dependency for a resource when you want that resource to start despite whether named resources are running, or not. An attempt to start this resource also attempts to start any resources on which this resource depends if they are not running.
STOP_DEPENDENCIES
hard([intermediate:][global:][shutdown:]{resource_name | type:resource_type})—Specify a hard stop dependency for a resource that you want to stop when named resources or resources of a particular resource type stop.
Oracle. Clusterware Administration and Deployment Guide 11g Release 2 (11.2)
Q8. Examine the following details from the AWR report for your three-instance RAC database:
Which inferences is correct?
A. There are a large number of requests for cr blocks or current blocks currently in progress.
B. Global cache access is optimal without any significant delays.
C. The log file sync waits are clue to cluster interconnect latency.
D. To determine the frequency of two-way block requests you must examine other events In the report.
Answer: B
Explanation:
Analyzing Cache Fusion Transfer Impact Using GCS Statistics This section describes how to monitor GCS performance by identifying objects read and modified frequently and the service times imposed by the remote access. Waiting for blocks to arrive may constitute a significant portion of the response time, in the same way that reading from disk could increase the block access delays, only that cache fusion transfers in most cases are faster than disk access latencies. The following wait events indicate that the remotely cached blocks were shipped to the local instance without having been busy, pinned or requiring a log flush:
gc current block 2-way gc current block 3-way gc cr block 2-way gc cr block 3-way
The object statistics for gc current blocks received and gc cr blocks received enable quick identification of the indexes and tables which are shared by the active instances. As mentioned earlier, creating an ADDM analysis will, in most cases, point you to the SQL statements and database objects that could be impacted by interinstance contention. Any increases in the average wait times for the events mentioned in the preceding list could be caused by the following occurrences: High load: CPU shortages, long run queues, scheduling delays Misconfiguration: using public instead of private interconnect for message and block traffic If the average wait times are acceptable and no interconnect or load issues can be diagnosed, then the accumulated time waited can usually be attributed to a few SQL statements which need to be tuned to minimize the number of blocks accessed. Oracle. Real Application Clusters Administration and Deployment Guide 11g Release 2 (11.2)
Q9. Which are the key factors that you should consider before converting a single-Instance database Oracle Real Application Cluster (RAC) database to guarantee a successful media recovery?
A. If the database is in archive log mode, the archive file format requires a thread number.
B. The archive logs from all nodes must be accessible to all nodes in the cluster database.
C. The storage option must be Automatic Storage Management (ASM).
D. All database files must be migrated to Oracle Managed Files (OMF).
Answer: A,B
Explanation:
Issues for Converting Single Instance Databases to Oracle RAC
Backup procedures should be available before conversion takes place.
Archiving in Oracle RAC environments requires a thread number in the archive file format.
The archived logs from all instances of an Oracle RAC database are required for media recovery.
By default, all database files are migrated to Oracle Managed Files (OMF).
D60488GC11
Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 11 - 24
Q10. mounted: DATA and DATA2, but the results of the SHOW PARAMETER ASM_DISKGROUPS command show only DATA as below:
What could have caused the DATA2 dlskgroup to be mounted based on the information injthe V $ASM_DISKGROUP view?
A. The DATA2 diskgroup contains the database files required to start a database instance that depends on this ASM instance.
B. The DATA2 diskgroup contains the voting files required for this cluster.
C. The DATA diskgroup has mirrored objects in the DATA2 diskgroup.
D. The DATA value In the parameter implies all diskgroup strings starting with data.
E. The DATA2 diskgroup contains the SPFILE needed to start the ASM instance.
Answer: B
Explanation:
Disk Groups Mounted at Startup
At startup, the Oracle ASM instance attempts to mount the following disk groups:
Disk groups specified in the ASM_DISKGROUPS initialization parameter Disk group used by Cluster Synchronization Services (CSS) for voting files Disk groups used by Oracle Clusterware for the Oracle Cluster Registry (OCR) Disk group used by the Oracle ASM instance to store the ASM server parameter file (SPFILE)
D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 7 - 5