1Z0-078 Oracle Database 19c:RAC, ASM, GI

You administer a RAC database that currently runs on a four-node cluster but which has three instances. Which two statements are always true about redo logs for this RAC database?. A redo log group added using ALTER DATABASE ADD LOGFILE without the INSTANCE clause is added to each instance. A thread of redo log is automatically dropped when an instance is removed from a RAC database by using SRVCTL. A thread of redo must contain at least two log group before it can be enabled. A thread of redo must be created before starting a fourth instance if a thread is not already available. All the instances must have the same number of redo logs groups and each group must have the same number of redo log member.

Which two actions guarantee that time is synchronized properly on all nodes in a cluster after installing Oracle Grid Infrastructure 19c. Deactivate network time protocol (NTP) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in active mode when the clusterware is started. Configure network time protocol (NTP) an all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in observer mode when the clusterware is started. If network time protocol (NTP) time servers are unreachable on any cluster node, then Oracle Cluster Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started. Configure network time protocol (NTP) on all cluster nodes, and then start the Oracle Cluster Time Synchronization Service (CTSSD) in active mode on all cluster nodes. If network time protocol (NTP) is not configured properly on all cluster nodes, then Oracle Cluster Time Synchronization Service (CTD) will start automatically in active mode when the clusterware is started.

Oracle Clusterware manages an administrator-managed database service defined with the manual managed policy Which two statements are true?. Clusterware will monitor the service while it is active. The service must be manually restarted with srvctl after restarting the clusterware stack on the node hosting the service. When manually started, the service will always start on one or more available instances rather than on their preferred instances. The service must be manually started with srvctl after a planned restart of the instance hosting the service. The service must be manually restarted with srvctl every time the instance hosting the service fails.

Examine these descriptions of ASM instance shutdown behavior: 1) The ASM instance shuts down immediately without an orderly dismount of disk groups. 2) 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. 3) 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?. 3 = NORMAL, 2 = ABORT, 1 = IMMEDIATE. 3 = NORMAL, 2 = TRANSACTIONAL, 1 = ABORT. 2= NORMAL, 3= IMMEDIATE, 1 = ABORT. 2 = NORMAL, 3= TRANSACTIONAL, 1 =ABORT. 3 = NORMAL, 2 = IMMEDIATE, 1 = ABORT.

Which statement is true about the UNDROP clause of the ALTER DISKGROUP statement?. It automatically unmounts the disks after successfully undropping them. It cancels pending drops of disks dropped using the DROP DISKGROUP command. ASM disks can never be undropped as a result of a DROP DISKGROUP. Disks must be rebalanced manually after successfully undropping them.

Which three events occur when a node fails in an Oracle Clusterware 19c Cluster?. Sessions connected to the failed node could be relocated to one or more surviving nodes. The node is evicted from the cluster. Cluster resources running on the failed node must be recovered when the node is restarted. Cluster Resources running on the failed node are relocated to one or more surviving hub nodes. Cluster Resources running on the failed node are suspended until the node is restarted.

Examine this command executed an the first node of a four-node cluster: $ DATABASE_ORACLE_HOME> /OPatch/opatch apply 33575673 What does this command do?. It applies a patch to all database ORACLE_HOME with the same release only on the first cluster. It applies a patch to one database ORACLE_HOME on all cluster nodes. It applies a patch to one ORACLE_HOME only on the first cluster node. It applies a patch to all ORACLE_HOME with the same release only on the first cluster node. It applies a patch to all database ORACLE_HOME with the same release on all cluster nodes.

Which three are benefits of using RAC databases with multiple instances?. automatic workload management for services on local connections. surviving node failures. surviving interconnect failures. parallel execution across all instances supporting a balanced policy-managed service. automatic workload management for services on oracle Net connections. parallel execution across all instances supporting a singleton policy managed service. surviving storage network failures.

Which three statements are true about ASM Cloud File System (ACFS) encryption?. Acfsutil encr init this is used to establish role separation between encryptionmanagers and encryption auditors,. Acfsutil encr off can be run by an encryption manager who may not have system administrator privileges. An ACFS snapshot can be ACFS encrypted. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory. Acfsutil encr on can be used to specify the encryption key length for a directory or file.

Which three statements are true about undo management in a RAC environment?. A mixture of automatic undo management and manual undo management is supported within a RAC database. It is necessary to assign a specific undo tablespace to a specific instance. You can dynamically assign a newly created undo tablespace to an instance. In a policy-managed RAC database, an undo tablespace may automatically be created if OMF is enabled for the database. An instance that performs instance recovery can write to the undo tablespace of a failed instance.

Which three statements are true about ASM Cloud File System auditing?. acfsutil audit read marks audit files to indicate that it is safe to purge them. acfsutil audit archive must be used to archive audit files that are larger than 10 MB. acfsutil audit purge can be run by an audit manager. Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail. acfsutil audit init must be run by a system administrator.

Which three statements are true about diagnostic reporting for the OCR and OLR files?. The OCRDUMP utility can dump specific keys from the OLR in an online fashion with the clusterware running on all nodes. The OCRCONFIG utility can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes. The OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes. The CLUVFY utility can check the integrity of the OCR but not the OLR. The OCRCHECK utility can check the OLR in an online fashion with the clusterware running on all nodes.

Which two benefits are obtained by using Affinity to reduce global resource contention?. Oracle RAC affininity for partitioned tables routes database request to Oracle RAC instances in such a way that each instance always gets request for a disjoint subset of rows in the database, this affinity leads to higher Oracle RAC performance and scalability because of improved cache locally and reduce internode synchronization and block pings. Oracle RAC affininity for partitioned tables routes database requests to all available Oracle RAC instances evenly to create a global affinity in such a way that each instance always gets an even number of requests leading to higher Oracle RAC performance by using a higher levels of available global cache to reduce global resource contention. To enhance the performance of distributed transactions with applications server that provides XA affinity, you can direct all branches of a distributed transaction to a single Instance in the cluster to improve cache locally and reduce internode synchronization and block pings. Oracle RAC affininity for partitioned tables routes all database requests for a partition tables to a single Oracle RAC instance leading to higher Oracle RAC performance and scalability because of improved cache locally and reduced internode synchronization and block pings of the partition tables. To enhance the performance of distributed transactions with applications server that provides XA affinity, you can automatically spawn new dedicated database RAC instances to isolate distributed transaction.

Which statement describes the purpose of colocation tag for client routing with Oracle database19c?. When possible, clients with the same colocation tag are routed to the same available instance even if a preferred instance is available. When possible, clients with the same colocation tag are routed to the same instance that offers a given service. When possible, clients with the same colocation_tag are routed to the same available instance when a preferred instance is not available. When possible, clients with the same colocation_tag could be routed across a set of preferred instances based on a load-balancing option.

