Free Oracle 1Z0-048 Practice Test & Real Exam Questions

Which three statements are true regarding RAC instance startup and shutdown using SQL'Plus? (Choose three.)

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?

You have a well-tuned, non-RAC single instance Oracle database with several services, all of which perform perfectly. You plan to migrate the database to RAC in the next two weeks and all file systems would be shared using Oracle Cluster File System. After the migration, you want to perform a test to monitor RAC-specific tuning issues that would not have occurred on a non-RAC database. Which six areas would you monitor to determine whether there are RAC-specific performance problems after migration? (Choose six.)

After a failed cluster database creation process, you realize that the contents of the OCR does not
match the current cluster configuration anymore. Before you started the database creation
process, you created a logical backup of the OCR, and now you want to use this logical backup to
bring the OCR contents in sync with the current cluster configuration.
Which commands would you use and in which order to accomplish this task?
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)

The following are some of the tasks that are performed during a RAC implementation: 1) Setting the Oracle database-related environment variables 2) Creating a password file 3) Installing Management Service and Management Agent 4) Creating and editing the Raw Device Mapping file 5) Creating an ASM instance 6) Creating the Oracle Cluster Registry (OCR) file 7) Implementing the Transparent Application Failover (TAF) policy 8) Creating database services Identify the tasks that can be performed using the DBCA, or performed by the DBCA, during database creation in the RAC implementation.

You are preparing to create a RAC cluster. You review the RAC requirements for UNDO tablespaces. Which three are valid statements? (Choose three.

Several steps must be followed to successfully add a node to your cluster database. Assuming that a UNIX platform is used, which of the steps listed below is not correct? (Choose the incorrect step.

You are the administrator of a Linux-based Oracle cluster. To meet your company's disaster recovery requirements, you have to make backups of the OCR to a tape device. What are your options? (Choose all that apply.)

You have attended a user group presentation on RAC and based on what you have learned you feel that your company would benefit from having the RAC option to meet its Oracle database requirements in several ways. Your manager does not know much about RAC and asks you to create a presentation to the team explaining RAC, and whether it should be implemented in your installation. Which three statements explain the benefits and implications of RAC? (Choose three.)