当前位置：文档库 › Actualtests.Oracle.1Z0-048.Exam.Q.and.A.05.27.09

Actualtests.Oracle.1Z0-048.Exam.Q.and.A.05.27.09

Exam :1Z0-048

Title :Oracle Database 10g R2: Administering RAC Ver : 05-27-09

QUESTION 1:

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 DBC

A. What is the reason for selecting this file?

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

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

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

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

Answer: C

QUESTION 2:

To complete a cluster database creation, the DBA must choose the cluster database storage method. Which storage choice is not correct? ( Choose the incorrect one.)

A. Cluster File System

B. Raw Devices

C. Standard UNIX File System

D. Automatic Storage Management (ASM)

E. Supported SAN/NAS storage

Answer: C

QUESTION 3:

Which statement is true?

A. You must use RMAN to migrate your tempfiles to ASM storage

B. You must use RMAN to migrate your flashback log files to ASM storage

C. You must use RMAN to migrate your data files to ASM storage

D. You must use RMAN to migrate your change-tracking file to ASM storage

E. You can migrate your entire database to ASM storage without shutting down your database

F. You must use RMAN to migrate your online redo log files to ASM storage Answer: C

QUESTION 4:

In which directory should you put your callout scripts on your RAC nodes?

A. $ORACLE_HOME/opmn/conf/

B. $ORA_CRS_HOME/racg/usrco/

C. $ORA_CRS_HOME/opmn/conf/

D. $ORACLE_HOME/racg/usrco/

Answer: B

QUESTION 5:

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 DBCA to add database and ASM instances on the new cluster nodes. Do not be concerned with the correct sequence for the steps. (Choose Five.)

A. Run cluvfy stage-pre crsinst from one of the existing nodes to verify the cluster configuration

B. Run addNode.sh in the ASM home/oui/bin directory from one of the existing nodes

C. Run racgons add_config from one o the existing nodes to add the ONS metadata to the OCR

D. Run addnode.sh in the Clusterware home/oui/bin directory form one of the existing nodes to define the new node to all existing nodes

E. Run netca from the new node to add a listener to the new node

F. Run addnode.sh in the Clusterware home/oui/bin directory from each of the existing nodes once to define the new node to each existing node

G. Run addNode.sh in the RDBMS home/oui/bin directory from one of the existing nodes

Answer: B,C,D,E,G

QUESTION 6:

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

A. After you create a service using Database Configuration Assistance (DBCA), you need to start it with a separate command

B. After you create a service, you need to enable it for CRS to manage it

C. After you create a service using SRVCTL, you need to start it with a separate command

D. When suing SRVCTL to create a service, you do not need to add corresponding TNS entry in your tnsnames.ora

E. When using DBCA to create service, you do not need to add the corresponding TNS

entry in your tnsnames.ora on the cluster nodes

Answer: C,E

QUESTION 7:

You need to add a new service to your RAC database, called DBA to account for all the work done by database administrator sessions performing routing maintenance , to make this visible in the v$service_stats view. The maintenance would be done at quieter times but restricted session is not an option due to round-the-clock access requirements.

The database administrator team may connect locally or remotely to the RAC database. You decide to use DBCA to create the new service.

What must be true to allow client-server connection to the DBA service? (Choose two.)

A. The service must have at least one preferred or available instance that is running and accepting logins

B. The TNSNAMES.ORA file or a name server must contain the net service entries for the DBA service

C. All the listeners must be reloaded using LSNRCTL RELOAD to recongnize the dynamically created service

D. The ALTER SYSTEM REGISTER command must be used to include PMON to register the service with the listeners

E. The services must be started using the SRVCTL START SERVICE command

F. The service must be started using the DBMS_SERVICE.START_SERVICE procedure Answer: A,B

QUESTION 8:

You are asked to investigate a problem regarding client connectivity between the HR service and a database, which is on a four-node RAC cluster. The HR service has four preferred instances on the RAC cluster. This cluster also supports five other services. Occasinally, a client-connect request for the HR service takes several minutes to connect, whereas the other five services connect within a second or two. Client-side and

server-side connection load balancing are used for all the services. Which combination of network settings would explain these symptoms? (Choose two.)

A. The TNSNAMES.ORA file has an entry for the HR service that uses only the most host name for the public IP Address and all the listeners listen on both the Public and Virtual IP addresses

B. The listener on one or more nodes is listening on both the Public IP Address and the Virtual IP Address and HR TNSNAMES entry uses the Virtual IP Address