Zero Donwntime Patching uses Fleet Patching and Provisioning to patch Oracle Grid Infrastructure without bringing down Oracle RAC database instances. Which three statements are true about Zero-Downtime Oracle Grid Infrastructure Patching?. Zero Downtime Patching requires out-of-place patching of Oracle Grid Infrastructure 19c with Oracle RAC or Oracle RAC One Node databases of 19c or later release and only the binaries in the Oracle Grid Infrastructure user space are patched. Zero Downtime Patching can be fully automated by selecting the option to automatically run the root.sh script. When using Zero Downtime Patching, Oracle Grid Infrastructure OS System software, kernel modules and systems commands including ACFS, AFD, OLFS and OKA are not updated. Zero Downtime Patching requires in-place patching of Oracle Grid Infrastructure 19c with Oracle RAC or Oracle RAC One Node databases of 19c or later releases and only the binaries in the Oracle Grid Infrastructure user space are patched. When using Zero Downtime Patching, the root.sh script must be executed manually with – nodriveupdate option.

Which two statements are true about Transparent Application Continuity in Oracle RAC 19c?. Recovery of the user database session is done safely and with no need for a DBA to have any knowledge of the application or make application code changes. Recovery of the user database session is done safely by enabling AUTO RECOVER within the user database session. Transparent Application Continuity is enabled when FAILOVER TYPE=AUTO. Transparent Application Continuity is enabled when FAILOVER TYPE=ALL. Transparent Application Continuity is automatically enabled for a session when a database session reaches a safe place (such as a connection test or a known recoverable point) and the transactions are drained at the database.

Examine this command: SQL> CREATE PLUGGABLE DATABASE pdb3 from pdb1; Which three conditions must be true for successful execution of this command on a RAC database?. Oracle Managed Files must be enable or PDB_FILE_NAME_CONVERT must be set. The source PDB must be closed on the CDB instance from where the command is executed. It can be executed only by a common user with the CREATE PLUGGABLE DATABASE system privilege connected to the root container. The source PDB must use a global temporary tablespace. All running CDB instances must be open in restricted mode. The source PDB must be in READ ONLY mode on all CDB instances if the CDB is in No Archive.

You have set ACCESS_CONTROL_ENABLE to TRUE for a newly created disk group in a UNIX system. Which two statements are required to enable Access Control List for this disk group?. An ASM password file must use a separate password file. The ACCESS_CONTROL.UMASK attribute must be explicitly set. The OSASM, OSDBA for ASM and OSDBA database groups must be created as separate operating system groups. The OSDBA group must be different for each database using the same ASM diskgroup to achive complete separation of duties.

You are installing Oracle Grid Infrastructure 19c and configuring a Cluster. Which two elements are required to support this configuration?. A Grid Management Repository database. A network interface for private interconnect only. A Grid Management Cluster Health Management (CHM) application server. A network interface for the public network. A network interface for ASM and private interconnect traffic.

Which three statement are true concerning activation of a user-defined policy in Oracle 19cClusterware?. When a policy is activated, resources can be automatically stopped to comply with the policy definition. 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 first created, it is initially inactive. When a policy is activated, nodes may be reassigned to server pools based on the policy definition.

Which three statements are true regarding ASM on a four-node cluster?. A database instance on a node can be a client of an ASM instance running on any node. A database instance on a node uses an ASM instance as an I/O server when requesting I/O to diskgroups. A database instance on a node can only be a client of an ASM instance running on the same node. An ASM instance and database instances can coexist on the same node. A database instance on a node cannot be a client of an ASM instance running on other nodes. ASM Cluster File System (ACFS) can be deployed on any nodes.

Which three statements are true about fully qualified file names in ASM?. They are the only valid form that can be used for single file creation of control file. An alias may be created for an existing file by referring to the fully qualified file name. They can be used to reference existing ASM files. They are system generated at the time of ASM file creation. They can be created only if OMF is enabled.

Which two statements are true about server categorization in Oracle 19c Clusterware?. Server categories can only be used for nodes running an application server. A server may be added to only one category using the crsctl utility. All server attributes used for categorization are administrator modifiable. All nodes in a cluster belong to the same Oracle-supplied category. All server attributes that may be used to determine the server category are discovered automatically by Oracle Clusterware. Different nodes in a cluster may belong to separate administrator-defined categories.

Which four statements are true concerning the upgrading of Oracle Grid Infrastructure 19c?. The cluster verification utility cluvfy.sh can verify that the cluster is ready for an upgrade. The ORACLE_HOME environment variable must be set to the Grid Infrastructure home directory in the installation owner’s environment. The upgrade must be done in-place. The upgrade must be done out-of-place. The ORACLE_SID environment variable must be set to the SID of the ASM instance in the installation owner’s environment. Upgrade validation may be done using the Oracle Universal Installer which in turn invokes the built-in cluster verification utility. The cluster verification utility cluvfy.sh can generate fixup scripts to run on all nodes of the cluster.

Identify three prerequisites for the successful installation of Oracle Grid Infrastructure 19c when using Full Featured Grid Naming Service (GNS). You must enable the Name Server Cache Daemon (NSCD). A DHCP service on the private network for the cluster is required to allocate virtual IP addresses for HAIP. DNS must be configured to delegate name resolution for the cluster subdomain to the cluster. A DHCP service on the public network for the cluster is required to allocate virtual IP address as required by the cluster. You must create a Grid Management Repository database. Each cluster node must have at least two network interface cards.

Which statement is true concerning the installation of an Oracle Grid Infrastructure 19c patchset and its status during the installation?. When performing rolling patches, the VIPs for the node being patched are relocated to another node. When performing rolling patches “crsctl query css softwareversion” always displays the earliest version of thesoftware running anywhere in the cluster. Some Grid Infrastructure patchsets may not be installed in a rolling fashion. They can be applied in-place.

You administer an Oracle 19c RAC database whose clients connect to the database instances using SCAN listeners. Which two statements are true regarding client-side connect-time load balancing?. You must explicitly set LOAD_BALANCE=ON in the client-side TNS entry being used. Client connection requests are automatically load balanced across the IP address defined for the SCAN listeners. The LOCAL_LISTENER parameter for each instance must be manually set to point to the node listener on each node. SCAN listeners redirect connection requests to a node listener for the appropriate instance. You must add SCAN VIPs to the REMOTE_LISTENER parameter to enable correct listener cross-registration.

