We're so confident of our products that we provide no hassle product exchange.
Oracle 1Z0-048 Exam Overview:
| Certification Vendor: | Oracle |
| Exam Name: | Oracle Database 10g R2: Administering RAC |
| Exam Number: | 1Z0-048 |
| Exam Format: | Multiple Choice, Multiple Response |
| Exam Duration: | 120 minutes |
| Related Certifications: | Oracle Database 10g Administrator Certified Associate (OCA) Oracle Database 10g Administrator Certified Professional (OCP) |
| Available Languages: | English |
| Exam Price: | $245 USD |
| Recommended Training: | Oracle University Training |
| Exam Registration: | Oracle Certification Portal |
| Sample Questions: | Oracle 1Z0-048 Sample Questions |
| Exam Way: | Proctored exam (online or testing center depending on Oracle partner delivery at the time) |
| Pre Condition: | Recommended: Oracle Database 10g Administrator Certified Associate (OCA) or equivalent DBA experience |
| Official Syllabus URL: | https://education.oracle.com |
Oracle 1Z0-048 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Installation and Configuration | - Installing Oracle Clusterware - Preparing RAC environment - Installing RAC database software |
| High Availability Concepts | - RAC recovery scenarios - Failover mechanisms |
| Cluster and Database Administration | - Backup and recovery in RAC - Services configuration and management - Managing RAC instances |
| Performance and Tuning | - Load balancing and failover - Troubleshooting performance issues - Monitoring RAC performance |
| Oracle RAC Architecture | - Cache Fusion and interconnect communication - Cluster fundamentals and components - Shared storage concepts |
Oracle Database 10g R2: Administering RAC Sample Questions:
1. To complete a cluster database creation, the DBA must choose the cluster database storage method. Which storage choice is not correct? (Choose the incorrect one.)
A) Automatic Storage Management (ASM)
B) Standard UNIX file system
C) Cluster File System
D) Supported SAN/NAS storage
E) Raw Devices
2. Which two views can be used to identify SQL statements affected by interconnect latencies in your RAC environment? (Choose two.)
A) the VJSQL CURSOR view
B) the VJSQLAREA view
C) the VJSQL view
D) the VJSQLTEXT view
E) the V$SQL_PLAN view
3. After applying a patch to the network device drivers in your operating system, you verify using CRS_STAT-T that everything runs normally. View Exhibitl 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) 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.
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) You cannot tell what the problem is based on Exhibit2, so you cannot fix this.
4. You are migrating a single-instance Oracle database to RAC. The data files and Flash Recovery Area would be migrated to ASM using the RMAN commands BACKUP AS COPY DATABASE and BACKUP RECOVERY AREA, and stored in an ASM diskgroups called +DB_DG and +FR_DG. The DB_CREATE_FILE_DEST parameter would be set to +DB_DG and the DB_RECOVERY_FILE_DEST parameter would be set to +FR_DG.
What are the three best options for the location of your archivelogs so that they may be used properly for recovery without DBA intervention? (Choose three.)
A) ASM diskgroup +DB_DG as specified for the Database Area provided that the ASM diskgroup is mounted on all ASM instances.
B) ASM diskgroup +FR_DG as specified for the Flash Recovery Area provided that the ASM diskgroup is mounted on all ASM instances.
C) Local File System with each instance writing to a local location provided that the path names are identical on all nodes.
D) Local File System with each instance writing to a local location provided that NFS read mount points are created to all other nodes with instances of the database.
E) Cluster File System with each instance writing to a shared location.
F) Cluster File System with each instance writing to a separate location as long as they are in directories under the same mount point.
5. Oracle Cluster Registry (OCR) can be recovered on a UNIX platform using which two commands? (Choose two.)
A) ocrconfig -import /u01/logical_ocr/yesterday.ocr_exp where yesterday. ocr_exp is a logical backup created using the ocrconfig -export command
B) ocrconfig -import /u01/logical_ocr/yesterday.ocr where yesterday.ocr is an automatically generated OCR backup
C) cp /app/oracle/product/10.1.0/crs_1/cdata/dbclust01/day. ocr/ocfs/OCR/crs. dbf where /ocfs/OCR/crs. dbf is the cluster registry file
D) ocrconfig -restore /app/oracle/product/10.1.0/crs_1/cdata/dbclust01/day. ocr where day. ocr is an automatically generated OCR backup
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: B,C | Question # 3 Answer: D | Question # 4 Answer: B,D,E | Question # 5 Answer: A,D |
By Angelo
