QUESTION 1Which three statements are true regarding Flex ASM on a four-node cluster consisting of three-hub nodes and a leaf node?

A. An ASM instance and database instances can coexist on the same hub node.B. A database instance on a hub node can be a client of an ASM instance running on any leaf node.C. A database instance on a hub node can be a client of an ASM instance running on any hub node.D. A database instance on a leaf node can be a client of an ASM instance running on any hub node.E. A database instance on a hub node uses an ASM instance as an I/O server when requesting I/O todiskgroups.F. ASM Cluster File System (ASFS) can only be deployed on hub nodes.

Answer: ACFExplanation:Architecturally Oracle Flex Cluster comprises of a Hub and Leaf architecture where in only the Hub nodes will only have direct access to Oracle Cluster Registry (OCR) and Voting Disk (VD). However application can access the database via Leaf nodes without ASM instance NOT running on Leaf nodes. The connection to the database is through Hub making it transparent for the application.Note:Hub Nodes are connected among them via private network and have direct access to the shared storage just like previous versions. These nodes are the ones that access the Oracle Cluster Registry (OCR) and Voting Disk (VD) directly.Leaf Nodes are lighter and are not connected among them, neither accesses the shared storage like the Hub Nodes. Each Leaf Node communicates with the Hub Node that is attached to, and it is connected to the cluster via the Hub Node that is linked to.http://www.oracle.com/technetwork/articles/database/flexasm-flexcluster-benefits-odb12c-2177371.html

QUESTION 2Which two statements are true about initialization parameters for Clustered ASM instances?

A. A change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect.B. ASM_POWER_LIMIT controls he number of RDBMS instances that can access a disk group while it isbeing rebalanced.C. The ASM_DISKGROUP parameter is optional.D. The default value of INSTANT_TYPE is ASM.E. The maximum value of ASM_POWER_LIMIT is 1024.

Answer: CEExplanation:C: The default value of the ASM_DISKGROUPS parameter is a NULL string. If the parameter value is NULL or is not specified, then ASM does not mount any disk groups.E: The ASM_POWER_LIMIT initialization parameter specifies the default power for disk rebalancing in a disk group. The range of values is 0 to 1024.Incorrect Answers:B: The ASM_POWER_LIMIT initialization parameter specifies the default power for disk rebalancing in a disk group. The range of values is 0 to 1024.D: The default value of INSTANT_TYPE is RDBMS.https://docs.oracle.com/cd/E11882_01/server.112/e18951/asminst.htm#BHCEHJGA

A. There is one ologgered service for the cluster health monitor (CHM) on each cluster node regardless ofcluster size.B. The Grid Infrastructure Management Repository database must run on a hub node if Flex Clusters areused.C. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless ofcluster size.D. The oclumon utility may be used to get and set parameters for the cluster health monitor (CHM) repository.E. The diagcollection.pl script must be run from the Grid home directory as the Grid infrastructure owner.F. The clusterware log files are stored inside the Grid Infrastructure Management Repository database usedby the cluster health monitor (CHM).

Answer: BCDExplanation:B: The Oracle Grid Infrastructure Management Repository Runs on one node in the cluster.This must be a Hub Node in an Oracle Flex Cluster configuration.C: There is one system monitor service on every node. The system monitor service (osysmond) is a real-time, monitoring and operating system metric collection service that sends the data to the cluster logger service.D: Use the oclumon manage command to view and change configuration information from the system monitor service.Syntax oclumon manage -repos {{changeretentiontime time} | {changerepossize memory_size}} | -get {key1 [key2 …] | alllogger [-details] | mylogger [-details]}Where changerepossize memory_size: Use this option to change the CHM repository space limit to a specified number of MB.Note: The OCLUMON command-line tool is included with CHM and you can use it to query the CHM repository to display node-specific metrics for a specified time period. You can also use OCLUMON to perform miscellaneous administrative tasks, such as changing the debug levels, querying the version of CHM, and changing the metrics database size.Incorrect Answers:E: You can collect CHM data from any node in the cluster by running the Grid_home/bin/diagcollection.pl script on the node.https://docs.oracle.com/database/121/CWADD/troubleshoot.htm#CHDIGCEC

QUESTION 4PROD1, PROD2 and PROD3 are three active instances of the PROD database.Examine these commands executed on PROD1:

A. PARALLEL_MIN_SERVERS will be 200 for all instances of PROD.B. PARALLEL_MIN_SERVERS will be 100 for all instances of PROD.C. The second statement returns an error because this parameter must be identical for all isntances.D. PARALLEL_MIN_SERVERS will be 200 for PROD2 and PROD3 and 100 for PROD1.

Answer: DExplanation:First SET PARALLEL_MIN_SERVERS is set to 200 for all instances, then it is set to 100 for PROD1.