Which two statements are true about resources defined by an administrator and registered with Oracle 19c Clusterware for high availability?. An administrator-managed resource can be started manually using crsctl. The action script is automatically set when using a policy-managed resource. An administrator-managed resource can be started manually using srvctl. Resource dependencies are automatically set when using a policy-managed resource. A policy-managed resource can be started manually using srvctl. A policy-managed resource can be started manually using crsctl.

Which two statements are true about High Availability NFS (HANFS)?. HANFS does not depends on NFS services provided by the underlying operating system. HANFS performance depends on the characteristics of the underlying ASM disks. NFS client requests are distributed by DNS in a round-robin fashion to the cluster nodes that export the NFS filesystem. HANFS provides high availability in case of cluster node failure.

Your Four-Node cluster runs Oracle 19c Clusterware and support a mix of RAC database 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?. Use srvctl stop vip to stop the VIP on host01. Use oifcfg setif to start the VIP on host01. Use srvctl start vip 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.

Which three file types can be stored in an ASM Cluster file system (ACFS) and used by the relevant software?. Grid Infrastructure executables. Data files for tablespaces. Oracle database executables. Oracle Cluster Registry (OCR) files. Voting Disks. Archive logs.

Which two statements are true regarding ASM when installing Oracle Grid Infrastructure 19C?. The Installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance. If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node. ASM disk groups used for voting files and OCR files require a quorum failgroup. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster. The Installer permits the creation of a disk group for use by the voting disks and OCR file.

Examine this command and output: [root@host01 ~]# / sbin/acfsutil snap create snap001 /u0l/app/grid/acfsmount/ acfsutil snap create: Snapshot operation is complete. Examine this command: [root@host01 ~]# / sbin/acfsutil snap create -p snap001 Snap002 /u01/app/grid/acfsmount/ Which statement must be true for the successful execution of the second command?. The parent snapshot must be read/write. The parent snapshot must be read-only. The underlying ADVM volume must be configured with high redundancy. The disk group compatibility attribute for ADVM must be set to 12.1 or higher.

Which two operating system users and groups must be created on each node before installing Oracle Grid Infrastructure 19c?. an O/S user to own the Oracle Database installation. an O/S group to own the software inventory. an O/S user to own the Grid Infrastructure installation. an O/S user to own the Clusterware installation and a different O/S user to own the Automatic Storage Management (ASM) installation. A group to own Automatic Storage Management (ASM) Filter Driver-provisioned storage. an O/S group called dba.

Which three statements are true about the Global Resource Directory (GRD) in Oracle 19: RAC database and in Clustered ASM?. RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance. Only one GRD shadow resource may exist for an Enqueue Resource. Shadow GRD resources may exist in more than one database instance for a resource. Clustered ASM has GRD resources distributed among all ASM instances. All GRD Enqueue Resource master metadata is held in the shared pool of the same database instance. All GRD Enqueue Resource master metadata is held in the large pool of the same database instance. RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.

You performed these steps to disable an ADVM volume containing an ACFS file system: 1. Dismount the file system. 2. Disable the volume with the ASMCMD voldisable command. Which two statements aretrue regarding the actions performed?. The ACFS file system will be permanently removed from the volume. The disabling of volume does not destroy data in the file system. The ACFS file system will be permanently removed from the volume only if the file system is empty. The volume can be enabled and the file system can be mounted back again to access the existing data. The ACFS mount registry with Oracle restart is automatically deleted.

Which two components must always be defined or specified by an administrator to make an application highly available using Oracle 19 Clusterware. an application resource. a script agent. an application VIP. a resource dependency definition. A Server Pool.

Which two statements are true about initialization parameters for Clustered ASM instances?. The maximum value of a ASM_POWER_LIMIT is 1024. A change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect. The ASM_DISKGROUP parameter is optional. The default value of INSTANCE_TYPE is ASM. ASM_POWER_LIMIT controls the number of RDBMS instances that can access a disk group while it is being rebalanced.

Which two statements are true regarding ASM Dynamic Volume Manager (ADVM)?. To create an ADVM volume, disk group attributes COMPATIBLE.ADVM and COMPATIBLE.ADVM must be minimally set to 12.1. File systems contained in ADVM volumes may only contain database files. An ADVM volume is individually named and can contain only one file system. Only one ADVM volume can be created in an ASM disk group. ADVM extends ASM by providing a device driver interface to storage backed by an ASM disk group.

Examine this command SQL>ALTER TABLESPACE TBS1 ADD DATAFILE ‘+DATA(newtemplate)/ORCL/USERS/mytab.dbf’ SIZE 100M; Which two statements are required for this command to succeed?. The DB_CREATE_FILE_DEST parameter must be set to +DATA (newtemplate). Existing data files in TBS1 must also use the same template. new template must be defined for the +DATA disk group. The +DATA disk group should not be part of Flex ASM. User-defined subdirectories ORCL and USERS must already exist.

Examine this command SQL> CREATE DISKGROUP RECO HIGH REDUNDANCY Which three statements are true about this disk group?. Files created in it have three copies for each allocation unit. Files created using a template with the REDUNDANCY attribute set to HIGH will have three-way mirroring. Files created using a template with the redundancy attribute set to MIRROR will have three-way mirroring. The RECO diskgroup may only be used for the FRA. The COMPATIBLE attribute values of the disk group can be changed to lower values. Any database instance with the COMPATIBLE parameter 10.1 and later can use it.

Which three statements are true concerning Automatic Database Diagnostic Monitor (ADDM) for RAC?. It can analyze performance over any given time period. It can analyze performance using data captured on all instances. It can only analyze performance on the instance running the ADDM job. It runs automatically in Instance ADDM mode after each AWR snapshot is created. It can diagnose skew in response time. It can diagnose latency problems in the Cluster Interconnect.

A directory +DATA/ORCL/DATAFILE/USERS exists in ASM. USERS is a user created directory; ORCL and DATAFILE are system generated directories. Which two statements are true about user-created directories?. You cannot create a user-defined directory at the root (+) level. You can create subdirectories under the USERS directory. You cannot rename a user-created subdirectory. You cannot drop a directory containing aliases unless you delete the aliases first. You can create a nested subdirectory /USER1/2014 under USERS with a single CREATE DIRECTORY Command even if directory USER1 does not exist.

Which performance characteristic must be considered for ASM disks or ASM diskgroups?. Database instances perform full table scans faster if the tables are stored in tablespaces that reside in external redundancy disk groups. For optimal rebalance speed, all asm disks in a disk group must be on the same controller. For optimal rebalance speed, all ASM disks in a disk group must be of the same size. Database instances perform full table scans faster if the tables are stored in tablespaces that reside in high redundancy disk groups.

