Oracle Database 10g R2: Administering RAC (1Z0-048) Free Practice Test

Question 1

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. Add the node to the cluster using the addnode.sh script run from ORA_CRS_HOME.

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

D. Add the RAC software to the new node using addnode.sh from ORA_CRS_HOM

E. Add instances using OUI.

Correct Answer: A,B,C

Question 2

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

A. When you have a serious crash of your primary site, Data Guard Broker automatically initiates the failover to the standby site.

B. When you have a serious crash of your primary site, it is your responsibility to initiate the failover to the standby site in case you are not using the Fast-Start Failover feature.

C. Each primary RAC instance must send its redo stream to the same standby RAC instance.

D. You can have multiple RAC instances apply standby redo log files to the standby database.

E. It is the Data Guard Broker's responsibility to communicate with CRS during a switchover operation to stop and start services according to each Data Guard site role.

Correct Answer: B,E

Question 3

View the Exhibit and examine an installation step of Oracle Enterprise Manager Grid Control 10gR2 to manage your RAC installation. You entered the host name but you are not sure about the port number. Thefollowing is the list of port numbers from the host ed-otraclin17b.us.oracle.com:

A. 1521

B. 1158

C. 5561

D. 3938

E. 4889

Correct Answer: A

Question 4

You are creating a database in your RAC implementation. You are using the DBCA to create the database, and you selected the Raw Devices Mapping file on one of the screens of the DBCA. What is the reason for selecting this file?

A. You want to set the appropriate raw partition for each database file.

B. You want the DBCA to bind the partitions to raw devices.

C. You want to provide the DBCA with a list of all the storage devices that are currently bound to a raw interface.

D. You want to configure an ASM diskgroup containing raw devices.

Correct Answer: A

Question 5

What does your client connection do using this connect string?
n et_s e rvi c e_n a m e=
(DESCRIPTION
(LOAD_BALANCE=on)
(ADDRESS=(PROTOCOL=tcp)(HOST=sales1 -svr-vip)(PORT=1521))
(ADDRESS=(PROTOCOL=tcp)(HOST=sales2-svr-vip)(PORT=1521)))
(CONNECT_DATA=(SERVICE_NAME=sales. us. acme, com))

A. It connects you to the least loaded node.

B. It randomizes its connection request on the available listeners.

C. It connects you to the least loaded instance.

D. It connects you to the instance on the least loaded node that currently accepts logins for the SALES.US.ACME.COM service.

Correct Answer: B

Question 6

Which background process communicates load information to its listener?

A. PMON

B. MMON

C. LMON

D. SMON

Correct Answer: A

Question 7

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.

A. 1,3,4,6

B. All the tasks

C. 1,2,3,5,6,8

D. 2,3,4,6,7

E. 2,3,5,7,8

Correct Answer: E

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

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

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

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

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

Correct Answer: C

Question 9

You are considering issues involving backup and recovery of the voting disk. Select four correct statements. (Choose four.)

A. To back up the voting disk, use the command ocrconfig -export.

B. You can determine the voting disks currently used by CSS with the command crsctl query ess votedisk.

C. Backup can be performed online.

D. If you lose your voting disk and do not have a backup, you must reinstall Oracle Clusterware.

E. Use symbolic links to simplify recovery of the voting disk.

Correct Answer: C,D,E

Question 10

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 only a RAC physical standby database on the second site.

C. Run two identical sites with a primary RAC database on the first site, and 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 non-RAC physical and logical standby databases on the second site.

Correct Answer: C

Welcome to TestSimulate

Oracle Database 10g R2: Administering RAC (1Z0-048) Free Practice Test