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

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. Occasionally, 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 ITCertKeys.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

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

	Web www.certsbraindumps.com