Which two steps must always be performed to delete node host04 from an Oracle 19c Clusterware cluster that does not use Grid Naming Service (GNS)?. Run the rootcrs.pl -deconfig-force command as root on host01, or on either host02 or host03. Run the crsctl delete node -n host04 command, as root on host01, or on eitherhost02 or host03. Run the rootcrs.pl -deconfig-force command as root on host04. Run the crsctl unpin css - host04 command as root on host04. Run the crsctl delete node -n host04 command as root on host04. Run the crsctl unpin css - host04 command as root on host01, or on either host02 or host03.

Which three statement are true about the administration and use of policy sets in Oracle 19c Clusterware. A server pool can have different attributes defined for different policies in the policy set, when user-defined policy management is used. All server pools in a cluster are controlled by the policy set, when user-defined policy management is used. A server pool can have the same attributes defined for different policies in the policy set, when user- defined policy management is used. Servers in a server pool outside the control of the policy set are never affected by policy changes, when user-defined policy management is used. Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS) Management is used.

Examine the output of the asmcmd and srvctl commands: You execute this command: srvctl modity asm -count 2 All databases on the cluster are running from Oracle 12c homes. Which statement is true about the outcome of this command?. The command fails because one ASM instance must be shut down manually before executing the command. The command fails because the instance count cannot be reduced to less than the minimum value of 3. ASM instances continue running on all three nodes until all database instances connected to one of the ASM instances shut down. One ASM instance is shut down and the instance count is reduced by one.

You administer a three-instance, policy-managed, multitenant RAC database CDB1 with three PDBs PDB_1,PDB_2 and PDB_3. You want to drop PDB_3 Which two statements are true?. CDB1 must be open in restricted mode on all cluster nodes. PDB_3 must be open READ ONLY in all CDB1 instances. Manually created services for PDB_3 are removed automatically from the OCR when dropping PDB_3. PDB_3 must be closed on all CDB1 instances. Manually created services for PDB_3 are not removed automatically from the OCR when dropping PDB_3.

For which three entities can the "what-if" command evaluation be used to determine the impact of clusterware management operations in Oracle 19c Clusterware?. Local resources. Administrator-defined resources. Database transactions. Cluster resources. Pluggable Databases (PDBs).

Which three statements are true about Quality-of-Service Management (QoS)?. It supports RAC One Node databases if they are assigned to with a maximum size of one server. The command-line utility gosctl can be used to change the password of the internal user QOSADMIN. A server pool directive override can be used to modify the databaseparameter CPU_COUNT for all databases within one server pool. One QoS policy can span multiple clusters if they contain server pools, assigned to be managed by QoS. It requires a resource manager plan to be active on databases managed by QoS.

You must deploy several oracle 19c databases on an Oracle Grid Infrastructure Managed Cluster, and are required to have the ability to perform these actions without down time: 1. Apply a Grid Infrastructure interim patch. 2. Apply a Grid Infrastructure Patch Set Update (PSU). 3. Apply a database on-line patch 4. Apply a Grid Infrastructure patchset. 5. Apply a database patchset. 6. Upgrade Grid Infrastructure from one release to another. 7. Upgrade databases from one release to another. Your plan is to perform these tasks: 1. Install and configure Oracle Grid Infrastructure on a local file system. 2. Install Oracle Database software on an ACFS file system. 3. Create several RAC One Node databases. Which of the seven requirements are met by your plan?. 2, 3, 4 and 6. 3, 4 and 6. 1, 2, 3 and 4. 3, 4, 5 and 6. 1, 2, 3, 4, 5, 6 and 7. 1, 2, 3, 4 and 6.

Which two statements are true about Instance Locks in Oracle 19c RAC?. They are used to coordinate access across multiple library caches for anonymous PL/SQL execution. They are used to coordinate access across multiple library caches for the same stored procedure. They are used to coordinate the next value for a sequence created with the CACHE and ORDER clauses. The are used to coordinate the next value for a sequence created with the NOCACHE and NOORDER clauses. They are used when an application uses the DBMS_LOCK package for UL Lock types.

Which two commands will stop the Oracle High Availability Services (OHAS) and prevent it from starting automatically at system boot on the local node?. crsctl disable crs. crsctl stop crs. crsctl stop cluster. crsctl config crs.

Which method should be used to convert a single-instance Oracle 19c Database to a RAC Database?. Using DBCA to migrate the database to shared storage and then to start one or more RAC database instances on the cluster. Using DBCA to create a template from the single-instance database and then to create a RAC database on the cluster using that template. Using the rconfig utility to create a template from the single-instance database and then using DBCA to create a RAC database on the cluster using that template. Using the rconfig utility to migrate the database to shared storage and then using DBCA to start one or more RAC database instances on the cluster.

Which two statements are true concerning buffer states as shown in GV$BH.STATUS in Oracle 19c RAC?. A P1 block image may exist for a specific database block in only one instance. A CR image may get served from one instance to another to satisfy a read request. An XCUR image is not shipped to another instance until commits occur for updated rows on the block. An XCUR block image may exist for a specific database block in only one instance. An XCUR image is not downgraded to a SCUR image for shipping to another instance until commits occur for updated rows on the block.

Which three statements are true about Oracle 19c multitenant RAC databases created using the Database Configuration Assistant (DBCA) on a cluster from a RAC database home?. They can be administrator managed. They have a unique service name created for each pluggable database (PDB) automatically registered as a cluster service resource. They can be policy managed. They are automatically configured to use Enterprise Manager Express. They can have multiple pluggable databases (PDB) when the container database (CDB) is created. They have their pluggable databases (PDB) opened in each container database (CDB) instance automatically after CDB creation.

Which three statements are true about the Oracle Clusterware 19c Flex Cluster architecture?. Each leaf node must be connected to storage shared across all cluster nodes. Each hub node must be connected to storage shared across all hubnodes. Hub nodes require direct access to the OCR file. Leaf nodes require direct access to the voting disks. Hub nodes require direct access to the voting disks. Each leaf node must be connected to storage shared across all leaf nodes.

Which statement is true using OPatch to patch Oracle Grid Infrastructure 19c?. Opatch can patch all cluster nodes simultaneously (meaning to patch all the nodes at the same time and in parallel) without stopping the clusterware on all nodes. All Grid Infrastructure patches may be applied in a rolling fashion with Opatch. Applying patches with Opatch must be done in an out-of-place fashion. Opatch can patch all cluster nodes simultaneously (meaning to patch all the nodes at the same time and in parallel) only for nonrolling patches without stopping the cluster on any node.

