1Z0-058 | All About Exact 1Z0-058 practice test
Q31. In the high availability services' provided by Oracle Clusterware are used to protect Oracle resource such as RAC database instances, RAC database services, and other components of the Oracle Infrastructure, and non-Oracle resources as well.
Which two statements are true about the high availability capabilities of Oracle HA services?
A. RAC databases may have their instances failed over in some cases.
B. ASM instances may be failed over if fewer than three nodes remain In the cluster, so that there are always at least three ASM instances available.
C. If a node fails, then all resources that were active on that node will be failed over to a surviving node if any exists.
D. If a node fails, then cluster resources that were active on that node may be failed over to a surviving node if any exists, but local resources are not failed over.
E. HA services will only fail over a resource upon failure of the node where the resource was active.
Answer: D,E
Q32. You want to install a database patch on your eight-node cluster by using Opatch with, the minimum amount of down time to your cluster nodes.
You have already been prompted for the first set of nodes and you replied with node names RACNODE1 RACNODE2, and RACNODE3.
Which two statements are true about the procedure for minimizing down time?
A. The patch must be propagated to, applied, and the inventory updated on all the remaining nodes before restarting the instances on the first set of nodes.
B. When the first set of nodes has been patched, the instances on the remaining nodes are shut down automatically by opatch.
C. The instances must be started on the first set of nodes and then stopped on the remaining set to make certain that some nodes are always available.
D. When the first set of nodes has been patched, the administrator is prompted to shut down the instances on the remaining nodes.
E. The patch must be propagated to and the inventory updated on all the remaining nodes before restarting the instances on the first set of nodes.
Answer: D,E
Explanation:
Installing a Patch with Minimum Down Time with OPatch In minimum down-time patching, the nodes are divided into two sets. One set of nodes is shut down and the patch is applied to those nodes. After the first set of nodes has been patched, the second set of nodes is shut down. The first set of nodes is then restarted and the patch is applied to the second set of nodes. After the patch has been applied to the second set of nodes, those nodes are restarted. This method leads to less down time for Oracle RAC, compared to having all the nodes shut down at the same time. When you use the minimum down-time patching method, the following actions occur: The local node is always patched first. The local node is used as a base to patch the other nodes. The user is prompted for the first set of nodes to patch. For each node in this first set, the user is asked to stop the instance and then the patch is propagated and applied to that node before continuing to the next node. When the first set of nodes has been patched, the user is asked to shut down Clusterware on the remaining nodes. The instances are stopped on the last set of remote nodes. The patch is propagated to the last set of nodes and the inventory is updated. You can then start up the patched nodes (the first set of nodes) before patching the remaining nodes.
D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 4 – 44
Q33. You are managing a policy-managed Real Application Cluster (RAC) database, RACDB with Oracle Managed Files (OMF) enabled. Examine the following outputs:
You added a new server to the server pool using the following command: [oracle@gr5153 ~]$ srvctl modify srvpool -g POOL1 -i 0 -l 2 -u 4 -n gr5119
The instance on the newly added node is started by the Oracle Clusterware. Automatic Storage Management (ASM) is used as the storage option.
Which statement is true regarding the redo log files for the instance?
A. Oracle Clusterware automatically creates and enables a new thread of red
B. You must create redo log groups for the newly added service.
C. Redo log members will not be created automatically because storage option used is ASM.
D. The newly added instance must save full online log groups tracked in the control file.
Answer: A
Explanation: For a policy-managed database, when you add a new node to the cluster, it is placed in the Free pool by default. If you increase the cardinality of the database server pool, then an Oracle RAC instance is added to the new node, racnode3, and it is moved to the database server pool. No further action is necessary. Add shared storage for the undo tablespace and redo log files. If OMF is not enabled for your database, then you must manually add an undo tablespace and redo logs. You should create redo log groups only if you are using administrator-managed databases. For policy-managed databases, if an instance starts due to a change in server pool cardinality, then Oracle Database automatically creates redo log files, enables a redo thread for the instance if there is not a redo thread allocated to that instance, and creates the undo tablespace if there is not an undo tablespace allocated to that instance. The database must be using Oracle Managed Files and Oracle ASM in this situation.
Oracle Database 2 Day + Real Application Clusters Guide
Q34. Which three fragments will complete this statement correctly? In a cluster environment, an ACFS volume___________.
A. Will be automatically mounted by a node on reboot by default
B. Must be manually mounted after a node reboot
C. Will be automatically mounted by a node if it is defined as cluster stack startup if it is included in the ACFS mount registry.
D. Will be automatically mounted to all node if it is defined as cluster resource when dependent cluster resources requires access
E. Will be automatically mounted to all node in the cluster when the file system is registered
F. Must be mounted before it can be registered
Answer: A,C,E
Explanation:
. The Oracle ACFS mount registry supports both Oracle Restart and Oracle Grid Infrastructure cluster configurations. File systems that are to be mounted persistently (across reboots) can be registered with the Oracle ACFS mount registry. In cluster configurations, registered Oracle ACFS file systems are automatically mounted by the mount registry, similar to a clusterwide mount table.
By default, an Oracle ACFS file system that is inserted into the cluster mount registry is automatically mounted on all cluster members, including cluster members that are added after the registry addition. The Oracle ACFS registry resource actions are designed to automatically mount a file system only one time for each Oracle Grid Infrastructure initialization to avoid potential conflicts with administrative actions to dismount a given file system.
Oracle Automatic Storage Management Administrator's Guide
Q35. The System Global Area (SGA) for the ASM instance contains distinct memory areas. Choose three areas that are contained within the ASM SGA.
A. Shared Pool
B. Buffer Cache
C. Log Buffer
D. Large Pool
E. ASM Cache
F. Streams Pool
Answer: A,D,E
Explanation: Section: (none)
The SGA in an ASM instance is different in memory allocation and usage than the SGA in a database instance. The SGA in the ASM instance is divided into four primary areas as follows: Shared Pool: Used for metadata information Large Pool: Used for parallel operations ASM Cache: Used for reading and writing blocks during rebalance operations Free Memory: Unallocated memory available D60488GC11 Oracle 11g: RAC and Grid Infrastructure Administration
Q36. Your cluster has Oracle Grid Infrastructure installed and working to support RAC databases and all the related resources.
There is also a vendor HA software on the cluster providing HA services for some non-Oracle applications. You want to remove the vendor HA software and use Oracle Grid Infrastructure to provide the HA framework for your applications.
The first application to be migrated to Oracle HA is used to display financial currency information at various fixed flat screens at a business park. This application must be owned by the Financial Application owner.
Which three components of the framework are required to support this application for HA?
A. an application VIP to support sending data to the screens
B. a resource definition defining the application and various HA attributes
C. privileges to permit the application to run as the correct user and to have the correct access rights to files
D. an action program called by the HA framework for starting, stopping, and monitoring the application
E. a resource dependency to make certain that the application VIP is started before the application is started and to start VIP automatically if it is down
Answer: B,C,D
Explanation:
Overview of Using Oracle Clusterware to Enable High Availability To manage your applications with Oracle Clusterware:
1. Create an action script or use an existing agent.
2. Register your applications as resources with Oracle Clusterware.
If a single application requires that you register multiple resources, you may be required to define relevant dependencies between the resources.
3. Assign the appropriate privileges to the resource.
4. Start or stop your resources.
Oracle. Clusterware Administration and Deployment Guide 11g Release 2 (11.2)
Q37. Various clients can access and manipulate ASM files. Which two statements are true?
A. The DBMS_FILE_TRANSFER.COPY_FILE procedure can move a database file from one ASM to another ASM, but not to an operating system file system.
B. The ASMCMD cp command can move database files from a file system to ASM, but not from ASM to ASM.
C. The SQL*Plus command ALTER DISKGROUP orcl MOVE '+DATA/orcl/example01.dbf' to '+OLDDATA/orcl/example01.dbf' can move the example01 data file to a different diskgroup.
D. The DBMS_FILE_TRANSFER.GET_FILE procedure reads an ASM file from a remote machine and makes a local copy on an ASM or a file system.
E. The ASMCMD rm command will delete ASM files and directories, but not database files on an operating system file system.
Answer: D,E
Explanation:
DBMS_FILE_TRANSFER
COPY_FILE Procedure
This procedure reads a file from a source directory and creates a copy of it in a destination directory. The source and destination directories can both be in a local file system, or both be in an Automatic Storage Management (ASM) disk group, or between local file system and ASM with copying in either direction. You can copy any type of file to and from a local file system. However, you can copy only database files (such as datafiles, tempfiles, controlfiles, and so on) to and from an ASM disk group.
GET_FILE Procedure
This procedure contacts a remote database to read a remote file and then creates a copy of the file in the local file system or ASM. The file that is copied is the source file, and the new file that results from the copy is the destination file. The destination file is not closed until the procedure completes successfully.
Examples
CREATE OR REPLACE DIRECTORY df AS '+datafile' ;
GRANT WRITE ON DIRECTORY df TO "user";
CREATE DIRECTORY DSK_FILES AS ''^t_work^''
GRANT WRITE ON DIRECTORY dsk_files TO "user";
-- asumes that dbs2 link has been created and we are connected to the instance.
-- dbs2 could be a loopback or point to another instance.
BEGIN -- asm file to an os file -- get an asm file from dbs1.asm/a1 to dbs2.^t_work^/oa5.dat DBMS_FILE_TRANSFER.GET_FILE ( 'df' , 'a1' , 'dbs1', 'dsk_files' , 'oa5.dat' ); -- os file to an os file -- get an os file from dbs1.^t_work^/a2.dat to dbs2.^t_work^/a2back.dat DBMS_FILE_TRANSFER.GET_FILE ( 'dsk_files' , 'a2.dat' , 'dbs1', 'dsk_files' , 'a2back.dat' ); END ; / Oracle. Database PL/SQL Packages and Types Reference 11g Release 2 (11.2) ASMCMD cp Purpose Enables you to copy files between Oracle ASM disk groups and between a disk group and the operating system. You can use the cp command to: Copy files from a disk group to the operating system Copy files from a disk group to a disk group Copy files from the operating system to a disk group rm Purpose Deletes the specified Oracle ASM files and directories. Oracle. Automatic Storage Management Administrator's Guide 11g Release 2 (11.2)
Q38. You are managing a policy-managed three-instance RAC database. You ran database ADDM for the database and noticed gc current block congested and gc cr block congested waits. What are two possible reasons for these wait events?
A. The wait events indicate a delay in processing has occurred in the Global Cache Services (GCS), which is usually caused by high load.
B. The wait times indicate that the blocks must wait after initiating a gc block request, for the round trip from the start of the wait until the blocks arrive.
C. The wait events indicate that there is block contention resulting in multiple requests for access to local blocks.
D. The wait events indicate that the local instance making the request for current or consistent read blocks was waiting for logical I/O from its own buffer cache at the same time.
Answer: A,B
Explanation: Load-Related Wait Events
The main wait events for load-related waits are:
. gc current block congested
. gc cr block congested The load-related wait events indicate that a delay in processing has occurred in the GCS, which is usually caused by high load, CPU saturation and would have to be solved by additional CPUs, load-balancing, off loading processing to different times or a new cluster node. For the events mentioned, the wait time encompasses the entire round trip from the time a session starts to wait after initiating a block request until the block arrives Oracle Real Application Clusters Administration and Deployment Guide
Q39. Which four statements are true about services and connection load balancing?
A. Services provide the ability to balance client connections across the instances in an Oracle RAC configuration.
B. There are two types of load balancing that you can implement; load balancing decisions can be made by the client and by the listener.
C. In a RAC database environment, you should select only one load balancing method.
D. With server-side load balancing, the listener directs a connection request to the best instance that is currently providing the service based on the load-balancing options selected by the DBA.
E. Client-side load balancing balances the connection requests across the listeners.
Answer: A,B,D,E
Explanation:
Services and Connection Load Balancing
The two load balancing methods that you can implement are:
– Client-side load balancing: Balances the connection requests across the listeners
– Server-side load balancing: The listener directs a connection request to the best instance currently providing the service by using the load balancing advisory (LBA).
FAN, Fast Connection Failover, and LBA depend on a connection load balancing configuration that includes setting the connection load balancing goal for the service.
The load balancing goal for the service can be either:
– LONG: For applications having long-lived connections. This is typical for connection pools and SQL*Forms sessions.
– SHORT: For applications that have short-lived connection
Oracle Net Services provides the ability to balance client connections across the instances in an Oracle RAC configuration. You can implement two types of load balancing: client-side and server-side.
Client-side load balancing balances the connection requests across the listeners.
With server-side load balancing, the listener directs a connection request to the best instance currently providing the service by using the load balancing advisory.
In a RAC database, client connections should use both types of connection load balancing.
D60488GC11
Oracle 11g: RAC and Grid Infrastructure Administration Accelerated 15 – 12
Q40. 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