C. The TNSNAMES.ORA file has an entry for the five other services that use the hostnames for the Virtual IP Addresses and all the listeners listen on both the Public and Virtual IP Addresses

D. The TNSNAMES.ORA file has an entry for all six services that uses the host name for

the Public IP address and not the Virtual IP Address

E. The listener on one or more nodes is listening only on the virtual IP address and the HR TNSNAME entry uses the hostnames for the virtual IP addresses

Answer: A,C

QUESTION 9:

Exhibit:

Your work as a DBA at Certkiller .com. You study the exhibit carefully.

You are tasked to help a colleague to logically remove node NLDEDUC2 from a RAC cluster installation. On observing the colleague's terminal, you notice the output as seen in the exhibit. Based on this, which five additional steps would you recommend? Do not be concerned with the correct sequence for the steps. (Choose Five.)

A. Check that the software has been removed from the database and ASM homes on NLEDUC2

B. Stop and restart the clusterware on NLEDUC1

C. Check that the node has been removed from the database and ASM inventories

D. Check that the ONS configuration has been updated on the remaining node

E. Remove the listener from NLEDUC2

F. Check that the database and ASM instances are all terminated on NLEDUC2

G. Remove the node from the clusterware

H. Stop and restart the nodeapps on NLEDUC1

Answer: A,C,D,F,G

Which parameter file should you use to configure the Oracle notification server on your RAC nodes?

A. $ORA_CRS_HOME/opmn/conf/ons.config

B. $ORACLE_HOME/opmn/conf/ons.config

C. $ORACLE_HOME/racg/usrco/ons.config

D. $ORA_CRS_HOME/racg/usrco/ons.config

Answer: A

QUESTION 11:

Which three types of events can you trap using server-side callouts? (Choose three.)

A. Service cardinality low

B. Shadow application service up

C. EM Agent down

D. Service member down

E. Listener down

F. DB Console Down

G. Oracle instance up

Answer: B,D,G

QUESTION 12:

Certkiller .com has certain standard practices for technology and you are configuring ASM disk groups for your node RAC cluster. The company guidelines suggest that there is one disk group for the flash recovery area that is shared by all databases and a separate disk group for the database area of all database. Which three exceptions exists that may require you to create additional disk groups? (Choose three.)

A. The disk farm has different disk models with different characteristics and ages

B. There are large nonpartitioned tables accessed frequently using indexes

C. The retention policy for backups are different for different databases

D. There are partitioned tables where the older partitions are in read-only tablespace and seldom accessed, but the more recent partitions are frequently accessed

E. Application using the databases have different Service-Level agreements for response time and throughput

F. Some database instances are shutdown every night while others are always running

G. Some databases operate in ARCHIVELOGMODE and others in NOARCHIVEMODE Answer: A,D,E

You have migrated your 10g R1 cluster to 10g R2. You wish to create multiple copies of the voting disk. What must you consider when doing this?

A. Since ASM is the stated direction of Oracle, ASM is the best storage for voting disks

B. If multiplexing, two voting disks on independent devices is ideal

C. If multiplexing, three voting disks on independent devices is ideal

D. For the voting disk, it is better to rely on multipathing solutions instead of multiplexing

Answer: C

QUESTION 14:

Exhibit:

Your work as a DBA at Certkiller .com. You study the exhibit carefully. It displays the cluster database performance page after the same workload has been executed three times on your cluster without varying any non-Oracle workloads on the cluster.

What are the two ways by which you can tell that the corresponding application was better tuned during the second and third execution? (Choose two.)

A. It takes less time to execute the workload each time

B. There is less paging each time

C. The database throughput graphic below the red dashed line during the last execution

D. The number of transactions per second is getting higher each time

E. The run queue length is going down each time

Answer: A,D

QUESTION 15:

Oracle Cluster Registry (OCR) can be recovered on a UNIX platform using which two commands? (Choose two.)

A. ocrconfig - restore /app/oracle/product/10.1.0/crs_1/cdata/dbclust01/day.ocr where day.ocr is an automatically generated OCR backup

B. cp /app/oracle/product/10.1.0/crs_1/cdata/dbclust01/day.ocr /ocfs/OCR/crs.dbf where /ocfs/OCR/crs.dbf is the cluster registry file

C. orconfig - import /u01/logical_ocr/yesterday.ocr_exp where yesterday.ocr_exp is a logical backup created using the ocrconfig-export command

D. ocrconfig - import /u01/logical_ocr/yesterday.ocr where yesterday.ocr is a automatically generated OCR backup