You must replace a failed disk that was dropped from a disk group. You want the rebalance operation to occur with minimal performance impact. Which two options help you achieve this?. Increase the value of the DISK_REPAIR_TIME attribute for the disk group. Make sure that the ASM_POWER_LIMIT parameter is set to 1 before rebalancing the disk group. Set the POWER clause to 1 in the ALTER DISKGROUP Command. Decrease the value of the DISK_REPAIR_TIME attribute for the disk group. Use the WAIT clause with the ALTER DISKGROUP command.

Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 19c Clusterware?. Use the crsctl set log res " resource_name=debugging_level2" command. Set the environment variable _USR_ORA_DEBUNG=1 and then stop and restart the resource that requires resource debugging data to be collected. Use the crsctl set trace res “resource_name=debugging_level" command. Use the cluvfy comp command for the specific resource within a component.

Which three statements are true about Oracle 19c RAC Database software installations?. The RAC Database 12c software home and Grid Infrastructure homes must be owned by separate OS users. The RAC Database 12c software home and Grid Infrastructure homes must be owned by the same OS user. The Cluster Verification Utility (CLUVFY) may be used to check the cluster after installing the RAC database software. It is possible to install RAC database software on a one-node cluster. It is possible to install multiple RAC Database 12c software homes on the same cluster. The Cluster Verification Utility (CLUVFY) must be used to check the cluster before installing the RAC database software.

Identify two placeholder wait events that can be observed while a session is waiting to access a block. gc current request. gc current grant busy. gc cr grant busy. gc current block busy. gc cr request. gc cr block busy.

Which three statements are true about displaying the location of voting files, OCR files, or OLR files in Oracle Clusterware 19c on a UNIX system?. Use crsctl query css votedisk to view the location of voting files if stored in a file system. Use ocrcheck command to view the location of the OCR only if stored in a file system. Use cat /etc/oracle/olr.loc to view the location of the OCR and OLR if stored on a file system. Use crsctl query css votedisk to view the location of voting files if stored in ASM. Use the ls command in the asmcmd utility to view the location of voting files if stored in ASM. Use cat /etc/oracle/ocr.loc to view the location of the OCR if stored in ASM.

Which two statements are true regarding the default service that is automatically created upon on creation in a RAC database environment?. It cannot be used to automate the opening of the PDB by the Clusterware. It is not automatically registered in the OCR. It is created and started on only one instance when using policy-managed database configuration. It is uniformly available on all instances for administrator-managed databases. It is automatically registered in the OCR.

Which two statements are true concerning Oracle 19c Clusterware-managed application VIPs?. 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. Application VIPS do not fail over to surviving cluster nodes when the node hosting the VIP fails. An application VIP can be created with the crsctl utility. If an application sends messages to be displayed and sets the DISPLAY variable, then an application VIP is required.

Which statement describes the usage of Dynamic Service Fallback in Oracle RAC 19c?. 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 the available instance performance falls below a specified threshold after it was failedover to an available instance. 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. Dynamic Service Fallback allows a service to relocate to an available instance when the service is stopped on a preferred instance.

Examine the output of this command: ASMCMD> volinfo -G ACFS -a Diskgroup Name: ACFS Volume Name: VOL1 Volume Device: /dev/asm/vol1-280 State: ENABLED Size (MB): 248 Resize Unit (MB): 32 Redundancy: MIRROR Stripe Columns: 4 Stripe Width (K): 128 Usage: ACFS Mountpath: /u01/app/grid/acfsmount The ACFS disk group is a normal redundancy disk group with 5 GB of free space. To increase the size of the ACFS file system, you execute this command as the root user: $ /sbin/acfsutil size +200M /u01/app/grid/acfsmount Which two statements are true regarding the outcome of this command?. It succeeds but leaves the file system unmounted. It resizes the filesystem mounted on /u01/app/grid/acfsmount. It fails to resize VOL1 because it must be executed as a user belonging to the SYSASM group. It fails to resize the filesystem because it must be unmounted before resizing. It resizes VOL1.

Which three statements are true concerning node evictions and reboots performed by Oracle Clusterware 19c?. The CSSDMONITOR process can request a node eviction. The OCLSKD process is used for node eviction requests originating on the node to be evicted. The OCSSD process may evict a node after an escalation request from a database instance LMON process. All node evictions require that the evicted node or nodes be rebooted. The reboot advisory broadcasts reboot decisions only over the interconnect. A node whose performance is severely degraded can be evicted.

Which three components are integral parts of High Availability NFS (HANFS)?. Application VIP. HAVIP. NFS. DHCP. ExportFS. HAIP.

Examine this tnsnames entry from a RAC configuration using a SCAN listener: HR= (DESCRIPTION=(LOAD_BALANCE=ON) (ADDRESS=(PROTOCOL=TCP) (HOST=cluster01-scan)(PORT=1521)) (CONNECT_DATA=(SERVICE_NAME=HRSRV))). Which two statements are true about clients using this entry to connect?. A client connection request is received by a SCAN listener that creates the connection to the least-loaded database instance. Clients using EZconnect/ can benefit from connect time load balancing because the tnsnames entry refers to a SCAN listener. Client connection requests are automatically failed over to another SCAN listener if the chosen SCAN listener is not available. Client connection requests are automatically balanced across all IP addresses defined for the SCAN. The host name in the tnsnames entry must be changed if nodes are added or removed from the cluster.

In which situation should you configure ASM Access Control Lists?. Enable intelligent data placement for newly created files. To enable intelligent data placement for existing files. To restrict file access to specific cluster nodes in a Flex Cluster. To restrict access to one or more ASM files to specific database instances.

Which three statements are true about Quality of Service Management (QoS)?. It supports multiple databases assigned to the same server pool. It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running. A server pool can be managed by QoS even if it does have database instances running on any server in the pool. It can manage database services only if they are defined as UNIFORM services. Databases managed by QoS can be administrator managed or policy managed.

Identify two reasons for the current block busy wait event. A block is busy in the local cache. A block is busy in the remote cache. The Cluster Interconnect is congested. Either the local or the remote CPUs have too large a run queue.

You administer a three-instance, policy-managed, multitenant RAC database CDB1 with two PDBs:PDB_1 and PDB_2. Examine these commands executed on host01: $srvctl add service -db CDB1 -pdb PDB_1 -service CRM -serverpool prod_pool -cardinality singleton $srvctl start service -db CDB1 -service CRM $srvctl stop service -db CDB1 -service CRM Which three statements are true?. The CRM service is not available for new logins on any instance of CDB1. CRM is only available for new logins on the CDB1 instance on host01. The srvctl start service command automatically opens PDB_1 if not already opened. The srvctl stop service command does not close PDB_ 1 on any instance of CDB1. CRM is available for new logins on one CDB1 instance.

