Online Access Free 1Z0-048 Practice Test

James works as a senior DBA for a finance company. He plans to implement a test RAC
environment. As per his plan, a three-node RAC would be implemented on a Windows platform,
with the following points related to the storage of files:
1) A single Oracle home would be shared by all the nodes.
2) The data files will extend automatically because the autoextend feature will be enabled.
3) The Oracle binaries and all the database files would be stored in a single file system.
4) The hardware RAID is used to support high availability.
These are the some of the storage options available for RAC implementation:
Option 1:Use OCFS with ASM Option 2:Use ASM and not OCFS Option 3:Use OCFS and not ASM Option 4:Use neither OCFS, nor ASM
Which storage option would you suggest for this plan?

• A.Option 4
• B.either Option 1 or Option 2
• C.Option 3
• D.Option 1
• E.either Option 2 or Option 4
• F.Option 2

What does server-side Connect-Time Load Balancing do to complement the client-side Connect-Time Load Balancing function of balancing the connection requests to all the listeners in the address list on the client side?

• A.it balances the load for each service across all instances for that service, according to the service-specific load-balancing requirements,
• B.it balances the load for each service across all preferred instances for that service, according to the global load-balancing requirements.
• C.it balances the load for each service across all preferred instances for that service, according to the service-specific load-balancing requirements,
• D.it balances the load for each service across all preferred instances for all services, according to the service-specific load-balancing requirements,
• E.it balances the load for each service across all available instances for that service, according to service-specific load-balancing requirements,

After adding two new high-performance nodes to your existing eight-node Oracle Database cluster, you decide to remove the two oldest nodes from your cluster. You start by removing the instances from the nodes you are about to remove by using the Database Configuration Assistant (DBCA). During the execution, a problem arises and the DBCA terminates with a fatal exception. Before you contact Oracle Support, you want to create a Java-based tool trace file so that Oracle Support can assist you in resolving this issue as quickly as possible. How would you create this trace file?

• A.Request extra information by adding the -v (verbose) command-line flag at the DBCA command line.
• B.Set the SRVM_DEBUG environment variable to TRUE before you execute the DBCA command.
• C.Set the SRVM_TRACE environment variable to TRUE before you execute the DBCA command.
• D.Request extra information by adding the -d (debug) command line flag at the DBCA command line.
• E.There is no need to do anything special because Java-based tool tracing is enabling by default for DBCA.
• F.Set the DEBUG environment variable to TRUE before you execute the DBCA command.

Which three statements are correct regarding ASM instances in a RAC environment? (Choose three.)

• A.ASM instances must all have the same value for ASM_DISKSTRING.
• B.ASM instances recognize their disks by looking at their headers.
• C.ASM instances must all have the same value for ASM DISKGROUPS.
• D.ASM instances can mount different sets of disk groups.
• E.ASM instances can use different values for ASM_POWER_LIMIT.

You and your colleague are working with Oracle Support on a database instance stability issue. The Oracle Support engineer wants you to issue a crsctl debug log crs ?crsctl debug log crs command to assist you in your troubleshooting assignment. Why does the Oracle Support engineer want you to do this?

• A.to list which debugging options are enabled on the CRS daemon
• B.to enable extra debugging on the currently running and CRS daemons as well as those that will run in the future
• C.to list what debugging options are available on the CRS daemon
• D.to enable extra debugging on the CRS daemon the next time the CRS daemon is started
• E.to enable extra debugging on the currently running CRS daemon