1z0-068 Oracle Database 12c: RAC and Grid Infrastructure Administration - Practice Questions

Question 4

Which two statements are true concerning Oracle 12c Clusterware-managed application VIPs? (Choose two.)

Select all that apply, then click Submit answer.

○
If an application sends messages to be displayed and sets the DISPLAY variable, then an application VIP is required.
○
An application VIP is created on the default network by the appvipcfg utility.
○
An application VIP is created on the interconnect network by the crsctl utility.
○
An application VIP can be created with the crsctl utility.
○
Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails.

Reference / correct answer:

An application VIP is created on the default network by the appvipcfg utility.

An application VIP can be created with the crsctl utility.

B: Oracle 11.2 introduced appvipcfg utility for creating VIPs. From the GRID_HOME/bin directory run the appvipcfg command to create the application VIP. Oracle Clusterware assigns this VIP to a physical server in the cluster and will migrate the VIP to a surviving node in the cluster in the event of a server failure.

Example: appvipcfg create -network=1 -ip=192.168.20.111 -vipname=MyTestVIP -user=grid

D: While you can add a VIP in the same way that you can add any other resource that Oracle Clusterware manages, Oracle recommends using the script Grid_home/bin/appvipcfg to create or delete an application VIP.

Incorrect Answers:

E: When a node dies in an Oracle RAC cluster, the Virtual IP (VIP) fails over to a different node.

Upon node failure application VIP fails over to a surviving node along with the protected application. It is the Application VIP that is used for accessing the application, thus in case of failure the application will be highly.

References: https://gjilevski.com/2011/11/13/build-ha-for-third-party-application-with-oracle-gi-11-2-0-3/

Question 5

You created a RAC database with DBCA and decide to verify it.

The server pool large_db has four servers.

Examine the output shown:

Which two statements are true based on this output? (Choose two.)

Select all that apply, then click Submit answer.

○
The sales database resource will be started and the database instances will be started automatically when restarting the clusterware stack after normal shutdown of the sales database.
○
The sales database resource will be restored to its previous running condition when restarting the clusterware stack after normal shutdown of the sales database.
○
The sales database resource will be restarted automatically after an instance failure.
○
The concurrency values are not shown because sales in not a RAC One Node database.
○
The concurrency values are not shown because sales has only one of its four instances running.

Question 6

Examine these commands:

srvctl add service -db RACDB -service CRM -preferred RACDB_1 -available RACDB_2 tafpolicy preconnect srvcl start service -db RACDB -service CRM

Instances RACDB_1 and RACDB_2 run on host0l and host02, respectively.

This is the only TNS entry in the client side tnsnames.ora:

CRM =

(DESCRIPTION =(FAILOVER=ON) (LOAD_BALANCE=ON)

(ADDRESS= (PROTOCOL=TCP) (HOST=host0l-VIP.example.com)(PORT=1521))

(ADDRESS= (PROTOCOL=TCP) (HOST=host02-VIP.example.com)(PORT=1521))

(CONNECT_DATA = (SERVICE_NAME = CRM)

(FAILOVER_MODE = (BACKUP=CRM_PRECONNECT)

(TYPE=SESSION)(METHOD=PRECONNECT))))

Which statement is true regarding the TAF settings?

Select an option, then click Submit answer.

○
Clients using this configuration fail over and restart any active queries automatically.
○
Clients using this configuration fail over and restart any active transactions automatically.
○
This configuration will work only for a policy-managed RAC database.
○
The configuration is incomplete because the TNS entry for the preconnected backup session is missing.

1z0-068 – Oracle Database 12c: RAC and Grid Infrastructure Administration