Which three resources are managed using global concurrency control in an Oracle 19c RAC multi-instance database?. Latches. Mutexes. Database block buffers. Redo log buffers. Cursors. Enqueues.

Which three statements are true about Oracle ASM?. Only the maximum of three ASM instances are supported in a cluster. ASM clients can fail over to other ASM instances. An ASM instance must run on every node of a cluster. A designated network is used for communication between ASM instances and their clients. The SPFILE and password file for ASM are stored by default in an ASM disk group. It always requires a cluster to be installed and configured.

Which two statements are true about ASM alias names?. ASM files created using an alias name are not OMF files even if OMF is enabled. ASM files created using an alias name are OMF files even if OMF is not enabled. Alias names can be stored only in user-defined directories. Alias file names cannot be used together with templates when creating tablespaces. ASM files created using an alias name also have a fully qualified name and can be accessed by either name.

Which two statements are true concerning ASM diskgroups using disks with a 4k sector size?. Their COMPATIBLE.ASM attributes must be set to 11.2 or higher. Their COMPATIBLE.ASM attributes must be set to 12.1 or higher. Their COMPATIBLE.RDBMS attributes must be set to 11.2 or higher. Performance of ACFS is improved by using these diskgroups. Their sector size attributes can be changed using the ALTER DISKGROUP command.

Which two types of IP addresses does Oracle Clusterware 19c acquire from DHCP when it is started up on a cluster node using Grid Naming Service (GNS)?. ASM Listener VIPs. Grid Naming Service (GNS) VIPs. Intelligent Platform Management Interface (IPMI) IP addresses. Single Client Access Name (SCAN) Virtual IP addresses (VIPs). Highly Available IP (HAIP) addresses used for the cluster interconnect.

Which three statements are true about ASM Cloud File System (ACFS) replication?. Replication is automatically terminated if the primary file system has less than 2 GB free space. ACFS auditing information is replicated from the primary file system to the standby file system. The privilege SYSREPL has been introduced for ACFS replication. Standby redo log files are required on the standby site for synchronous redo transport. One site of an ACFS replication configuration can host both primary and standby file systems.

Secure Cluster Communication protects the cluster interconnect from common security threats when used together with Single Network Support. Secure Cluster Communication includes message digest mechanisms, protection against fuzzing, and uses Transport Layer Security (TLS) to provide privacy and data integrity between the cluster members. Which statement is true about securing cluster interconnect communication?. Security for the cluster interconnect is invoked by auto-generated server certificates that will be assigned to each cluster node as part of a new Oracle Grid Infrastructure19c deployment or an upgrade to Oracle Grid Infrastructure 19c. Database administrators or cluster administrators must provide a valid server certificate and an Oracle Wallet for each node during new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c to secure the interconnect communication. Database administrators or cluster administrators must provide an encryption key during new Oracle Grid Infrastructure 19c deployment or an upgrade to OracleGrid Infrastructure 19c to secure the interconnect communication. Security for the cluster interconnect is invoked automatically as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c and Database administrators or cluster administrators do not need to make any configuration changes for this feature. Security for the cluster interconnect is invoked automatically as part of a new Oracle Grid Infrastructure 19c deployment or an upgrade to Oracle Grid Infrastructure 19c using an auto- generated encryption key that is stored locally on each node of the cluster in an Oracle Wallet and Database administrators or cluster administrators must provide a valid path for the Wallet file.

Which two statements are true about v$asm_* views in a clustered environment. They exist in both ASM and RDBMS instances and display the same output. Their names can be seen in dictionary when connected to an ASM instance. They exist in both ASM and RDBMS instances, but they can display different outputs depending on the instance type. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster. Their names can be seen in v$fixed_table when connected to an instance of any type that is started.

You plan to use DBCA to convert a single-instance Oracle 19c database on a local filesystem on a stand-alone server to RAC by using ASM. You installed Grid Infrastructure 19c on a four-node cluster. Examine this list of possible conversion steps: 1. Create a template and image files from the single-instance database by using DBCA. 2. Perform an RMAN backup of the single-instance database. 3. Validate the cluster using CLUVFY. 4. Copy the template and image files to a cluster node. 5. Restore the RMAN backup to the recovery area disk group on the cluster. 6. Perform an Oracle Database 19c RAC installation. 7. Create a RAC database with DBCA using the RMAN backup. 8. Create a RAC database with DBCA using the template. Which statement correctly lists the minimum steps required to perform the conversion?. 1, 4, 8. 2, 3, 5, 7. 1, 3, 4, 6, 8. 2, 5, 7. 1, 4, 6, 8. 2, 5, 6, 7.

Which two statements are true concerning diagnostic components and requirements of Oracle 19c Clusterware?. The clusterware log files are stored inside the Grid Infrastructure Management Repository database used by the cluster health monitor (CHM). There is one ologgerd service for the cluster health monitor (CHM) on each clusternode regardless of cluster size. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster size. The diagcollection.pl script must be run from the Grid home directory as the grid infrastructure owner. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.

Which three statements are true regarding multitenant architecture for RAC databases?. It requires the CDB to use shared UNDO management. One UNDO tablespace for each instance is required. You can open one, several, or all PDBs on one, several, or all CDB instances. One UNDO tablespace for each PDB is required. PDBs must use shared Temporary tablespace. PDBs can have local temporary tablespaces.

Examine this output: The ACFS disk group has 10 GB free space and the file system is currently mounted. You execute this command to increase the volume size: ASMCMD> volresize -G ACFS -s 3G VOL1 Which statement is true regarding the outcome?. It succeeds but the file system is automatically unmounted. It fails because resizing a volume containing an ACFS file system must be performed using ACFSUTIL. It fails because the -f option is not specified. It succeeds. It fails because the file system must be unmounted before resizing.

Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC?. The Clusterware stack must be up on all cluster nodes where the Database software will be installed. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes. SSH user equivalence for the Oracle software owner must be configured on all cluster nodes where the Database software will be installed. Grid Infrastructure must be installed on all cluster nodes where the Database software will be installed. The Clusterware stack must be up on all cluster nodes. Grid Infrastructure must be installed on all cluster nodes.

Which two statements are true about Oracle Clustered ASM performance?. All ASM Disks belonging to a disk group should be of the same size for optimal performance. To improve performance a database must have two disk groups: one for data and one for the fast recovery area. All ASM Disks belonging to a disk group should have the same hardware specifications and storage attributes for optimal performance. Data files, redo logs, and RMAN backup pieces must be stored in different ASM disk groups for optimal performance. Hardware-based mirroring combined with ASM mirroring guarantees optimal performance.

