Instantly download 1Z0-048 training test engine

Oracle 1Z0-048 Exam Overview:

Oracle 1Z0-048 Exam Syllabus Topics:

Oracle Database 10g R2: Administering RAC Sample Questions:

1. 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) A backup of the voting disk should be taken whenever a new node is added to the cluster.
C) Whenever a voting disk backup is made, the Clusterware software should be stopped on all nodes in 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.

2. 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 routine 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 administration team may connect locally or remotely to the RAC database. You decide to use DBCAto create the new service. What must be true to allow client-server connection to the DBA service? (Choose two.)

A) The services must be started using the SRVCTL START SERVICE command.
B) The TNSNAMES.ORAfile or a name server must contain the net service entries for the DBA service.
C) The service must have at least one preferred or available instance that is running and accepting logins.
D) The service must be started using the DBMS_SERVICE.START_SERVICE procedure.
E) The ALTER SYSTEM REGISTER command must be used to induce PMON to register the service with the listeners.
F) All the listeners must be reloaded using LSNRCTL RELOAD to recognize the dynamically created service.

3. 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 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 only on the Virtual IP address and the HR TNSNAMES entry uses the Hostnames for the Virtual IP addresses.
C) 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.
D) 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.
E) The listener on one or more nodes is listening on both the Public IP address and the Virtual IP address, and the HR TNSNAMES entry uses the Virtual IP address.

4. You are asked by the DBA team leader to consolidate three different Oracle databases, which supported three separate workloads, into one large three-instance RAC database on a three-node cluster. You also need to create a separate service to represent each workload type and support client-side load balancing. The CRM service has two preferred instances, the HR service has two, and the ORDERS service
has only one. Any instance may be used as an vailable instance for any service that is not
specified as a preferred service for that same instance. You decide to create three separate
entries in TNSNAMES.ORA.
Choose three options describing the number of entries you would have in each address list.
(Choose three.)

A) three entries in the address list for the CRM service for the listeners on all three nodes
B) three entries in the address list for the HR service for the listeners on all three nodes
C) two entries for the address list for the HR service for the listeners on the nodes containing the preferred instances for HR
D) one entry for the address list for the ORDERS service for the listeners on the nodes containing the preferred instance for ORDERS
E) three entries in the address list for the ORDERS service pointing to the listeners on all three nodes
F) two entries for the address list for the CRM service pointing to the listeners on the nodes containing the preferred instances for CRM

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

Solutions: