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

Which three statements are correct regarding ASM instances in a RAC environment? (Choose three.)

You decide to change the redo thread of one of your database instances.
Now you have only two threads: thread 1 is currently being used by instance RAC01, and thread 2 is currently being used by instance RAC02.
In which three orders could you perform the following commands to add thread 3 to your
database, and ensure that instance RAC01 is using thread 3? (Choose three acceptable orders.
1 srvctl stop instance -d RACDB -i RAC01
2 ALTER DATABASE ENABLE THREAD 3;
3 ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 6;
4 srvctl start instance -d RACDB -i RAC01
5 ALTER SYSTEM SETthread=3 SCOPE=SPFILE SID='RAC01';
6 ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 5;

You are asked to justify your proposed Maximum Availability Architecture to the IT director who feels that a four-node RAC cluster on the primary should not require a four-node RAC cluster for a physical standby database. The director suggests that either a non-RAC database should be used on the standby or that at most a two-node cluster is all that is required. Your proposed architecture was designed for both planned and unplanned downtime and for performance and scalability of services for all eventualities. How would you justify your proposal? (Choose two.)

Your company requires that certain database systems be made continuously available because there are revenue-earning applications using Oracle databases. You already use RAC; it is a requirement for the applications to have continuous read and write access to all schema objects in the database during routine DBA maintenance activities. Which three technologies would you recommend for minimizing planned downtime for the application caused by unavailability of data due to those activities? (Choose three.)

You have a three-tier architecture for your application, which uses an Oracle RAC database and a middle tier that uses Oracle Application Server with Java programming, using JDBC as the standard. There are three RAC services defined, and four instances in the database are using ASM as the cluster file system. Connection pools are also used. Which three features of Fast Application Notification would be beneficial in your environment, and which choices for your application would you recommend? (Choose three.)

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

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.)

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.)

Your four-node RAC cluster is no longer coping with workloads for one of its databases at peak periods and you decide to add another node to the cluster. The current configuration has two RAC databases, each with four instances with only the second database using ASM as a clustered database file system. ASM is installed in a separate home. Which five steps must you take to add all the software components and processes to the new node before you run DBCAto add database and ASM instances on the new cluster nodes. Do not be concerned with the correct sequence for the steps. (Choose five.)