Which statement is true about Oracle Database 19c SGA Management?. Oracle RAC Resource Management requires the same SGA value for all the instances of a RAC database which is configured during database startup only. Oracle RAC Resource Management only allows assignment of the SGA during instance startup. Oracle RAC Resource Management only allows assignment of the SGA during database startup. Oracle RAC Resource Runtime Management allows for automatic and runtime adjustment of the SGA.

Examine the output of the asmcmd and srvctl commands: $ asmcmd showclustermode ASM cluster : Flex mode enabled $ srvctl status asm -detail ASM is running on host01, host03 ASM is enabled. $ srvctl config asm ASM home: /u01/app/12.1.0/grid Password file: +DATA/orapwASM ASM listener: LISTENERASM instance count: 2 Cluster ASM listener: ASMNET1LSNR_ASM Then you execute this command: $ srvctl relocate asm - currentnode host03 -targetnode host02 Which three statements are true regarding the execution of this command based on the output shown?. It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03. It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST01. It fails because an ASM instance is not configured to run on HOST02. It fails because the ASM instance has not been shut down first on HOST03. It succeeds and 19c database instances connected to the ASM instance on HOST03 can be reconnected to the ASM instance on HOST02. It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut down until all connected clients disconnect.

Which two utilities support the "what-if" command evaluation?. asmcmd. oifcfg. srvctl. crsctl. ocrconfig.

Which two statements are true about load balancing using a database service in a RAC environments?. In client-side load balancing, the SCAN listener uses the Load Balancing Advisory to direct a connection request to the least loaded instance hosting the service. Server-side connect time load balancing is done at the time of the initial connection attempt to the database service. Client-side connect time load balancing works only if it uses a tnsnames entry specifying LOAD_BALANCE=yes. Server-side load balancing connections are always distributed across Instances based on the fastest response time for the service. Client-side connect time load balancing is done at the time of the initial connection attempt to the database service.

Which three statements are true regarding ACFS snapshots in Oracle 19c ASM?. They can only be accessed when the file system is mounted. They are always point-in-time copies of the parent file system. You can create a snapshot from an existing snapshot. All ACFS snapshot operations for all filesystems are serialized clusterwide. They can be administered using ASMCMD. They are contained in a directory on the same volume as their parent file system.

Which two statements are true about ASM default templates?. Templates may be shared across disk groups. Default template settings for redundancy depends on the disk group redundancy. Default templates for a disk group can be modified. Default template setting for striping depends on disk group redundancy. Default data file templates are only created by ASM when a normal redundancy disk group is created.

Which three statements are true about services and load balancing for Oracle 19c clients connecting to Oracle 19c RAC database instances?. Load balancing can be done by the client, the listener, or both, for any one connection request. Load balancing can be done by the client or the listener, but not both, for any one connection request. In server-side load balancing, node listener redirects the client to another node listener for connection to an instance. Client-side connect-time load balancing can balance connection requests across SCAN listeners. Services support the balancing of client connections across RAC database instances.

Disk group DGRP1 has these attributes: 1. Normal redundancy 2. Two failure groups FG1 and FG2 with two disks each 3. Compatibility settings set to 19.0 The FG1 failure group goes offline due to hardware failure. Which two statements are true?. The redundancy is lowered until the FG1 failgroup is restored and the disk group resynchronized. New allocation units are mirrored in the FG2 failure group until FG1 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 DGRP1 disk group fail.

Which three are benefits of using RAC One Node in Oracle 19c?. automatic failover for high availability. multiple instances of the same database on a single node to protect against instance failure. online conversion from RAC One Node databases to multi-instance RAC databases. online-conversion from non-RAC databases to RAC One Node databases. load-balancing of services within a single instance. ability to perform rolling patches.

Which three statements are true about accessing ASM files?. Database instances perform read I/O directly to ASM Disks. If a database instance writes to an ASM-based datafile whose redundancy attribute is set to mirror, then the ASM instance writes the mirror copy. Database instances perform read I/O using an ASM instance as an I/O Server. Database instances can write metadata to ASM diskgroups. ASM instances can write metadata to ASM diskgroups.

Which two statements are true concerning the installation of Oracle Grid Infrastructure 19c Cluster?. High Redundancy ASM Disk Groups used for Clusterware files will contain two OCRs. Specifying the use of Grid Naming Service is optional. The Grid Infrastructure Management Repository is only required when using ASM. The Clusterware binaries may be installed without installing ASM binaries. Normal Redundancy ASM Disk Groups used for Clusterware files will contain three voting files regardless of the number of failgroups.

Which two statements are true about the Global Enqueue Service (GES) and Global Enqueue Services Resources in Oracle 19c RAC?. The LMDO process runs only on the instance that masters all GES resources. The foreground process on the requesting instance communicates with the LMDO process on the mastering instance if they are not the same instance. The LMDO process on the requesting instance communicates with the LMDO process on the mastering instance if they are not the same instance. An LMDO process runs on all instances. The mastering instance for a GES resource is never the same as the instance that owns an enqueue in shared mode. The mastering instance for a GES resource is never the same as the instance that owns an enqueue in exclusive mode.

Which three statements are true concerning policy-based cluster management in Oracle 19c Clusterware?. All servers in a new cluster installation belong to the free server pool. Server Pools must be managed with the crsctl utility for servers hosting an application or other administrator-defined high availability resource. Server Pools must be managed with the srvctl utility for servers hosting a database. The server pool contains servers that host administrator-defined high availability resources. All servers in a new cluster installation belong to the generic server pool.

Examine this command CREATE PLUGGABLE DATABASE pdb3 FROM pdb1; Which three conditions must be true for successful execution of this command on a RAC database? (Choose three.). The source PDB must be in READONLY mode on all CDB instances. All running CDB instances must be open in restricted mode. The source PDB must use a global temporary tablespace. The source PDB must be closed on the CDB instance from where the command is executed. Oracle Managed Files must be enabled or PDB_FILE_NAME_CONVERT must be set. It can be executed only by a common user with the CREATE PLUGGABLE DATABASE system privilege connected to the root container.

Which three commands can be used to verify the integrity of Oracle Clusterware 19c OCR and OLR files?. ocrcheck. ocrcheck -config -local. cluvfy comp ocr -n all -verbose. ocrcheck -local. ocrcheck -config.

