Online Access Free 1Z0-048 Exam Questions

You decide to implement Fast Start Failover for your RAC Data Guard configuration to improve your high availability strategy. Which are the two valid locations for the DG Broker configuration files? (Choose two.)

• A.on the storage that is shared between the observer location and at least one of the instances that is part of the data guard configuration
• B.on the shared storage at the standby location
• C.on the shared storage at the primary location
• D.on the shared storage at the observer location
• E.on the local storage at the observer location

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

• A.RAC alone would increase availability when doing release upgrades.
• B.RAC used in conjunction with parallel execution may provide speedup of DSS queries.
• C.RAC would increase availability in the event of data failures.
• D.RAC used in conjunction with parallel execution may provide for speedup of OLTP workload processes.
• E.RAC alone would not help protect from human errors.
• F.RAC would increase availability in the event of a network failure.
• G.RAC would increase scalability for all application workloads in all cases.
• H.RAC would increase availability in the event of node and instance failures.

Several steps must be followed to successfully add a new node to your cluster database. Assuming that a UNIX platform is used, which of the three steps below are correct? (Choose three.)

• A.Reconfigure listeners for the new node with netca.
• B.Configure the OS and hardware for the new node.
• C.Add the node to the cluster using the addnode.sh script run from ORA_CRS_HOME.
• D.Add instances using OUI.
• E.Add the RAC software to the new node using addnode.sh from ORA_CRS_HOM

You are running a two-instance database with six redo log groups defined and decide to add a third thread to support a third database instance on the third node of the cluster. Which three commands would you issue to achieve this using command line administration? (Choose three.)

• A.ALTER SYSTEM ADD LOGFILE THREAD 3 GROUP 7;
• B.ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 8;
• C.ALTER DATABASE ENABLE THREAD 3;
• D.ALTER SYSTEM ADD LOGFILE THREAD 3 GROUP 8;
• E.ALTER SYSTEM ENABLE THREAD 3;
• F.ALTER DATABASE ADD LOGFILE THREAD 3 GROUP 7;

According to the Maximum Availability Architecture, which case is best?

• A.Run two identical sites with a primary RAC database on the first site, and only a RAC logical standby database on the second site.
• B.Run two identical sites with a primary RAC database on the first site, and RAC physical and logical standby databases on the second site.
• C.Run two identical sites with a primary RAC database on the first site, and non-RAC physical and logical standby databases on the second site.
• D.Run two identical sites with a primary RAC database on the first site, and only a RAC physical standby database on the second site.