Test4actual certification

Exam Details
The 10g DBA exam is the qualifying exam available to candidates pursuing a single-exam option for the Oracle Certified Network Associate 10g DBA certification. The 10g DBA (1z0-042) 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.

Test4actual 1z0-042 exam Features
Quality and Value for the 1z0-042 exam
Test4actual Practice Exams for Oracle 10g DBA 1z0-042 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.

100% Guarantee to Pass Your 1z0-042 exam
If you prepare for the exam using our Test4actual testing engine, we guarantee your success in the first attempt. If you do not pass the 1z0-042 exam 10g DBA Designing for Oracle Internetwork Solutions) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.

Oracle 1z0-042 Downloadable, Printable Exams (in PDF format)
Our Exam 1z0-042 Preparation Material provides you everything you will need to take your 1z0-042 exam. The 1z0-042 exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first try, but also save your valuable time.

free demo : exam.test4actual.com/1z0-042.pdf

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

the test4actual 1z1-054 is the newest exam for Oracle ! the real questions and answers !

Test4actual 1Z1-054 exam Features
Quality and Value for the 1Z1-054 exam
Test4actual Practice Exams for Oracle Oracle 11g 1Z1-054 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.

100% Guarantee to Pass Your 1Z1-054 exam
If you prepare for the exam using our Test4actual testing engine, we guarantee your success in the first attempt. If you do not pass the 1Z1-054 exam Oracle 11g Designing for Oracle Internetwork Solutions) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.

Oracle 1Z1-054 Downloadable, Printable Exams (in PDF format)
Our Exam 1Z1-054 Preparation Material provides you everything you will need to take your 1Z1-054 exam. The 1Z1-054 exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first try, but also save your valuable time.

1. After running SQL Performance Analyzer (SPA), you observe a few regressed SQL statements in the SPA output. Identify the two actions that you would suggest for these regressed SQL statements. (Choose two.)
A.Running SQL Access Advisor
B.Adding them to SQL Plan Baseline
C.Submitting them to SQL Tuning Advisor
D.Running Automatic Database Diagnostic Monitor (ADDM)

ANSWER: BC

2. View the Exhibit exhibit1 to examine the series of SQL commands and parameter settings.
View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline.
The first plan (in red) is created when OPTIMIZER_MODE is set to ALL_ROWS and the second plan (in blue) is created when OPTIMIZER_MODE is set to FIRST_ROWS.
Which SQL plan baseline would be used if the SQL query in exhibit1 is executed again when the value of OPTIMIZER_MODE is set to FIRST_ROWS?

ANSWER: B

3. You work as a DBA for a company and you have the responsibility of managing one of its online transaction processing (OLTP) systems. The database encountered performance-related problems and you generated an Automatic Workload Repository (AWR) report to investigate it further.
View the Exhibits and examine the AWR report.
What could be the problem in this database?
A.Java pool is not configured.
B.The CPU in the system is slow.
C.The shared pool size is inadequate.
D.The database buffer cache is inadequate.
E.The OPEN_CURSORS parameter is set to a small value.

ANSWER: C

4. You are working on an online transaction processing (OLTP) system. You detected free buffer waits events for your database instance running in a machine that has multiple CPUs. You increased the database buffer cache size as the first step. After a few hours of work on the database, further investigation shows that the same event is being recorded.
What would be your next step to avoid this event in future?

ANSWER: C

5. You are working on a development database that was upgraded to Oracle Database 11g from Oracle Database 9i. An ADDM finding in this database says that the shared pool is inadequately sized, as shown in the Exhibit.
You diagnosed that this is due to different kinds of workloads and this occurs only during peak hours. You tried to resize this by shrinking the database buffer cache but that caused inadequate buffer cache problems. The following are the related parameter settings:
SQL> show parameter sga
NAME TYPE VALUE
—————————— ————— —————–
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 300M
sga_target big integer 0
SQL> show parameter target
NAME TYPE VALUE
—————————— ————— —————–
…..
fast_start_mttr_target integer 0
memory_max_target big integer 0
memory_target big integer 0
pga_aggregate_target big integer 100M
sga_target big integer 0
You want to balance the memory between the System Global Area (SGA) components within SGA without affecting the size of the Program Global Area (PGA).
Which action would solve this problem?

ANSWER: A

6. You observed that some of the queries are performing poorly on the SALES_RECORDS table in your database.
On further investigation, you find that at the end of each day the contents of the SALES_RECORDS table are transferred to the SALES table and deleted from the SALES_RECORDS table. The deleted operations cause the table to be sparsely populated.
You decided to use the ALTER TABLE…SHRINK SPACE COMPACT command to shrink the table.
Why would you choose this method? (Choose all that apply.)

ANSWER: ABD

Test4actual 1z0-052 exam Features
Quality and Value for the 1z0-052 exam
Test4actual Practice Exams for Oracle Oracle 11i 1z0-052 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.

100% Guarantee to Pass Your 1z0-052 exam
If you prepare for the exam using our Test4actual testing engine, we guarantee your success in the first attempt. If you do not pass the 1z0-052 exam Oracle 11i Designing for Oracle Internetwork Solutions) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.

Oracle 1z0-052 Downloadable, Printable Exams (in PDF format)
Our Exam 1z0-052 Preparation Material provides you everything you will need to take your 1z0-052 exam. The 1z0-052 exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first try, but also save your valuable time.

Try free 1z0-052 exam demo before you decide to buy it in Test4actual.com