1Z0-048 Exam Details
The Other Oracle exam is the qualifying exam available to candidates pursuing a single-exam option for the Oracle Certified Network Associate Other Oracle certification. The Other Oracle (1z0-048) exam will test materials from the new Interconnection Oracle Network Devices (ICND) course as well as the new Introduction to Oracle Networking Technologies (INTRO) course. The exam will certify that the successful candidate has important knowledge and skills necessary to select, connect, configure, and troubleshoot the various Oracle networking devices. The exam covers topics on Extending Switched Networks with VLANS, Determining IP Routes, Managing IP traffic with Access Lists, Establishing Point-to-Point connections, and Establishing Frame Relay Connections.
1z0-048 DEMO
1. A junior DBA is learning how to administer an Oracle Cluster and asks you how to diagnose voting disk online and offline problems, and where to find information on voting disk online and offline messages.
What would you advise this junior colleague?
A.There is no method to get this type of information.
B.Use evmwatch to make this kind of information visible.
C.Enable CSS debugging by using CRSCTL to make this information available.
D.Write a shell script that writes the output of crsctl query css votedisk to a file on a regular basis.
E.Look in the alert_.log file in the unified message and the tracefile directory in ORA_CRS_HOME because the Oracle Clusterware logs this kind of information by default.
Answer: E
2. The infrastructure team at your company is designing a Maximum Availability Architecture for your Oracle databases consisting of a four-node RAC cluster for the primary database with flashback database configured, and a two-node cluster for the standby database with flashback database configured. The standby database is in a separate location in another city. There are six services configured and clustered ASM is used for storage on the primary and the standby
Which two statements are true concerning this architecture? (Choose two.)
A.It protects against site failures after a switchover to the standby database.
B.It protects against instance failures after a switchover to the standby database.
C.It does not protect against node failures in case of a failover to the standby database.
D.It can help to prevent data corruptions before they happen on both the primary and the standby databases. E.It does not provide for continuous availability of services in the event of a switchover to the standby database.
Answer: AB
3. What are two ways of knowing if a patch can be applied in a rolling fashion in your RAC environment? (Choose two.)
A.Use the opatch query command.
B.Use the opatch attach command.
C.Use the opatch rollback command.
D.Use the opatch lsinventory command.
E.The patch does not modify the data dictionary.
F.Look at the patch’s inventory file and look for set to TRUE.
Answer: AF
4. Richard is a senior DBA and has prepared a plan for RAC implementation in his company. Given below are some of the tasks that he would perform as part of the plan:
1) Creating the Raw Devices Mapping file
2) Creating database services
3) Binding the partitions to raw devices
4) Creating the Voting Disk file
5) Creating an initialization parameter file
6) Creating the Oracle Cluster Registry (OCR) file
7) Creating the tnsnames.ora file
Creating the database control file
During the creation of the RAC database, Richard can use the Database Configuration Assistant (DBCA) to perform some of these steps but not all of them. Which steps should be completed before Richard starts creating the database by using DBCA?
A.2, 5, 7, 8
B.1, 3, 4, 6
C.3, 4, 6, 7, 8
D.2, 5, 6, 7, 8
E.1, 2, 4, 5, 6, 7
Answer: B
5. Using Oracle Database 10.2 Enterprise Edition, you can create and configure a new ASM instance for a new RAC cluster using which two tools? (Choose two.)
A.CRSCTL
B.ASMCMD
C.Oracle Universal Installer (OUI)
D.Enterprise Manager Grid Control
E.Database Configuration Assistant (DBCA)
F.Enterprise Manager Database Control
Answer: CE
6. Over a six-month period, you have been regularly monitoring your four-instance RAC database, which is running on the first 4 nodes of a 6-node cluster, by using ADDM and by monitoring well-known combinations of wait event and statistics in AWR reports. Two weeks ago, a newer version of your main application went live. Starting last week, you noticed a large increase in CPU time (consumed by the three application services on your RAC database) due to increased workload. The OLTP and DSS services have not had a decrease in the percentage of time spent using CPU. However, for the BATCH service the percentage of time spent using CPU has gone down and the wait-time percentage has increased. You want to recommend a tuning exercise to your team. Which two recommendations would you make first, based on the symptoms described? (Choose two.)
A.Tune SQL from the BATCH service programs because they may benefit from SQL tuning.
B.The BATCH service programs may scale well and could benefit from adding new database instances on either node 5 or 6, or on both.
C.Tune SQL for the OLTP and DSS service programs because they may benefit from SQL tuning.
D.The OLTP and DSS service programs may scale well and could benefit from adding new database instances on either node 5 or 6, or on both.
E.The OLTP and DSS service programs may scale well and could benefit from adding new database instances on one or both of nodes 5 and 6, and by adding more nodes the SQL for BATCH service programs would perform better due to more CPU power.
Answer: AD
7. 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
Answer: C
8. You have a two-node cluster (RDBD1, +ASM1 on ed-rac1and RDBD2, +ASM2 on node ed-rac2). Which two utilities would you use to check the OCR integrity? (Choose two.)
A.crsctl
B.cluvfy
C.crs_stat
D.ocrcheck
Answer: BD
9. To install Oracle Database 10g RAC on a UNIX platform, which four directories will you identify for use? (Choose four.)
A.NET_ADMIN directory
B.Oracle inventory directory
C.group services directory (GSD_HOME)
D.Oracle base directory (ORACLE_BASE)
E.CRS home directory (ORA_CRS_HOME)
F.Oracle home directory (ORACLE_HOME)
Answer: BDEF
10. Which two statements regarding Oracle Clusterware are correct? (Choose two.)
A.The Oracle Database 10g version of the srvConfig.loc file is the ocr.loc file.
B.The Oracle9i srvConfig.loc file still exists for backward compatibility in Oracle Database 10g.
C.The Oracle Database 10g CRS stack is compatible with Oracle 9i Group Services (GSD) processes.
D.The installation of Oracle Clusterware is not necessary if you have already installed vendor-specific clusterware.
Answer: AB
11. 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.
Answer: C
12. What is true about Virtual Internet Protocol Configuration Assistant (VIPCA)?
A.The VIPCA application must be run manually on all nodes in the cluster.
B.Each Virtual IP (VIP) configured requires an unused and resolvable IP address.
C.The VIP for each node should be bound to the adapter that is acting as the private interconnect.
D.The ifconfig -a command is used to back out a faulty VIPCA configuration.
Answer: B
13. Read the following statements about a file system:
1) It is compatible with Oracle 9i and Oracle 10g.
2) It is one of the solutions for managing Oracle binaries in a RAC environment.
3) It relies on storage hardware or host-based RAID functionality to support high availability.
4) It is a shared storage file system designed in such a way that you can avoid setting up of raw partitions to store certain files.
Which file system corresponds to these features?
A.ext2
B.NFS
C.ASM
D.NTFS
E.OCFS2
Answer: E
14. Read the following statements about the ASM and OCFS file systems:
1) It is compatible with Oracle 9i and Oracle 10g.
2) It is one of the solutions for managing Oracle binaries in a RAC environment.
3) It relies on storage hardware or host-based RAID functionality to support high availability.
4) It is a shared storage file system designed to eliminate the need for raw partitions to store certain files.
5) It is has integrated volume management with superior extent-based striping and mirroring.
6) It is a cluster file system with a volume manager built into the Oracle 10g kernel to manage Oracle database files. Identify the correct grouping where Group A represents true statements about ASM and Group B represents true statements about OCFS.
A.Group A: 2, 3, 4
Group B: 1, 5, 6
B.Group A: 1, 3, 4
Group B: 3, 4, 5
C.Group A: 5, 6
Group B: 1, 2, 3, 4
D.Group A: 3, 4
Group B: 1, 2, 5, 6
Answer: C
15. 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.
Answer: AB
16. 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 1
B.Option 2
C.Option 3
D.Option 4
E.either Option 2 or Option 4
F.either Option 1 or Option 2
Answer: C
17. You are working with Oracle Support to resolve an issue regarding the Oracle Clusterware software. The Oracle support engineer wants you to upload all relevant CRS log and trace files. How would you provide all the requested log and trace files? A.Upload each and every available log and trace files to Oracle Support.
B.Use Grid Control to collect and send all required log and trace files to Oracle Support.
C.Collect all required log and trace files using the diagcollection.pl command and upload them to Oracle Support.
D.Use an operating system command to create an archive with all the log and trace files stored in the
ORA_CRS_HOME/log directory and upload the files to Oracle Support.
Answer: C
18. After a power failure, you noticed that one of your cluster database instances did not start automatically, whereas all other instances came up successfully.
What would you do to determine the precise cause for the instance startup failure? (Choose three.)
A.Check the resource state by using the CRS_STAT command.
B.Check for OCR corruptions by using the OCRCHECK command.
C.Check the alert.log file that belongs to the instance that did not start.
D.Check the alert.log file that belongs to the Oracle Clusterware software.
E.Check if the Oracle Clusterware is functional by using the CRSCTL command.
F.Reboot the node where the failing instance resides to check if the problem is persistent.
G.Enable extra debugging in the Oracle Clusterware software by using the CRSCTL command.
Answer: ACD
19. Your colleague is working with Oracle Support to resolve an issue with the Oracle Clusterware software. Oracle Support advised your colleague to run the diagcollection.pl command and upload the result to Oracle Support.
What does the diagcollection.pl command do?
A.The diagcollection.pl command collects trace and log files from Oracle Clusterware only so that Oracle Support can analyze them.
B.The diagcollection.pl command collects log and trace files from the Oracle Database ORACLE_HOME so that Oracle Support can analyze them.
C.The diagcollection.pl command asks you from which part of the Oracle Clusterware installation you want to collect log and trace files for Oracle Support to analyze.
D.The diagcollection.pl command collects log and trace files from all Oracle clusters and database software installed on your cluster node so that Oracle Support can analyze them.
Answer: D
20. Your storage administrator informs you about some disk corruption issues in the disk subsystem where your Oracle Cluster Registry (OCR) is located. Your storage administrator has resolved these corruption issues by applying a patch to the storage subsystem, but to be sure that the OCR is not affected by this problem the administrator wants you to check the integrity of the OCR.
How would you do this?
A.There is no easy way to check your OCR for corruptions.
B.You can check whether the OCR is not corrupted by using the OCRCHECK command.
C.You create a logical export from the OCR by using the OCRCONFIG command and analyze the export file for errors.
D.You create a physical backup of the OCR by using the OCRCONFIG command, and if this succeeds without errors you know that the OCR is not corrupted.
E.You dump the OCR contents into a text file by using the OCRDUMP command, and if that succeeds without errors you know that your OCR is not corrupted.
Answer: B
Tags: 1z0-048
