Your worries about Oracle 1Z0-048 exam complexity no more exist because Flydumps is here to serves as a guide to help you to pass the exam. All the exam questions and answers is the latest and covering each and every aspect of Oracle https://www.pass4itsure.com/1z0-048.html exam.It 100% ensure you pass the Oracle 1Z0-048 exam without any doubt.
QUESTION 21
Which four statements contain accurate information regarding RAC VIPs and application VIPs? (Choose four.)
A. A RAC VIP fails over if the listener fails.
B. A failed over RAC VIP does accept new connections.
C. A failed over application VIP does accept new connections.
D. An application VIP fails over if the associated application fails over.
E. It is recommended to share application VIPs among multiple applications.
F. It is recommended to share a RAC VIP among several database instances.
G. It is not recommended to share an application VIP among several applications.
H. It is not recommended to share a RAC VIP among several database instances.
Correct Answer: CDFG
QUESTION 22
You are creating a database in your RAC implementation. You are using the DBCA to create the database, and you selected the Raw Devices Mapping file on one of the screens of the DBCA. What is the reason for selecting this file?
A. You want the DBCA to bind the partitions to raw devices.
B. You want to set the appropriate raw partition for each database file.
C. You want to configure an ASM diskgroup containing raw devices.
D. You want to provide the DBCA with a list of all the storage devices that are currently bound to a raw interface.
Correct Answer: B
QUESTION 23
When do you get the first notification after you execute the following command on instance RDBA1?
exec DBMS_SERVER_ALERT.SET_THRESHOLD(-METRICS_ID => dbms_server_alert.elapsed_time_per_call, WARNING_OPERATOR =>
dbms_server_alert.operator_ge,
WARNING_VALUE => ‘500000’,
CRITICAL_OPERATOR => dbms_server_alert.operator_ge,
CRITICAL_VALUE => ‘750000’,
OBSERVATION_PERIOD => 15,
CONSECUTIVE_OCCURRENCES => 3,
INSTANCE_NAME => ‘RDBA1’,
OBJECT_TYPE => dbms_server_alert.object_type_service,
OBJECT_NAME => ‘ERP’);
A. when the average elapsed time per call for the ERP service over a 45-minute period exceeds 0.5 seconds
B. when the average elapsed time per call for the ERP service over a 45-minute period exceeds 0.75 seconds
C. when the average elapsed time per call for the ERP service over a 15-minute period exceeds 0.5 seconds three consecutive times
D. when the average elapsed time per call for the ERP service over a 15-minute period exceeds 0.75 seconds three consecutive times
Correct Answer: C
QUESTION 24
You are asked to investigate a problem regarding client connectivity between the HR service and a database, which is on a four-node RAC cluster. The HR service has four preferred instances on the RAC cluster. This cluster also supports five other services. Occasionally, a client-connect request for the HR service takes several minutes to connect, whereas the other five services connect within a second or two. Client-side and server-side connection load balancing are used for all the services. Which combination of network settings would explain these symptoms? (Choose two.)
A. The listener on one or more nodes is listening only on the Virtual IP address and the HR TNSNAMES entry uses the Hostnames for the Virtual IP addresses.
B. The TNSNAMES.ORA file has an entry for all six services that uses the host name for the Public IP address and not the Virtual IP address.
C. The listener on one or more nodes is listening on both the Public IP address and the Virtual IP address, and the HR TNSNAMES entry uses the Virtual IP address.
D. The TNSNAMES.ORA file has an entry for the five other services that use the hostnames for the Virtual IP addresses and all the listeners listen on both the Public and Virtual IP addresses.
E. The TNSNAMES.ORA file has an entry for the HR service that uses only the host name for the public IP address, and all the listeners listen on both the Public and Virtual IP addresses.
Correct Answer: DE
QUESTION 25
You are considering issues involving backup and recovery of the voting disk. Select four correct statements. (Choose four.)
A. Backup can be performed online.
B. Use symbolic links to simplify recovery of the voting disk.
C. To back up the voting disk, use the command ocrconfig -export.
D. If you lose your voting disk and do not have a backup, you must reinstall Oracle Clusterware.
E. You can determine the voting disks currently used by CSS with the command crsctl query css votedisk.
Correct Answer: ABDE
QUESTION 26
View the Exhibit and examine an installation step of Oracle Enterprise Manager Grid Control 10gR2 to manage your RAC installation. You entered the host name but you are not sure about the port number. The following is the list of port numbers from the host ed-otraclin17b.us.oracle.com:
1) 5561: iSQL*Plus HTTP port number 2) 1158: Enterprise Manager Console HTTP Port number 3) 3938: Enterprise Manager Agent Port number 4) 1521: Listener port number 5) 4889: The default port number that you plan to use for the new Management Service
Which port number should be provided here for successful installation?
A. 5561
B. 1521
C. 3938
D. 1158
E. 4889
Correct Answer: B
QUESTION 27
Which three statements about Snapshot Control File Management in a RAC environment are true? (Choose three.)
A. You can use a cluster file system or a raw device to store snapshot control files.
B. By default, the snapshot control file is created on the node that is making the backup.
C. RMAN parameters controlling snapshot control files can be configured from the Enterprise Manager Cluster Database home page.
D. You need to configure a default path and file name for these snapshot control files that is valid on every node from which you might initiate an RMAN backup.
Correct Answer: ABD
QUESTION 28
Which statement regarding Clusterware is false? (Choose the false statement.)
A. Oracle Clusterware is installed using the Oracle Universal Installer (OUI).
B. The ORA_CRS_HOME directory must not be the same as the ORACLE_HOME directory.
C. The Oracle Database 10g Clusterware stack is compatible with Oracle 9i Group Services (GSD) processes.
D. The installation of Oracle Clusterware is mandatory even if you have installed vendor-specific clusterware.
Correct Answer: C QUESTION 29
Which three tools can you use to patch your RAC database? (Choose three.)
A. dbca
B. emctl
C. emca
D. opatch
E. EM Database Control
F. Oracle Universal Installer
Correct Answer: DEF QUESTION 30
Your company asked you to implement RAC to enhance the scalability and availability of the database that you manage. Your coworker suggested that you use ASM as the only storage option. However, you implemented RAC with Automatic Storage Management (ASM) as well as OCFS as storage options. What are the reasons for implementing both OCFS and ASM as storage options? (Choose all that apply.)
A. You want to avoid keeping Oracle binaries on local storage.
B. You do not want to use raw devices to store voting and OCR files.
C. You do not want to store any file other than voting and OCR files in ASM.
D. You want to use the Oracle Managed Files (OMF) feature but that is not supported by ASM.
E. You require OCFS to store archive log files because ASM does not support these files.
Correct Answer: AB QUESTION 31
You execute the following command from the first node of your cluster:
crsctl add css votedisk /dev/raw/raw9
However, you get an error message indicating that Oracle Clusterware stack is not started.
Which command would you execute?
A. crsctl add css votedisk /dev/raw/raw9 -force
B. crsctl start crscrsctl add css votedisk /dev/raw/raw9
C. crsctl start crscrsctl add css votedisk /dev/raw/raw9 -force
D. crsctl enable crscrsctl add css votedisk /dev/raw/raw9
E. crsctl enable crscrsctl add css votedisk /dev/raw/raw9 -force
Correct Answer: A QUESTION 32
After applying a patch to the network device drivers in your operating system, you verify using CRS_STAT -T that everything runs normally. View Exhibit1 for the CRS_STAT -T output.
After your coffee break, customers begin complaining about the performance of your Oracle Real Application Clusters database. Suddenly, the response time has increased and establishing new connections is slower than it used to be. You run CRS_STAT -T again to check if there is a problem.
Based on Exhibit2, what is your conclusion, and what would you do to correct this?
A. There is no problem, so nothing needs to be corrected.
B. You cannot tell what the problem is based on Exhibit2, so you cannot fix this.
C. Somebody relocated the VIP from the second node to the first node for an unknown reason. You just have to relocate it back.
D. The second node in your cluster is down and, therefore, CRS has relocated the VIP from the second node to the first node. After you fix the second node, CRS would relocate the relocated VIP back to its original node.
E. The second node in your cluster is down and, therefore, CRS has relocated the VIP from the second node to the first node. After you fix the problem on the second node, you have to relocate the relocated VIP back to its original node using the SRVCTL command.
Correct Answer: D
QUESTION 33
Which optional parameter of the DESCRIPTION clause of a TNS entry can you use to make sure that another protocol address is tried if the first one fails?
A. FAILOVER
B. LOAD_BALANCE
C. SOURCE_ROUTE
D. TYPE_OF_SERVICE
Correct Answer: A
QUESTION 34
You are asked to design a Maximum Availability Solution for a RAC configuration that provides for continuous availability for the Oracle database and which can survive instance failures, node failures, data failures, and site failures. The RAC configuration has a four-node cluster with five different services configured. Performance must be maintained for any failure situation for all the services, and all data must be preserved. All the servers in the configuration will have the same hardware. Which configuration would you recommend?
A. Asymmetric RAC and Dataguard configuration with a mixture of RAC and single instances using ASM at all sites with the same service preferences
B. Asymmetric RAC and a Physical Standby Database in a Dataguard configuration with RAC and ASM at all sites with the same number of instances but different service preferences
C. Asymmetric RAC and a Logical Standby Database in a Dataguard configuration with RAC and ASM at all sites with the same number of instances but different service preferences
D. Symmetric RAC and a Physical Standby Database in a Dataguard configuration with RAC and ASM at all sites with the same number of instances and the same service preferences
Correct Answer: D
QUESTION 35
View the Exhibit.
You are required to support your Oracle RAC configuration using ASM and RAID technology. You plan to discuss the storage configuration with the storage technology team. They have proposed a configuration as shown in the exhibit with a separate set of LUNs for the data disk group and the flash recovery area disk group and a 500 KB stripe size in line with other non-Oracle LUNs. The Data disk group has four 250G LUNs and the FRA disk group has four 500G LUNS, both of which are mirrored.
What are three disadvantages of this configuration? (Choose three.)
A. Index Range Scans would cause I/O to many different physical disks.
B. The LUNs are not aligned with ASM Allocation Units, which may lead to I/O bottlenecks.
C. Retention policies that require backups to be kept for long time periods may cause wasted space due to large allocation units.
D. I/O to the flash recovery area disk group for backups may cause performance issues when full table scans are occurring during batch workloads.
Correct Answer: BCD
QUESTION 36
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 what debugging options are available on the CRS daemon
B. to enable extra debugging on the currently running CRS daemon
C. to list which debugging options are enabled 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 and CRS daemons as well as those that will run in the future
Correct Answer: E
QUESTION 37
After a disk failure caused by a power outage, your CRS is unable to start up completely because all your
OCR files are lost. Which commands would you use and in which order to redress this situation?
1 OCRCONFIG -REPAIR (on the local cluster node only)
2 OCRCONFIG -REPAIR (on all cluster nodes)
3 OCRCONFIG -RESTORE <path name>
4 OCRCONFIG -IMPORT <path name>
5 CRSCTL STOP CRS (on the local cluster node only)
6 CRSCTL STOP CRS (on all cluster nodes)
7 OCRCONFIG -SHOWBACKUP
8 CRSCTL START CRS (on the local cluster node only)
9 CRSCTL START CRS (on all cluster nodes)
A. 5, 3, 8.
B. 6, 4, 9.
C. 5, 4, 8.
D. 6, 3, 9.
E. 7, 6, 3, 9.
F. 7, 6, 4, 9.
G. 7, 6, 3, 2, 9.
Correct Answer: E
QUESTION 38
The following query shows four MEMBER disks and three CANDIDATE disks.
SQL> select name, header_status, path from v$asm_disk;
NAME HEADER_STATUS PATH ———— ————————– ————————- CANDIDATE /dev/rdsk/diska5 CANDIDATE /dev/rdsk/diska6 CANDIDATE /dev/rdsk/diska7 DISK01 MEMBER /dev/rdsk/diska1 DISK02 MEMBER /dev/rdsk/diska2 DISK03 MEMBER /dev/rdsk/diska3 DISK04 MEMBER /dev/rdsk/diska4 7 rows selected.
Using SQLPlus you want to add /dev/rdsk/diska5 and /dev/rdsk/diska6 to diskgroup DGROUP1. DGROUP1 is currently mounted.
Pick the statement that would fail to add diska5 and diska6.
A. ALTER DISKGROUP dgroup1 ADD DISK’/dev/rdsk/disk*5′,’/dev/rdsk/disk*6′;
B. ALTER DISKGROUP dgroup1 ADD DISK’/dev/rdsk/diska5′,’/dev/rdsk/diska6′;
C. ALTER DISKGROUP dgroup1 ADD DISK’/dev/rdsk/diska5′ name disk05,’/dev/rdsk/diska6′ name disk06;
D. ALTER DISKGROUP dgroup1 ADD DISK ‘/dev/rdsk/diska*’;
E. ALTER DISKGROUP dgroup1 ADD DISK ‘/dev/rdsk/diska[56]’;
Correct Answer: D
QUESTION 39
You want check whether the group services node application is running on all the nodes in your cluster before you create a cluster database. Which utility can you use to make sure the node application is running on all nodes in the cluster?
A. onsctl
B. crsctl
C. lsnrctl
D. crs_stat
E. addnode.sh
Correct Answer: D
QUESTION 40
You defined the HR service using the following command:
srvctl add service -d RACDB -s HR -r RAC02,RAC03 -a RAC01
After a while, you realize that there is a workload peak on the HR service, and you decide to temporarily start HR on the RAC04 instance.
Which command or series of commands would you use to start HR on RAC04?
A. srvctl start service -d RACDB -s HR -i RAC04
B. srvctl remove service -d RACDB -s HRsrvctl add service -d RACDB -s Hr -r RAC02,RAC03,RAC04 -a RAC01
C. srvctl remove service -d RACDB -s HRsrvctl add service -d RACDB -s Hr -r RAC02,RAC03,RAC04 -a
With the complete collection of Oracle 1Z0-048 Questions and Answers, Flydumps has assembled to take you through Questions and Answers to your Oracle https://www.pass4itsure.com/1z0-048.html Exam preparation. In the Oracle 1Z0-048 exam resources, you will cover every field of Oracle 1Z0-048 exam helping to ready you for your successful Adobe Certification.
