Oracle Database 10g R2: Administering RAC - 1Z0-048 Exam Practice Test

Question 1

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;

A. 2,6,3, 5,1

B. 2,5,1, 4,6

C. 2,5,1, 4,3

D. 6,3,2, 5,1

E. 3,6,5, 2,1

F. 6,3,5, 2,1

Correct Answer: D,E,F

Question 2

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

A. A RAC database must contain at most one redo thread for each instance.

B. A publicly enabled thread can be used by any instance of your RAC database.

C. A RAC database must contain at least two threads of redo log files per instance.

D. After your redo threads are defined, you cannot add new ones.

E. A redo thread must contain at least two groups of redo log files before it can be enabled.

Correct Answer: B,E

Question 3

Which four statements contain accurate information regarding RAC VIPs and application VIPs? (Choose four.)

A. It is recommended to share a RAC VIP among several database instances.

B. It is not recommended to share an application VIP among several applications.

C. A failed over application VIP does accept new connections.

D. An application VIP fails over if the associated application fails over.

E. A RAC VIP fails over if the listener fails.

F. It is recommended to share application VIPs among multiple applications.

G. A failed over RAC VIP does accept new connections.

H. It is not recommended to share a RAC VIP among several database instances.

Correct Answer: A,B,C,D

Question 4

View the Exhibit.
Users complain about the performance of an Oracle database-based application. You are requested to investigate. From Grid Control, you immediately infer that one of the cluster database instances is currently unavailable. You also notice that the host where the instance belongs was recently rebooted due to an unknown reason.
Using Grid Control, you restart the instance and performance rapidly improves. You want to determine the cause of the instance startup failure after the system reboot, and you check the resource profiles on both the database and ASM instances involved.
Why was the instance not started by CRS?

A. The instance was not started by CRS because its target state was set to "offline" before the system was rebooted.

B. The database instance's autostart attribute indicates that CRS should not restart it after system boot.

C. The instance was started by CRS but due to multiple instance failures CRS disabled the database instance, thereby preventing further restarts.

D. The instance was started by CRS after the system was rebooted, but someone stopped it from within SQL*Plus.

E. The instance could not be started by CRS because this instance depends on an ASM instance, which has its autostart attribute set to a value, thereby preventing CRS from starting this ASM instance after a system reboot.

Correct Answer: B

Question 5

View the Exhibit and examine the diagram of the RAC environment implemented on a Linux platform in your company.
As a senior DBA, you have been assigned the task to implement ASM in this environment. You configured the raw devices that you plan to add to the ASM disk group.
How would you create an ASM instance on each node? (Choose all that apply.)

A. by using Database Configuration Assistant (DBCA) on any one of the nodes

B. by using DBCA on all nodes

C. by using the ASMCMD command-line utility on both the nodes

D. by using the oracleasm configure command on both the nodes

E. by using the oracleasm configure command on any of the nodes

F. by using Oracle Universal Installer (OUI) on any one of the nodes

Correct Answer: A,F

Question 6

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. Add the RAC software to the new node using addnode.sh from ORA_CRS_HOM

B. Reconfigure listeners for the new node with netca.

C. Add instances using OUI.

D. Add the node to the cluster using the addnode.sh script run from ORA_CRS_HOME.

E. Configure the OS and hardware for the new node.

Correct Answer: B,D,E

Question 7

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 Oracle Database 10g CRS stack is compatible with Oracle 9i Group Services (GSD) processes.

C. The Oracle9i srvConfig.loc file still exists for backward compatibility in Oracle Database 10g.

D. The installation of Oracle Clusterware is not necessary if you have already installed vendor-specific clusterware.

Correct Answer: A,C

Question 8

View the Exhibit.
Users complain about the performance of an Oracle database-based application. You are requested to investigate. From Grid Control, you immediately infer that one of the cluster database instances and one of the cluster ASM instances are currently unavailable. You also see that the host where the instance belongs was recently rebooted due to an unknown reason.
Using Grid Control, you restart the instance and performance rapidly improves. You want to determine the cause of the instance startup failure after system boot, and you check the resource profiles on both the database and ASM instances involved.
Why was the instance not started by CRS?

A. The database instance could not be started by CRS because this instance depends on an ASM instance, whose autostart attribute indicates that CRS should not start this ASM instance after system boot.

B. The instance was started by CRS but due to multiple instance failures CRS disabled the database instance, thereby preventing further restarts.

C. The instance was not started by CRS because its target state was set to "offline" a while before the system was rebooted.

D. The instance was started by CRS after the system was rebooted, but someone stopped it from within SQL*Plus.

E. The database instance autostart attribute is set to a value, thus preventing CRS from starting it after a system reboot.

Correct Answer: A

Question 9

Which two tools will prompt you for the possible creation of ASM instances in a RAC environment? (Choose two.)

A. SRVCTL

B. DBCA

C. OUI

D. VIPCA

E. ASMCMD

Correct Answer: B,C

Question 10

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

A. To start or shut down your local instance, initiate a SQL*Plus session connected as SYSDBA or SYSOPER, and then issue the required command.

B. Using SQL*Plus to start and stop the RAC database instances is the preferred method because SQL*Plus is a Clusterware client.

C. You can start multiple instances from a single SQL*Plus session on one node using Oracle Net Services connection strings.

D. It is not possible to start up or shut down more than one instance at a time in SOL*Plus. so you cannot start or stop all the instances for a cluster database with a single SQL*Plus command.

Correct Answer: A,C,D

Oracle Database 10g R2: Administering RAC - 1Z0-048 Exam Practice Test

Latest Update

Useful Links

Contact Us