Online Access Free 1Z0-048 Exam Questions

What is true about Virtual Internet Protocol Configuration Assistant (VIPCA)?

• A.Each Virtual IP (VIP) configured requires an unused and resolvable IP address.
• B.The VIP for each node should be bound to the adapter that is acting as the private interconnect.
• C.The VIPCA application must be run manually on all nodes in the cluster.
• D.The ifconfig -a command is used to back out a faulty VIPCA configuration.

You observe a high number of gc current failure on your RAC system. What could be causing this issue?

• A.There is too much contention on the High Water Mark enqueue of your tables.
• B.Too much parsing is occurring on your system.
• C.You are not using the correct private interconnect.
• D.Too much manual locking is occurring.

Your company has a combination of high availability and scalability requirements that need to be addressed, and RAC has been discussed as a solution. There are a mix of "off-the-shelf software products and homegrown applications currently in use in your environment that run on single-instance Oracle databases. You have been asked by the IT director to provide an impact analysis report to help assess the impact on applications when migrating to RAC. Which three are among the areas that should be examined for performance impact and application functionality impact or for both? (Choose three.)

• A.applications that use large parallel full table scans
• B.applications that access small tables using the same index occasionally
• C.applications that use SQL profiles created by the ATO optimizer in the SQL Tuning Advisor
• D.applications that truncate tables in a data warehouse process
• E.three-tier applications that use application global context variables
• F.client/server type applications that use application local context variables

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

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

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

• A.To delete an instance, start the DBCA on a node other than the node that hosts the instance that you want to delete.
• B.During a delete operation, the DBCA removes the instance and the instance Oracle Net configurationDuring a delete operation, the DBCA removes the instance and the instance? Oracle Net configuration.
• C.The DBCA can be used to delete an instance from a RAC database.
• D.To delete an instance, start the DBCA on the node that hosts the instance that you want to delete.