It is more faster and easier to pass the Oracle 1Z0-058 exam by using 100% Correct Oracle Oracle Real Application Clusters 11g Release 2 and Grid Infrastructure questuins and answers. Immediate access to the Refresh 1Z0-058 Exam and find the same core area 1Z0-058 questions with professionally verified answers, then PASS your exam with a high score now.
♥♥ 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
Q11. Which two statements are true regarding the Active Session History (ASH) reports for RAC?
A. They provide details about Oracle databases for all current sessions, and history of past session all RAC nodes.
B. They provide statistics about Oracle databases for the active sessions on all the RAC nodes.
C. They report on data captured for active sessions. The volume of data is directly related to the work being performed by sessions.
D. They report on data captured for active sessions. The volume of data is directly related to the number of sessions on the system.
Answer: A,C
Explanation: ASH report statistics provide details about Oracle Database session activity. Oracle Database records information about active sessions for all active Oracle RAC instances and stores this data in the System Global Area (SGA). Any session that is connected to the database and using CPU is considered an active session. The exception to this is sessions that are waiting for an event that belongs to the idle wait class. ASH reports present a manageable set of data by capturing only information about active sessions. The amount of the data is directly related to the work being performed, rather than the number of sessions allowed on the system.
Oracle Real Application Clusters Administration and Deployment Guide
Q12. Which three predefined database-type templates already include the data files when creating an Oracle Cluster database?
A. General Purpose
B. Transaction Processing
C. Custom Database
D. Data Warehouse
E. OLAP Database
Answer: A,B,D
Explanation:
Creating an Oracle RAC Database with DBCA Oracle ships templates for the following two workload types: General purpose or transaction processing Data warehouse For more complex environments, you can select the Custom Database option. This option does not use templates and results in a more extensive interview, which means that it takes longer to create your database.
Oracle. Real Application Clusters Installation Guide 11g Release 2 (11.2) for Linux and UNIX
Q13. In an ASM instance, there are several parameters that have meanings specific to the ASM. Which parameter is mandatory?
A. ASM_DISKGROUP
B. ASM_DISKSTRING
C. INSTANCE_TYPE
D. CLUSTER_DATABASE
E. MEMORY_TARGET
F. ASM_POWER_LIMIT
Answer: C
Explanation: Oracle ASM Parameter Setting Recommendations
This section contains information about the following parameters for Oracle ASM: ASM_DISKGROUPS ASM_DISKSTRING ASM_POWER_LIMIT ASM_PREFERRED_READ_FAILURE_GROUPS DB_CACHE_SIZE DIAGNOSTIC_DEST INSTANCE_TYPE uk.co.certification.simulator.questionpool.PList@9387e00 LARGE_POOL_SIZE PROCESSES REMOTE_LOGIN_PASSWORDFILE SHARED_POOL_SIZE
Oracle. Automatic Storage Management Administrator's Guide
Q14. From a command line, you can create an ASM volume with the same properties by using either SQL or ASMCMD. Which two commands will create a 500 MB volume called TESTVOL in the ACFSDG ACFS diskgroup by storing only one copy of the volume file extents in the diskgroup
A. SQL> alter diskgroup ACFSDG add volume TESTVOL size 500M unprotected;
B. ASMCMD> volcreate -G ASMFS -s 500M
C. SQL> alter diskgroup ACFS add volume TESTVOL size 500M;
D. ASMCMD> volcreate -G ACFSDG -s 500M --redundancy unprotected TESTVOL
E. SQL> create volume TESTVOL diskgroup ACFSDG size 500M unprotected;
Answer: A,D
Explanation: The ALTER DISKGROUP VOLUME SQL statements enable you to manage
Oracle ADVM volumes, including the functionality to add, modify, resize, disable, enable, and drop volumes.
You can create an Oracle ASM Dynamic Volume Manager (Oracle ADVM) volume in a disk group. The volume device associated with the dynamic volume can then be used to host an
Oracle ACFS file system.
If the volume is hosting an Oracle ACFS file system, then you cannot resize that volume with the SQL ALTER DISKGROUP statement. Instead you must use the acfsutil size command.
volcreate
Creates an Oracle ADVM volume in the specified disk group.
Syntax and Description
volcreate -G diskgroup -s size [ --column number ] [ --width stripe_width ]
[--redundancy {high|mirror|unprotected} ]
Redundancy of the Oracle ADVM volume which can be specified for normal redundancy disk groups. The range of values is as follows: unprotected for non-mirrored redundancy, mirror for double-mirrored redundancy, or high for triple-mirrored redundancy. If redundancy is not specified, the setting defaults to the redundancy level of the disk group.
Q15. Which three describe how often OCR backups are taken and how many are retained, according to the default backup schedule?
A. every 12 hours and the Clusterware keeps the last four copies
B. every 4 hours and the Clusterware keeps the last three copies
C. every day and the Clusterware keeps the last two copies
D. every day and the Clusterware keeps the last three copies
E. every week and the Clusterware keeps the last two copies
Answer: B,C,E
Explanation:
Locating the OCR Automatic Backups
The OCR is backed up automatically.
Only one node performs the backup.
To determine the node and location of the backup:
$ ocrconfig -showbackup auto
host02 2009/07/28 12:20:42 /u01/app/.../cdata/cluster01/backup00.ocr
host02 2009/07/28 08:20:41 /u01/app/.../cdata/cluster01/backup01.ocr
host02 2009/07/28 04:20:40 /u01/app/.../cdata/cluster01/backup02.ocr
host02 2009/07/27 16:20:37 /u01/app/.../cdata/cluster01/day.ocr
host02 2009/07/28 00:20:39 /u01/app/.../cdata/cluster01/week.ocr
Files could be spread across nodes due to outages.
The backup frequency and retention policies are:
– Every four hours: CRS keeps the last three copies.
– At the end of every day: CRS keeps the last two copies.
– At the end of every week: CRS keeps the last two copies.
D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 3 - 11
Q16. Your cluster was originally created with nodes RACNODE1 and RACNODE2 three years ago. Last year, nodes RACNODE3 and RACNODE4 were added.
These nodes have faster processors and more local storage than the original nodes making performance management and tuning more difficult.
Two more nodes with the same processor speed have been added to the cluster last week as RACNODE5 and RACNODE6 and you must remove RACNODE1 and RACNODE2 for redeployment.
The Oracle Grid Infrastructure is using GNS and the databases are all 11g Release 2, all running from the same home. The Grid home is /fs01/home/grid.
Which three steps must be performed to remove the nodes from the cluster?
A. Run /fs01/home/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/fs01/home/grid "CLUSTER_NODES= {RACNODE3 , RACNODE4 ,
RACNODE5 ,
RACNODE6}
as the grid software owner on any remaining node.
B. Run /fs01/home/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/fs01/home/grid " CLUSTER_NODES={RACNODE1} as the grid software owner on RACNODE1 and run /fs01/home/grid/oui/bin/runInstaller -updateNodeList ORACLE_HOME=/ fs01/home/grid " CLUSTER_NODES={RACNODE 2} as the grid software owner on RACNODE2.
C. Run /fs01/home/grid/oui/bin/runInstaller -detachHome ORACLE_HOME=/fs01/home/grid as the grid software owner on RACNODE1 and RACNODE2.
D. Run the /fs01/home/grid/crs/install/rootcrs.pl script as root on each node to be deleted.
E. Run crsctl delete node -n RACNODE1 and crsctl delete node -n RACNODE2 as root from any node remaining in the cluster.
Answer: A,D,E
Explanation:
Deleting a Cluster Node on Linux and UNIX Systems
1. Ensure that Grid_home correctly specifies the full directory path for the Oracle Clusterware home on each node, where Grid_home is the location of the installed Oracle Clusterware software.
2. Run the following command as either root or the user that installed Oracle Clusterware to determine whether the node you want to delete is active and whether it is pinned: $ olsnodes -s -t If the node is pinned, then run the crsctl unpin css command. Otherwise, proceed to the next step.
3. Disable the Oracle Clusterware applications and daemons running on the node. Run the rootcrs.pl script as root from the Grid_home/crs/install directory on the node to be deleted, as follows: # ./rootcrs.pl -deconfig -deinstall -force If you are deleting multiple nodes, then run the rootcrs.pl script on each node that you are deleting. If you are deleting all nodes from a cluster, then append the -lastnode option to the preceding command to clear OCR and the voting disks, as follows: # ./rootcrs.pl -deconfig -deinstall -force -lastnode
4. From any node that you are not deleting, run the following command from the
Grid_home/bin directory as root to delete the node from the cluster:
# crsctl delete node -n node_to_be_deleted
Then if you run a dynamic Grid Plug and Play cluster using DHCP and GNS, skip to step 7.
5. On the node you want to delete, run the following command as the user that installed
Oracle Clusterware from the Grid_home/oui/bin directory where node_to_be_deleted is the
name of the node that you are deleting:
$ ./runInstaller -updateNodeList ORACLE_HOME=Grid_home "CLUSTER_NODES=
{node_to_be_deleted}" CRS=TRUE -silent -local
6. On the node that you are deleting, depending on whether you have a shared or local
Oracle home, complete one of the following procedures as the user that installed Oracle
Clusterware:
If you have a shared home, then run the following command from the Grid_home/oui/bin directory on the node you want to delete:
$ ./runInstaller -detachHome ORACLE_HOME=Grid_home -silent -local
For a local home, deinstall the Oracle Clusterware home from the node that you want to delete, as follows, by running the following command, where Grid_home is the path defined for the Oracle Clusterware home:
$ Grid_home/deinstall/deinstall –local
7. On any node other than the node you are deleting, run the following command from the
Grid_home/oui/bin directory where remaining_nodes_list is a comma-delimited list of the
nodes that are going to remain part of your cluster:
$ ./runInstaller -updateNodeList ORACLE_HOME=Grid_home "CLUSTER_NODES=
{remaining_nodes_list}" CRS=TRUE -silent
8. Run the following CVU command to verify that the specified nodes have been
successfully deleted from the cluster:
$ cluvfy stage -post nodedel -n node_list [-verbose]
Oracle. Clusterware Administration and Deployment Guide 11g Release 2 (11.2)
Q17. 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
Q18. You notice that there is a very high percentage of wait time for the gc current split event in your RAC database that has frequent insert operations.
Which two recommendation would you make to reduce this problem?
A. shorter transactions
B. using hash partitioned global indexes
C. uniform and large extent sizes
D. automatic segment space management
E. smaller extent sizes
F. increasing sequence cache sizes
Answer: D,F
Q19. A Grid Plug and Play (GPnP) software image must contain at least three items. Which three items are required?
A. operating system software
B. Oracle Database software
C. GPnP software
D. security certificate of the provisioning authority
E. application software
Answer: A,C,D
Explanation:
GPnP Components
Software image
A software image is a read-only collection of software to berun on nodes of the same type.
At a minimum, the image must contain:
-An operating system
-The GPnP software
-A security certificate from the provisioning authority
-Other software required to configure the node when it starts up
D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration
Q20. 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