Free Oracle Database 19c: RAC, ASM, and Grid Infrastructure Administration Exam 1Z0-078 Exam Practice Test

Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 19c RAC? (Choose two.)

• Global Enqueues and Instance Locks replace mutexes completely in RAC database instances.
• Global Enqueues may have converters and waiters in the same instance.
• Global Enqueues may have owners and waiters in the same instance.
• Global Enqueues and Instance Locks replace latches completely in RAC database instances.
• In a RAC database, there is no LMDO process if only one instance is running.
• In a RAC One Node database, there is no LMD) process if only one instance is running.

Which three statements are true regarding multitenant architecture for RAC databases? (Choose three.)

• One undo tablespace for each pdb is required.
• PDBs can have local temporary
• You can open one, several, or all PD3s on one, several, or all cdb instances.
• It requires the cdb to use shared undo management.
• One undo tablespace for each instance is required.
• PDBs must use shared Temporary

Which three statements are true concerning activation of a user-defined policy in Oracle 19c Clusterware? (Choose three.)

• When a policy is activated, resources can be automatically stopped to comply with the policy definition.
• An administrator-defined policy may be activated using the srvctl utility.
• When a policy is first created, it is initially inactive.
• When a policy is first created, it is initially active.
• When a policy is activated, resources cannot be automatically started to comply with the policy definition.
• When a policy is activated, nodes may be reassigned to server pools based on the policy definition.

Which three resources are managed using global concurrency control in an Oracle 19c RAC multi- instance database? (Choose three.)

• Database block buffers
• Mutexes
• Redo log buffers
• Latches
• Enqueues
• Cursors

For which three entities can the "what-if" command evaluation be used to determine the impact of clusterware management operations in Oracle 19c Clusterware? (Choose three.)

• Cluster resources
• Database transactions
• Local resources
• Administrator-defined resources
• Pluggable Databases (PDBs)

A Java application using thick JDBC connections will soon be deployed, and you must configure a RAC database to support highly available connections.Broken connections must be re-established as quickly as possible. Which feature will support this requirement?

• Transparent Application Failover (TAF) using Fast Application Notification (FAN)
• Transparent Application Failover (TAF)
• Fast Connection Failover (FCF)
• Fast Connection Failover (FCF) with Transparent Application Failover (TAF)

Which statement describes the usage of Dynamic Service Fallback in Oracle RAC 19c?

• Dynamic Service Fallback allows a service to relocate to an available instance when the service is stopped on a preferred instance.
• Dynamic Service Fallback allows a service to fall back to a preferred instance when the available instance performance falls below a specified threshold after it was failed over to an available instance.
• To enable Dynamic Service Fallback, you should specify the level of performance of a preferred instance for a service to be relocated to an available instance by setting the -fallback attribute of a service to "Low, Medium, or High".
• Dynamic Service Fallback allows a service to fall back to a preferred instance when it becomes available after it was failed over to an available instance.

Examine these descriptions of ASM instance shutdown behavior:

• The ASM instance shuts down immediately without an orderly dismount of disk groups.
• Active SQL statements are allowed to complete before an orderly dismount of all disk groups occurs and then the ASM instance shuts down without waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.
• Active SQL statements are allowed to complete before an orderly dismount of all of disk groups occurs and then the ASM instance shuts down after waiting for connected sessions to disconnect. If any ASM clients are connected to the instance, then the shutdown returns an error.Which two lists are correct matches for these descriptions? (Choose two.)
• 2 = NORMAL, 3 = TRANSACTIONAL, 1 = ABORT
• 2 = NORMAL, 3 = IMMEDIATE, 1 = ABORT
• 3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT
• 3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE
• 3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT

Your four-node cluster runs Oracle 19c Clusterware and supports a mix of RAC databases from Oracle 10g Release 2 to Oracle 19c.All databases have one or more services defined.The Oracle 10g Release 2 database clients connect to the database instances using the public VIP.The Oracle 11g Release 2, 12c Release 1, and 19c clients connect to the database instances using the Single Client Access Name (SCAN).You must change the public VIPs.Which three actions must be performed to change the VIPs on host01, the first node in the cluster? (Choose three.)

• Use srvctl start vip to start the VIP on host01.
• Use oifcfg setif to start the VIP on host01.
• Use oifcfg setif to stop the VIP on host01.
• Use srvctl modify nodeapps to change the VIP on host01.
• Use srvctl stop vip to stop the VIP on host01.

Disk group DGRP1 has these attributes:

• Normal redundancy
• Two failure groups FG1 and FG2 with two disks each
• Compatibility settings set to 19.0
• The FG1 failure group goes offline due to hardware failure. Which two statements are true? (Choose two.)
• New allocation units are mirrored in the FG2 failure group until FGl is restored and the disk group resvnchronized-
• The redundancy is lowered until the FGl failgroup is restored and the disk group resynchronized.
• New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.
• Transactions on database objects stored in tablespaces in the dgrpi disk group fail.