Act now and download your Oracle 1Z0-058 test today! Do not waste time for the worthless Oracle 1Z0-058 tutorials. Download Most up-to-date Oracle Oracle Real Application Clusters 11g Release 2 and Grid Infrastructure exam with real questions and answers and begin to learn Oracle 1Z0-058 with a classic professional.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-058 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1Z0-058 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1Z0-058-exam-dumps.html
Q61. 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 crsctl 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 and 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 Service 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 a 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: Cluster Synchronization Service daemon (CSSD)
An Oracle Clusterware component that discovers and tracks the membership state of each node by providing a common view of membership across the cluster. CSS also monitors process health, specifically the health of the database instance. The Global Enqueue Service Monitor (LMON), a background process that monitors the health of the cluster database environment and registers and de-registers from CSS.
Cluster Ready Services Daemon (CRSD)
The primary Oracle Clusterware process that performs high availability recovery and management operations, such as maintaining OCR. Also manages application resources and runs as root user (or by a user in the admin group on Mac OS X-based systems) and restarts automatically upon failure
STATE=VISIBLE
Servers that have Oracle Clusterware running, but not the Cluster Ready Services daemon (crsd), are put into the VISIBLE state. This usually indicates an intermittent issue or failure and Oracle Clusterware trying to recover (restart) the daemon. Oracle Clusterware cannot manage resources on servers while the servers are in this state.
Oracle Clusterware Administration and Deployment Guide
Q62. Examine the Exhibit.
*** Exhibit is Missing ***
Which three statements are correct?
A. Global Cache Block Access Latency indicates how many block transfers incurred a delay (busy) or an unexpected longer delay (congested).
B. Global Cache Block Access Latency indicates how many block transfers received blocks cached by other instances as well as blocks read from disk.
C. Global Cache Block Transfer Rate shows the total aggregated number of blocks received by all instances in the cluster over the interconnect.
D. Global Cache Block Transfer Rate is essentially a profile of how much work is performed in the local buffer cache, rather than the portion of remote references and physical reads, which both have higher latencies.
E. Global Cache Block Transfers and Physical Reads shows the percentage of read operations that retrieved blocks from disk, and the buffer cache of other instances using Cache Fusion.
F. Global Cache Block Transfers and Physical Reads shows the aggregated number of data blocks received by all instances in the cluster over the interconnect.
Answer: A,C,E
Explanation:
Global Cache Block Access Latency
The global cache access latency represents the end-to-end elapsed time for a block request. The request is timed from when the request is initiated until it completes. Cache transfer indicates how many current and CR blocks per block class were received from remote instances, including how many transfers incurred a delay (busy) or an unexpected longer delay (congested).
If accessing a database block of any class does not locate a buffered copy in the local cache, a global cache operation is initiated. Before reading a block from disk, an attempt is made to find the block in the buffer cache of another instance. If the block is present in another instance, a version of the block may be shipped. Two different kinds of blocks are distinguished: current and consistent read blocks. The average block receive time represents the end-to-end elapsed time or latency for a block request.
Global Cache Block Transfer Rate
The global cache block transfer rate shows the total aggregated number of data blocks received by all instances in the cluster by way of an interconnect. If a logical read fails to find a copy of the buffer in the local cache, it attempts to find the buffer in the database cache of a remote instance. If the block is present in another database, it is sent to the current instance.
Global Cache Block Transfers and Physical Reads
The chart represents the percentage of logical reads that read data from the buffer cache of other instances via Direct Memory Access and from disk. It is essentially a profile of how much work is performed in the local buffer cache, rather than the portion of non-local references that incur some latency overhead.
Active Sessions for Cluster Wait Class
The chart represents the active sessions for the cluster wait class. You can view the top modules and top SQL for a time period by selecting the time period in the active sessions chart. Oracle Enterprise Manager Online Help
Q63. Which interconnect design is NOT supported for Oracle Clusterware?
A. crossover cable design
B. single switch design
C. multiple switch design
D. redundant interconnect design
Answer: A
Explanation:
2.7.1 Network Hardware Requirements For the private network, the interface must support the user datagram protocol (UDP) using high-speed network adapters and switches that support TCP/IP (minimum requirement 1 Gigabit Ethernet). Note: UDP is the default interface protocol for Oracle RAC, and TCP is the interconnect protocol for Oracle Clusterware. You must use a switch for the interconnect. Oracle recommends that you use a dedicated switch. Oracle does not support token-rings or crossover cables for the interconnect. Oracle. Grid Infrastructure Installation Guide 11g Release 2 (11.2)
Q64. 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 all the instances of the RACDB database.
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 shut down only the database instance on the node on which the command is executed.
D. It will stop the ERP service related to the RACDB database on all the nodes.
Answer: A,D
Explanation: Shut down all Oracle RAC instances on all nodes. To shut down all Oracle RAC instances for a database, enter the following command, where db_name is the name of the database: srvctl stop database -d db_name Stops a database, its instances, and its services. When the database later restarts, services with AUTOMATIC management start automatically but services with MANUAL management policy must be started manually.
Oracle Real Application Clusters Administration and Deployment Guide
Q65. 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
Q66. Choose the two correct commands that will successfully create an ASM cluster file system
(ACFS) and register the mount point on a Linux/UNIX system.
A. mkfs -t asm /dev/asm/testvol-461 -n "testvol"
B. mkfs -t acfs /dev/asm/testvol-461 "testvol"
C. crsctl -r mountpoint /dev/asm/testvol-461 /u01/app/grid/acfsmounts/acfs_testvol
D. acfsutil registry -a -f /dev/asm/testvol-461 /u01/app/grid/acfsmounts/acfs_testvol
Answer: B,D
Explanation:
mkfs Purpose Creates an Oracle ACFS file system.
Syntax and Description mkfs -t acfs -h mkfs [-v] [-f]-t acfs [-b blocksize] [-n name ] volume_device [size]
Table 13-3 Options for the Linux mkfs command Option Description
acfsutil registry
Purpose Registers an Oracle ACFS file system with the Oracle ACFS mount registry. Syntax and Description acfsutil registry -h acfsutil registry acfsutil registry -a [-f] [-n { nodes|all } ] [-o moptions] device mount_point acfsutil registry -d {device | mount_point} acfsutil registry -l [device | mount_point]
acfsutil registry -m device
acfsutil registry -h displays help text and exits.
Oracle. Automatic Storage Management Administrator's Guide
11g Release 2 (11.2)
Q67. 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 group. The database has been upgraded to 11.2. Which statement indicates the proper time to change the compatible.rdbms disk group attribute to 11.2?
A. Change the disk group attribute after the database instance COMPATIBLE parameter is upgraded to 11.2.
B. Change the disk group attribute after the database instance is started with the 11.2 software.
C. Change the disk group attribute after the database instance optimizer_features_enabled parameter is set to 11.2.
D. Change each disk group after the 11.2 features are required for use on the disk group.
E. Never, upgrading the attribute is not reversible.
Answer: A
Explanation:
COMPATIBLE.RDBMS The value for the disk group COMPATIBLE.RDBMS attribute determines the minimum COMPATIBLE database initialization parameter setting for any database instance that is allowed to use the disk group. Before advancing the COMPATIBLE.RDBMS attribute, ensure that the values for the COMPATIBLE initialization parameter for all of the databases that access the disk group are set to at least the value of the new setting for COMPATIBLE.RDBMS.
Oracle. Automatic Storage Management Administrator's Guide 11g Release 2 (11.2)
Q68. Which two statements are true regarding the Automatic Workload Repository (AWR) In a RAC environment?
A. The AWR includes time model statistics based on time usage for activities displayed In the VSSYS_TIME_MODEL and VSSESS_TIHE_HODEL views.
B. The AWR is controlled by the statistics_level initialization parameter and it must be set to TYPICAL or BASIC
C. The Manageability Monitor Processes (MMON) process gathers statistics every hour from every instance and creates an AWR snapshot and stores it In the SGA.
D. The MMON process gathers statistics from its' own instance and kicks off statistics collection form other instances every hour from other instances and creates an AWR snapshot which is written to the sysaux tablespace.
Answer: A,D
Explanation: The Automatic Workload Repository (AWR) collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. This data is both in memory and stored in the database. The gathered data can be displayed in both reports and views. The statistics collected and processed by AWR include:
. Object statistics that determine both access and usage statistics of database segments . Time model statistics based on time usage for activities, displayed in the V$SYS_TIME_MODEL and V$SESS_TIME_MODEL views . Some of the system and session statistics collected in the V$SYSSTAT and V$SESSTAT views . SQL statements that are producing the highest load on the system, based on criteria such as elapsed time and CPU time
. Active Session History (ASH) statistics, representing the history of recent sessions Activity MMON (Memory Monitor) is a background process that gathers memory statistics (snapshots) stores this information in the AWR (automatic workload repository). MMON is also responsible for issuing alerts for metrics that exceed their thresholds.
Oracle Database Performance Tuning Guide
Q69. Which three statements are true about the logging or tracing of Java-based Oracle tools?
A. By default, Oracle logs actions for DBCA and DBUA.
B. For tools such as SRVCTL and CLUVFY, tracing can be enabled by setting srvm trace = true your shell environment before executing the commands.
C. The srvm_trace environment variable can be set only in the user's shell environment file.
D. To disable tracing for Java-based tools, unset the srvm_trace variable: export srvm_trace=
Answer: A,B,D
Explanation: Enabling Tracing for Java-Based Tools and Utilities in Oracle RAC
All Java-based tools and utilities that are available in Oracle RAC are called by executing scripts of the same name as the tool or utility. This includes the Cluster Verification Utility (CVU), Database Configuration Assistant (DBCA), the Net Configuration Assistant (NETCA), Server Control Utility (SRVCTL), and the Global Services Daemon (GSD). For example to run DBCA, enter the command dbca. By default, Oracle Database enables traces for DBCA and the Database Upgrade Assistant (DBUA). For the CVU, GSDCTL, and SRVCTL, you can set the SRVM_TRACE environment variable to TRUE to make Oracle Database generate traces. Oracle Database writes traces to log files. For example, Oracle Database writes traces to log files in Oracle home/cfgtoollogs/dbca and Oracle home/cfgtoollogs/dbua for DBCA and DBUA, respectively.
Oracle. Real Application Clusters Administration and Deployment Guide
Q70. Your cluster Is subject to a service-level agreement that allows for little scheduled down time You want to use patching and maintenance methods that permit the Oracle Grid Infrastructure and Oracle RAT Databases to be available as much as possible.
Which two techniques will work some or all of the time to provide you with minimum down time?
A. rolling upgradeable and in place patch sets
B. idling upgradeable and out of place patch bundles
C. rolling upgradeable and out of place patch sets
D. rolling upgradeable and in place patch bundles
E. rolling upgradeable and out of place one-off patches
Answer: C,D
Explanation:
. A rolling upgrade process allows one or more nodes in the cluster to have a different software version than the other nodes in the cluster for a short period of time. During the time period where cluster nodes have different software versions, the cluster is fully functional, but some administrative functions are disabled until the upgrade has completed, for example, adding new cluster resources.
. An out-of-place patch set installation with cloning has the following advantages: Applications remain available while software is upgraded in the new ORACLE_HOME. The configuration inside the ORACLE_HOME is retained because the cloning procedure involves physically copying the software
. In-place upgrade – You install the patch set into an existing Oracle home location. Oracle recommends that you select this option only if you do not have sufficient free disk space to perform an out-of-place upgrade, as the upgrade removes the existing Oracle installation. This patch option requires less disk space, but requires more time, and is riskier, because if you encounter an installation failure, then you must recover the entire existing Oracle home from a backup