Which two types of IP address details are administered using the srvctl command for Oracle Clusterware 19c?. Storage Network IP addresses. Public IP addresses. Single Client Access Name (SCAN) VIPS. High Available VIP (HAIP) addresses. The Grid Naming Service (GNS) VIP.

Examine this command executed on the first node of a three-node cluster: # <GRID_INFRASTRUCTURE_ORACLE_HOME>/OPatch/opatchauto apply 18139660 Which two tasks does this command perform?. It applies a patch to all database ORACLE_HOMEs of any version on all cluster nodes. It applies a patch to the Grid Infrastructure on all cluster nodes. It applies a patch to all database ORACLE_HOMEs, with the same release as the Grid Infrastructure, only on the first cluster node. It applies a patch to all database ORACLE_HOMEs, with the same release as the Grid Infrastructure, on all cluster nodes. It applies a patch to the Grid Infrastructure only on the first cluster node. It applies a patch to all database ORACLE_HOMEs of any version on the first cluster node.

A clustered ASM Instance has the DATA diskgroup mounted. Which two can be used to display information about databases accessing files in the DATA diskgroup?. v$process. v$asm_client. v$session. asmcmd lsct. asmcmd lsdg.

Which two utilities can be used to predict the consequences of a filesystem failure for the Oracle 12c Clusterware stack?. acfsutil. asmca. advmutil. asmcmd. crsctl fail ... srvctl predict...

Which three statements are true about the services created when the DBCA is used to create a RAC database?. Policy-managed services specified for a database allow the creation of a new server pool using DBCA. Singleton services are not permitted for multitenant databases. They can be policy managed for a multitenant database. A server-pool must be created with SRVCTL before creating a policy-managed RAC database that uses that server-pool for a service. They can be administrator managed for a multitenant database.

You just added an ASM disk to the DATA diskgroup. Which two can be used to monitor the rebalancing?. v$asm_disk. v$session_longops. asmcmd lsop. v$asm_diskgroup. v$asm_operation. amscmd Isdg.

You administer a six-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1, PDB_2 and PDB_3. Server pool prod_pool has a cardinality of three and all six hosts of the cluster app. Examine these commands executed on HOST01: $ srvctl add service db CDB1 pdb PDB_1 service AR serverpool prod_pool cardinality singleton $ srvctl start service db CDB1 service AR Which two statements are true regarding the AR service?. AR can fail over to any other available CDB1 instance in prod_pool. AR is available on any one available CDB1 instance in prod_pool at any one time. AR runs as a singleton service in the server pool prod_pool and the AR service is available in each of the CDB1 instances. AR is available only on the CDB1 instance on HOST01. AR can fail over to any one of the available CDB1 instances.

Which two statements are true about the Global Enqueue Service, Instance Locks, and global enqueues in Oracle 19c RAC?. Global Enqueues and Instance Locks replace mutexes completely in RAC database instances. Global Enqueues may have owners and waiters in the same instance. In a RAC database, there is no LMD0 process if only one instance is running. Global Enqueues may have converters and waiters in the same instance. Global Enqueues and Instance Locks replace latches completely in RAC database instances. In a RAC One Node database, there is no LMD0 process if only one instance is running.

Examine this command executed in a Clustered ASM environment: SQL>DROP DISKGROUP DATA1 FORCE; Which statement is true?. DATA1 is dropped whether or not it is mounted by any instance. The ASM instance executing the command must have DATA1 mounted for this command to succeed. DATA1 is not dropped if uncommitted transactions exist that have updated objects in any tablespace stored in DATA1. DATA1 must not be mounted by any ASM instance for this command to succeed.

Which two statements are true about clustered ASM instances?. The ASM passwordfile can be stored in a diskgroup that is accessible to all ASM instances. An ASM instance must store its SPFILE in ASM. The SPFILE must be stored in a diskgroup that is accessible to all ASM instances. The SPFILE must be stored in $GRID_HOME/dbs on local storage of a cluster node. The ASM passwordfile can be stored in $GRID_HOME/dbs on local storage of a cluster node.

A cluster running 19c Grid Infrastructure supports both Oracle 11g to 19c RAC databases using ASM. The COMPATIBLE. ASM, COMPATIBLE. RDBMS, and COMPATIBLE. ADVM parameters are currently set to 11.2 for all diskgroups. You must support these capabilities in all diskgroups: 1. ACFS Replication 2. ACFS Encryption To what minimum values must the compatible attributes be set?. Set COMPATIBLE. ASM to 11.2, COMPATIBLE. RDBMS to 12.1, and COMPATIBLE.ADVM to 11.2. Set COMPATIBLE. ASM to 12.1, COMPATIBLE.RDBMS to 11.2, and COMPATIBLE.ADVM to 12.1. Set COMPATIBLE. ASM to 12.1, COMPATIBLE. RDBMS to 12.1, and COMPATIBLE. ADVM to 12.1. Set COMPATIBLE. ASM to 11.2, COMPATIBLE.RDBMS to 12.1, and COMPATIBLE.ADVM to 12.1. Set COMPATIBLE. ASM to 11.2, COMPATIBLE. RDBMS to 11.2, and COMPATIBLE.ADVM to 11.2.

Which three statements are true about Global Resource Management in an Oracle 19c RAC database?. Lazy remastering occurs when an instance shuts with SHUTDOWN TRANSACTIONAL. When a database instance fails, then some global resource masters lost from the failing instance are remastered among the surviving instances. Object remastering causes all blocks in any instances buffer cache from the same object to be mastered in the Global Resource Directory (GRD). Global Enqueue resources are recovered from Global Cache Resources after an instance failure. Lazy remastering occurs when an instance shuts with SHUTDOWN IMMEDIATE.

A Java application using thick JDBC connections will soon be deployed, and you must configure a database to support highly available connections. Broken connections must be re-established as quickly as possible. Which feature will support this requirement?. Fast Connection Failover (FCF) with Transparent Application Failover (TAF). Transparent Application Failover (TAF). Fast Connection Failover (FCF). Transparent Application Failover (TAF) using Fast Application Notification FAS.

You want to create a tablespace, SALES, with these requirements: 1. Its data file has an alias name sales.dbf. 2. Its data file is stored in the directory CURRENT_YR in the disk group DATA. Examine this command: SQL> CREATE TABLESPACE sales; Which two tasks must you perform to meet these requirements?. Add the AUTOEXTEND ON clause to the command. Create the CURRENT_YR directory in the +DATA disk group. Create the CURRENT_YR directory in the root directory (+). Add the DATAFILE /CURRENT_YR/sales.dbf' clause to the command. Add the DATAFILE ‘+DATA/CURRENT_YR/sales.dbf' clause to the command.