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 al the requested log and trace files?

• A. Use Grid Control to collect and send all required log and trace files to Oracle Supporl.
• B. Upload each and every available log and trace files to Oracle Support.
• C. Collect all required log and trace files using the diagcollection.plcommand 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.

Your storage administrator informs you about some disk corruption issues in the disk subsystem where your Oracle Cluster Registry (OCR) backups are located. Your storage administrator has resolved these corruption issues by applying a patch to the storage subsystem, but to be sure that the OCR backups are not affected by this problem the administrator wants you to check the integrity of the OCR backups. How would you do this?

• A. You can check whether the OCR backups are not corrupted by using the OCRCHECK command.
• B. You create another physical backup of the OCR backups by using the OCRCONFIG command, and if this succeeds without errors you know that the OCR backups are not corrupted.
• C. There is no easy way to check your OCR backups for corruptions.
• D. You create a logical export from the OCR backups by using the OCRCONFIG command and analyze the export file for errors.
• E. You dump the OCR backup contents into a text file by using the OCRDUMP command, and if that succeeds without errors you know that your OCR backups are not corrupted.

Which two statements are true in a RAC environment? (Choose two.)

• A. After you create a service, you need to enable it for CRS to manage it.
• B. After you create a service using Database Configuration Assistant (DBCA), you need to start it with a separate command.
• C. When using DBCA to create a service, you do not need to add the corresponding TNS entry in your tnsnames.ora on the cluster nodes.
• D. After you create a service using SRVCTL, you need to start it with a separate command.
• E. When using SRVCTL to create a service, you do not need to add the corresponding TNS entry in your tnsnames.ora.

View the Exhibit, which displays the cluster database performance page after the same workload has been executed three times on your cluster without varying any non-Oracle workloads on the cluster. What are the two ways by which you can tell that the corresponding application was better tuned during the second and third execution? (Choose two.)

• A. The number of transactions per second is getting higher each time.
• B. The database throughout graphic is below the red dashed line during the last execution.
• C. The run queue length is going down each time.
• D. It takes less time to execute the workload each time.
• E. There is less paging each time

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. 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.
• B. 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.
• C. Tune SQL for the OLTP and DSS service programs because they may benefit from SQL tuning.
• D. Tune SQL from the BATCH service programs because they may benefit from SQL tuning.
• E. The BATCH service programs may scale well and could benefit from adding new database instances on either node 5 or 6, or on both.