A. The hub node is evicted from the clusterB. Leaf nodes connected to the failing hub node are reconnected to a surviving hub node without servicedisruption.C. Cluster resources running on leaf nodes connected to the failed hub node are relocated to one or moresurviving hub nodes.D. Cluster resources running on leaf nodes connected to the failed hub node are relocated to one or moresurviving leaf nodes.E. Cluster resources running on the failed hub node are relocated to one or more surviving hub nodes.F. Cluster resources running on the failed hub node are relocated to one or more surviving leaf nodes.G. Cluster resources running on the failed hub node are relocated to one or more surviving hub nodes or leafnodes, or both.

Answer: ABEExplanation:Incorrect Answers:F, G: Leaf Nodes are different from standard Oracle Grid Infrastructure nodes, in that they do not require direct access to shared storage, but instead request data through Hub Nodes. Hub Nodes can run in an Oracle Flex Cluster configuration without having any Leaf Nodes as cluster member nodes, but Leaf Nodes must be members of a cluster that includes at least one Hub Node.https://docs.oracle.com/database/121/CWADD/bigcluster.htm#CWADD92409

QUESTION 6Which two statements are true about Flex ASM in a Flex Cluster?

A. Oracle databases from releases older than 12c cannot use Flex ASM.B. ASFS may only be configured on a hub node running an ASM instance.C. Instances of ASM-based databases on hosts that have no ASM instance running, require Flex ASM.D. Flex ASM requires that I/Os requests be sent through an ASM Proxy Instance, regardless of database andASM instance placement in a cluster.E. Hub nodes with connections from multiple leaf nodes must run an ASM instance.

Answer: BEExplanation:B: Oracle Automatic Storage Management Cluster File System (Oracle ACFS) can only be run on the hub nodes, not the leaf nodes. Architecturally Oracle Flex Cluster comprises of a Hub and Leaf architecture where in only the Hub nodes will only have direct access to Oracle Cluster Registry (OCR) and Voting Disk (VD).E: application can access the database via Leaf nodes without ASM instance NOT running on Leaf nodes. The connection to the database is through Hub making it transparent for the application.Incorrect Answers:A: The Oracle Flex ASM can be implemented in two ways:Pure 12c Flex ASM (Same Version)Both Grid Infrastructure (GI) and Database running on Oracle 12cPre Oracle 12c Mixed (Different Versions)As normal ASM instance will run on each node with Flex configuration to support pre 12c database. The compatibility parameter of ASM disk group is used to manage the compatibility of between and among database instances. Advantage of this approach is that if an Oracle 12c database instance loses connectivity with an ASM instance, then the database connections will failover to another ASM instance on a different server. This failover is achieved by setting the cardinality to all.http://www.oracle.com/technetwork/articles/database/flexasm-flexcluster-benefits-odb12c-2177371.html

QUESTION 7Which three statements are true about the cluster file system archiving scheme?

A. Each node can read only the archived logs written by itself.B. Nodes don’t use network to archive files.C. Each node can read the archive redo log files of the other nodes.D. Each node archives to a uniquely named local directory.E. Each node archives to a local directory with the same path on each cluster node.F. Each node writes to a single location on the cluster file system while archiving the redo log files.

Answer: BCFExplanation:Initialization Parameter Settings for the Cluster File System Archiving SchemeIn the cluster file system scheme, each node archives to a directory that is identified with the same name on all instances within the cluster database (/arc_dest, in the following example). To configure this directory, set values for the LOG_ARCH_DEST_1 parameter, as shown in the following example:https://docs.oracle.com/database/121/RACAD/rman.htm#RACAD320

A. One UNDO tablespace for each PDB is required.B. One UNDO tablespace for each instance is required.C. PDBs can have local temporary tablespaces.D. All the containers share the same SYSTEM and SYSAUX tablespaces.E. You can open one, several, or all PDBs on one, several, or all CDB instances.

Answer: BCEExplanation:B: For an Oracle RAC CDB, one active undo tablespace exists for each instance.C: From a physical perspective, a CDB has basically the same structure as a non-CDB, except that each PDB has its own set of tablespaces (including its own SYSTEM and SYSAUX tablespaces) and data files.https://docs.oracle.com/database/121/CNCPT/cdblogic.htm#CNCPT89268

QUESTION 9Which two statements are true about ASM alias names?

A. ASM files created using an alias name are not OMF files even if OMF is enabled.B. Alias file names cannot be used together with templates when creating tablespaces.C. ASM files created using an alias name are OMF files even if OMF is not enabled.D. Alias names can be stored only in user-defined directories.E. ASM files created using an alias name also have a fully qualified name and can be accessed by eithername.

Answer: AE

QUESTION 10Which three statements are true concerning activation of a user-defined policy in Oracle 12c Clusterware?

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

Answer: BCEExplanation:BE: You can activate policies when necessary, prompting Oracle Clusterware to reconfigure a server pool according to each policy’s configuration.C: The following command activates the DayTime policy: $ crsctl modify policyset -attr “LAST_ACTIVATED_POLICY=DayTime”https://docs.oracle.com/database/121/CWADD/pbmgmt.htm#CWADD92594