Which 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 to diskgroups.
F. ASM Cluster File System (ASFS) can only be deployed on hub nodes.
PROD1, PROD2 and PROD3 are three active instances of the PROD database.
Examine these commands executed on PROD1:
SQL > ALTER SYSTEM SET PARALLEL_MIN_SERVERS=200 SCOPE=MEMORY sid='*'; SQL > ALTER SYSTEM SET PARALLEL_MIN_SERVERS=100 SCOPE=MEMORY sid='PROD1';
Which statement is true?
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 instances.
D. PARALLEL_MIN_SERVERS will be 200 for PROD2 and PROD3 and 100 for PROD1.
Which two Operating System users and groups must be created on each node before installing Oracle Grid Infrastructure 12c?
A. an O/S user to own the Clusterware installation and a different O/S user to own the Automatic Storage Management (ASM) installation
B. an O/S group to own the software inventory
C. an O/S user to own the Oracle Database installation
D. an O/S group called dba
E. a group to own the ASMLIB-provisioned storage
F. a group to own Automatic-Storage Management (ASM) Filter Driver-provisioned storage
Which statement is true concerning the installation of an Oracle Grid Infrastructure 12c patchset and its status during the installation?
A. Some grid infrastructure patchsets may not be installed in a rolling fashion.
B. They can be applied in-place.
C. When performing rolling patches, crsctl query crs softwareversion always displays the lowest version of the software running anywhere in the cluster
D. When performing rolling patches, the VIPs for the node being patched are relocated to another node.
Which three statements are true concerning node evictions and reboots performed by Oracle Clusterware 12c?
A. All node evictions require that the evicted node or nodes be rebooted.
B. A node whose performance is severely degraded can be evicted.
C. The OCSSD process may evict a node after an escalation request from a database instance LMON process.
D. The CSSDMONITOR process can request a node eviction.
E. The OCLSKD process is used for node eviction requests originating on the node to be evicted.
F. The reboot advisory broadcasts reboot decisions only over the interconnect.
Which three statements are true about Server Categorization in Oracle 12c Clusterware?
A. All server attributes that may be used to determine the server category are discovered automatically by Oracle Clusterware.
B. Different Hub nodes in a flex cluster may belong to separate administrator-defined categories.
C. All hub nodes in a flex cluster belong to the same Oracle-supplied category.
D. A server may be added to only one category using the crsctl utility.
E. All leaf nodes in a flex cluster belong to the same Oracle-supplied category.
F. All server attributes used for categorization are administrator modifiable.
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? (Choose two.)
A. asmcmd lsct
B. v$session
C. v$process
D. v$asm_client
E. asmcmd lsdg
Which three statements are true about the Global Resource Directory (GRD) in Oracle 12c RAC database and in Clustered ASM? (Choose three.)
A. All GRD Enqueue Resource master metadata is held in the shared pool of the same database instance.
B. Clustered ASM has GRD resources distributed among all ASM instances
C. RAC databases have GRD cache resources distributed among all the database instances and stored in the large pool of each instance.
D. RAC databases have GRD cache resources distributed among all the database instances and stored in the shared pool of each instance.
E. All GRD Enqueue Resource master metadata is held in the large pool of the same database instance.
F. Shadow GRD resources may exist in more than one database instance for a resource.
G. Only one GRD shadow resource may exist for an Enqueue Resource.
Which three are benefits of using RAC databases with multiple instances? (Choose three.)
A. surviving node failures
B. surviving storage network failures
C. surviving interconnect failures
D. automatic workload management for services on local connections
E. automatic workload management for services on Oracle Net connections
F. parallel execution across all instances supporting a balanced policy-management service
G. parallel execution across all instances supporting a singleton policy-management service
Which two actions guarantee that time is synchronized properly on all nodes in a cluster after installing Oracle Grid Infrastructure 12c? (Choose two.)
A. 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.
B. Configure network time protocol (NT P) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in observer mode when the clusterware is started.
C. 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.
D. If network time protocol (NT P) is not configured properly on all cluster nodes, then Oracle Cluster Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started.
E. If network time protocol (NTP) time servers are unreachable on any cluster node, then Oracle CTSSD Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started.