Answer: A,C

QUESTION 16:

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

A. After you redo threads are defined, you can't add new ones

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

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

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

E. A RAC database must contain at least two threads of redo log files per interface Answer: B,C

QUESTION 17:

You decide to implement a Data Guard configuration to support a disaster recovery plan for 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. 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

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. Can be in any shared ASM disk group

D. Must be stored on Oracle Cluster File System if a cluster file system is used

E. Can be stored on shared Raw Devices

F. Many be stored on any supported cluster file system if a cluster file system is used Answer: C,E,F

QUESTION 18:

You are implementing a three-node RAC setup in Certkiller .com. You have already performed these tasks:

* Hardware and OS configuration

* Cluster File system installation

* Clusterware installation

You executed the following command in one of the nodes:

Cluvfy stage -pre dbinst -n all

What is the reason for executing this command?

A. To check for node connectivity and clusterware integrity

B. To check whether the dbinst directory is available on all the nodes

C. To check if the ORACLE_HOME environment variable is set to correct value or not before the database installation

D. To check for the existence of Oracle Database software installation files in the /stage directory on all the nodes

Answer: A

QUESTION 19:

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

A. Reconfigure listeners for the new node with netra

B. Configure the OS and hardware for the new node

C. Add instances via DBCA

D. Add the RAC software to the new node using orainstRoot.sh form ORACLE_HOME

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

QUESTION 20:

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. Reduce the number of updates causing locks on tables accessed by multiple instances

B. Use larger uniform extent sizes of objects

C. Reduce the time of transactions by committing more often

D. Increase the cache size of sequences

Answer: B

QUESTION 21:

What is the action of you client connection when it is using the following connect string?

Net_service_name=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SALES1-SVR-VIP)(PORT-152

A. It always connects you to the least loaded node

B. It tries to connect you to the listener on SALES2-SRV-VIP If the listener on

SALES1-SRV-VIP is down

C. It always connects you to the first protocol address

D. It randmizes its connections on the available listeners

Answer: B

QUESTION 22:

You are about to build a new Oracle Clusterware-based cluster and you want to make the

installation process as smooth as possible. You decide to use the Cluster Verification

Utility (CLUVFY) to check whether or not your system administrator has set up the

hardware and system software correctly. Which two statements about CLUVFY are true?

(Choose two.)

A. You can run CLUVFY only from a privileged operating system account

B. You have to install CLUVFY on all cluster nodes in order to use CLUCFY on other

nodes than the one from which you perform the installation

C. CLUVFY can't be used until the Oracle Clusterware is installed successfully

D. After the Oracle Clusterware installation, you can run CLUVFY from the Oracle

Home that holds the CRS binaries

E. To use CLUCFY during the Oracle Clusterware installation, you have to download

CLUVFY from the Oracle Technology Network (OTN) Web Site and install it before

you can use it

F. You can run CLUVFY directly from the Oracle Clusterware distribution media

Answer: D,F

QUESTION 23:

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 local storage at the observer location

C. On the shared storage at the standby location

D. On the shared storage at the primary location

E. On the shared storage at the observer location

Answer: C,D

QUESTION 24:

Which three statements about Snapshot Control File Management in a RAC environment are true? (Choose three.)

A. You can use a cluster file system or a raw device to store snapshot control files

B. You need to configure a default path and file name of these snapshot control files that is valid on every node from which you might initiate an RMAN backup

C. By default, the snapshot control file is created on the node that is making the backup

D. RMAN parameters controlling snapshot control files can be configured from the Enterprise Manager Cluster Database home page

Answer: A,B,C

QUESTION 25:

Certkiller .com 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 that all apply)

A. You want to avoid keeping Oracle binaries on local storage

B. You want to use the Oracle Managed Files (OMF) feature but that is not supported by ASM

C. You do not want to store any file other than voting and OCR files in ASM

D. You do not want to use raw devices to store voting and OCR files

E. You require OCFS to store archive log files because ASM does not support these files Answer: A,D

QUESTION 26:

Which three statements about deleting instances from a RAC database on a UNIX platform are true? (Choose three.)

A. During the delete operation, the DBCA removes the instance and the instance Oracle Net Configuration during a delete operation, the DBCA removes the instance and the instance's? Oracle Net configuration

B. To delete an instance, start the DBCA on the node that hosts the instance that you want to delete

C. To delete instance, start the DBCA on a node other than the node hosts the instance you want to delete

