1Z0-048 Exam Training Practice Tests (Oracle Database 10g R2: Administering RAC)]

Question 1

The maximum number of redo threads for a database from 10g R2 is

A. determined by the number of nodes in the cluster B. determined by the maxthreads setting C. not limited because the control file can extend for more thread records if required to D. determined by the maxlogfiles setting E. determined by the maxinstances setting

Correct Answer: E

Question 2

In a RAC environment, you see a steep increase for enq:HW- contention and gc current grant wait events. What would you do to fix this issue?

A. Increase the cache size of sequences. B. Reduce the number of updates causing locks on tables accessed by multiple instances. C. Reduce the time of transactions by committing more often. D. Use larger uniform extent sizes for objects.

Correct Answer: D

Question 3

You decide to implement a Data Guard configuration to support a disaster recovery plan for your RAC database. Your primary database has all shared files and the flash recovery area is stored on ASM disk groups. Which three options exist for storing the data guard broker configuration files at the primary location? (Choose three.)

A. can be in any shared ASM disk group B. must be in the same shared ASM disk group as the Flash Recovery Area if the broker configuration files are stored in ASM disk groups. C. must be stored on Oracle Cluster File System if a cluster file system is used D. can be stored on shared Raw Devices E. may be stored on any supported cluster file system if a cluster file system is used F. must be in the same shared ASM disk group as the database data files if the broker configuration files are stored in ASM disk groups

Correct Answer: A,D,E

Question 4

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

A. After you create a service using Database Configuration Assistant (DBCA), you need to start it with a separate command. B. When using DBCA to create a service, you do not need to add the corresponding TNS entry in your tnsnames.ora on the cluster nodes. C. After you create a service, you need to enable it for CRS to manage it. D. After you create a service using SRVCTL, you need to start it with a separate command. E. When using SRVCTL to create a service, you do not need to add the corresponding TNS entry in your tnsnames.ora.

Correct Answer: B,D

Question 5

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

A. You require OCFS to store archive log files because ASM does not support these files. B. You do not want to store any file other than voting and OCR files in ASM. C. You do not want to use raw devices to store voting and OCR files. D. You want to avoid keeping Oracle binaries on local storage. E. You want to use the Oracle Managed Files (OMF) feature but that is not supported by ASM.

Correct Answer: C,D

Question 6

Which optional parameter of the DESCRIPTION clause of a TNS entry can you use to make sure that another protocol address is tried if the first one fails?

A. SOURCE_ROUTE B. FAILOVER C. LOAD_BALANCE D. TYPE OF SERVICE

Correct Answer: B

Question 7

You and your colleague are working with Oracle Support on a database instance stability issue. The Oracle Support engineer wants you to issue a crsctl debug log crs ?crsctl debug log crs command to assist you in your troubleshooting assignment. Why does the Oracle Support engineer want you to do this?

A. to enable extra debugging on the CRS daemon the next time the CRS daemon is started B. to list which debugging options are enabled on the CRS daemon C. to enable extra debugging on the currently running and CRS daemons as well as those that will run in the future D. to enable extra debugging on the currently running CRS daemon E. to list what debugging options are available on the CRS daemon

Correct Answer: C

Question 8

Which three statements regarding backup of the voting disk are true? (Choose three.)

A. On UNIX platforms, the voting disk can be backed up with the dd command. B. Whenever a voting disk backup is made, the Clusterware software should be stopped on all nodes in the cluster. C. A backup of the voting disk should be taken whenever a new node is added to the cluster. D. A backup of the voting disk should be taken whenever an RMAN catalog reset is done. E. A backup of the voting disk should be taken whenever an existing node is removed from the cluster.

Correct Answer: A,C,E

Question 9

Which statement is true regarding undo management in a RAC environment?

A. A RAC database must have defined only one undo tablespace for each instance. B. You cannot mix automatic undo management and manual undo management. C. A RAC database contains one undo tablespace shared by all instances. D. It is possible to store undo tablespaces on nonshared disks.

Correct Answer: B

Question 10

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. 6,3,5, 2,1 B. 2,6,3, 5,1 C. 6,3,2, 5,1 D. 2,5,1, 4,3 E. 2,5,1, 4,6 F. 3,6,5, 2,1

Correct Answer: A,C,F

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