D. The DBCA can be used to delete an instance from a RAC database

Answer: A,C,D

QUESTION 27:

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

Answer: B,C,D,E

QUESTION 28:

Which parameter file should you use to configure the Oracle notification server on your RAC nodes?

A. $ORA_CRS_HOME/racg/usrco/ons.config

B. $ORACLE_HOME/racg/usrco/ons.config

C. $ORACLE_HOME/opmn/conf/ons.config

D. $ORA_CRS_HOME/opmn/conf/ons.config

Answer: D

QUESTION 29:

You are the administrator of a Linux-based Oracle Cluster. To meet Certkiller .com's disaster recovery requirements, you have to make backups of the ODR to a tape device. What are your options? (Choose all that apply)

A. Use RMAN to back up the OCR from disk to tape

B. Use the OCRCONFIG command to have CRSD write the OCR backup to tape for you

C. Use your favorite tape backup command to back up the OCR from disk to tape

D. Use the Linux CD command to write the OCR directly to tape

E. Use your favorite tape backup command to backup the physical OCR backups from

disk to tape

Answer: E

QUESTION 30:

After migrating from a 10g R1 Cluster to 10g R2, you decide to multiplex your voting disk. Which are the two ways in which you can accomplish this task? (Choose two.)

A. You must add additional voting disks offline

B. You may use the VIPCA utility to add new voting disks

C. You can add additional voting disks online

D. You should not use symbolic links

E. You may use the command crsctl add css votedisk Answer: C,E

QUESTION 31:

Exhibit:

Your work as a DBA at Certkiller .com. You study the exhibit carefully. :

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 instance was started by CRS after the system was rebooted, but someone stopped it from within SQL*Plus

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

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

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

Answer: E

QUESTION 32:

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

A. Reboot the node where the failing instance resides to check if the problem is persistent

B. Enable extra debugging in the Oracle Clusterware software by using the CRSCTL command

C. Check the alert.log file that belongs to the Oracle Clusterware software

D. Check the alert.log file that belongs to the instance that did not start

E. Check if the Oracle Clusterware is functional by using the CRSCTL command

F. Check the resource state by using the CRS_STAT command

G. Check for OCR corruptions by using the OCRCHECK command

Answer: C,D,F

QUESTION 33:

A. Use RMAN to back up the OCR from disk to tape

B. Use the OCRCONFIG command to have CRSD write the OCR backup to tape for you

C. Use your favorite tape backup command to backup the physical OCR backups from disk to tape

D. Use the Linux CD command to write the OCR directly to tape

E. Use your favorite tape backup command to back up the OCR from disk to tape Answer: C

QUESTION 34:

You are working as a DBA in a RAC environment that is available for testing. The RAC environment has all the database files stored in the OCFS file system. You plan to install

ASM and move all the database files to ASM to achieve better performance. During the installation, you selected redundancy level as normal for the disk group being added. What is the reason for selecting this redundancy level?

A. You do not want to have any mirroring in the disk group

B. You have three failure groups defined, so you want to use three-way mirroring

C. You have two failure groups defined, so you want to use two-way mirroring

D. You want to use hardware mirroring

Answer: C

QUESTION 35:

Which optional parameter of the DESCRIPTION clause of a TNS entry can you use to randomize the access to available listeners?

A. FAILOVER

B. SOURCE_ROUTE

C. TYPE_OF_SERVICE

D. LOAD_BALANCE

Answer: D

QUESTION 36:

What should you do when creating a disk group that would store your RAC database?

A. Make sure that ASM targets are accessible from Database Control

B. Make sure that the disk group is mounted by all ASM instances

C. Make sure that all databases instances are functional

D. Make sure that all database instances are running in restricted mode

Answer: B

QUESTION 37:

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. Many be stored on any supported cluster file system if a cluster file system is used

D. Must be stored on Oracle Cluster File System if a cluster file system is used

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

F. Can be stored on shared Raw Devices

Answer: A,C,F

QUESTION 38:

Which three statements regarding backup of the voting disk are true? ( Choose True.) A. A backup of the voting disk should be taken whenever an existing node is removed from the cluster

B. A backup of the voting disk should be taken whenever an RMAN catalog reset is done

C. Whenever a voting disk backup is made, the Clusterware software should be stopped on all nodes in the cluster

D. On UNIX platforms, the voting disk can be backed up with the dd command

E. A backup of the voting disk should be taken whenever a new node is added to the cluster

Answer: A,D,E

QUESTION 39:

You have migrated your 10g R1 cluster to 10g R2. You wish to create multiple copies of the voting disk. What must you consider when doing this?

A. If multiplexing, two voting disks on independent devices is ideal

B. For the voting disk, it is better to rely on multipathing solutions instead of multiplexing

C. If multiplexing, three voting disks on independent devices is ideal

D. Since ASM is the stated direction of Oracle, ASM is the best storage for voting disks Answer: C

QUESTION 40:

Which two initialization parameters must be set to start up an ASM instance in a RAC environment? (Choose two.)

A. ASM_POWER_LIMIT

B. CLUSTER_DATBASE

C. DB_UNIQUE_NAME

D. ASM_DISKSTRING

E. INSTANCE_TYPE

Answer: C, E

Explanation:

Not ASM_DISCSTRING. ASM_DISCSTRING is not to be set. It defaults to null. Reference: https://www.wendangku.net/doc/ce13051683.html,/articles/10g/AutomaticStorageManagement10g.php QUESTION 41:

Which three tools can you use to patch your RAC database? (Choose three.)

A. emca

B. Oracle Universal Installer

C. dbca

D. EM Database Control

E. emctl

F. opatch

Answer: B,D,F

QUESTION 42:

Which initialization parameter would you use for each RAC instance to make sure that each listener on each RAC node is aware of the load of all the others?

A. REMOTE_LISTENER

B. PREFER_LEAST_LOADED_NODE_

C. REMOTE_DEPENDENCIES_MODE

D. LOCAL_LISTENER

Answer: A

QUESTION 43:

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

A. You can't mix automatic undo management and manual undo management

B. A RAC database must have defined only one undo tablespace for each instance

C. It is possible to store undo tablespace on nonshared disks

D. A RAC database contains one undo tablespace shared by all instances

Answer: A

QUESTION 44:

Which three statements about Snapshot Control File Management in a RAC environment are true? (Choose three.)

A. You can use a cluster file system or a raw device to store snapshot control files

B. You need to configure a default path and file name of these snapshot control files that is valid on every node from which you might initiate an RMAN backup

C. RMAN parameters controlling snapshot control files can be configured from the Enterprise Manager Cluster Database home page

D. By default, the snapshot control file is created on the node that is making the backup Answer: A,B,D

QUESTION 45:

Which three statements about patching Oracle products in a clustered environment are true? (Choose three.)

A. The Oracle Universal Installer (OUI) is cluster-aware and able to mange patches on all nodes in your cluster

B. OUI prevents potentially destructive concurrent patch installation through the use of inventory List Locks

C. OUI manages patches in a clustered environment only if a shared ORACLE_HOME is employed

D. The OUI automatically manages the patch installation progress, including the copying of files to remote nodes, just as it does with the CRS and database binary installations Answer: A,B,D

QUESTION 46:

Which statement is true?

A. You must use RMAN to migrate you data files to ASM storage

B. You must use RMAN to migrate your change-tracking file to ASM storage

C. You must use RMAN to migrate your tempfiles to ASM storage

D. You must use RMAN to migrate your online redo log files to ASM storage

E. You must use RMAN to migrate your flashback log files to ASM storage

F. You can migrate your entire to ASM storage without shutting down your database Answer: A

QUESTION 47:

Your storage administrator informs you about some disk corruption issues in the disk subsystem where your Oracle Cluster Registry (OCR) backups are located. Your storage administrator has resolved these corruption issues by applying a patch to the storage subsystem, but to be sure that the OCR backups are not affected by this problem the administrator wants you to check the integrity of the OCR backups.

How would you do this?

A. You can check whether the OCR backups are not corrupted by using the OCRCHECK command

B. You create a logical export from the OCR backups by using the OCRCONFIG command and analyze the export file for errors

C. You create another physical backup of the OCR backups by using the OCRCONFIG command and if this succeeds without errors you know that the OCR backups are not corrupted

D. There is no easy way to check your OCR backups for corruptions

E. You dump the OCR backup contents into a text file by using the OCRDUMP command and if the succeeds without errors you know that your OCR backups are not corrupted

Answer: E

QUESTION 48:

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

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

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

Answer: B,C

QUESTION 49:

A. Some databases operate in ARCHIVELOGMODE and others in NOARCHIVEMODE

B. There are large nonpartitioned tables accessed frequently using indexes

C. The retention policy for backups are different for different databases

D. The disk farm has different disk models with different characteristics and ages

E. Some database instances are shutdown every night while others are always running