You just added an ASM disk to the DATA diskgroup.
Which two can be used to monitor the rebalancing?
A. ams_cmd lsop
B. v$asm_disk
C. v$asm_operation
D. v$asm_diskgroup
E. v$session_longops
F. amscmd lsdg
Examine this command:
SQl> CREATE DISKGROUP RECO HIGH REDUNDANCY:
FAILGROUP fgrpl1 DISK
`/dev/disk1' NAME disk1,
`/dev/disk2' NAME disk2,
`/dev/disk3' NAME disk3,
FAILGROUP fgrpl2 DISK
`/dev/disk4' NAME disk4,
`/dev/disk5' NAME disk5,
`/dev/disk6' NAME disk6,
FAILGROUP fgrpl3 DISK
`/dev/disk7' NAME disk7,
`/dev/disk8' NAME disk8,
`/dev/disk9' NAME disk9,
ATTRIBUTE `au_size'='4M',
`compatible.asm' = '12.1',
`compatible.rdbms' = '12.1',
`compatible.advm' = '12.1',
`content_type' = `recovery';
Which two statements are true about this disk group?
A. File created in it have three copies for each allocation unit.
B. Any database instance with the COMPATIBLE parameter 10.1 and higher can use it.
C. The Compatible attribute values of the disk group can be changed to lower values.
D. Files created using a template with the redundancy attributes set to MIRROR will have three-way Mirroring.
E. The RECO diskgroup may only be used for the FRA.
F. Files created using a template with the redundancy attribute set to HIGH will have three-way mirroring.
Which three statements are true about the Global Enqueue Service and Global Enqueue Service (GES) Resources in Oracle 12c RAC?
A. The mastering instance for a GES resource is never the same as the instance that owns the enqueue in exclusive mode.
B. The LMD0 runs only on the instance that masters all GES resources.
C. When a GES resource is dequeued, converters if any exist for that resource, are processed before any waiter for that resource.
D. The LMD0 process on the requesting instance communicates with the LMD0 process on the mastering instance if they are not the same instance.
E. The mastering instance for a GES resource is never the same as the instance that owns an enqueue in shared mode.
F. An LMD0 process runs on all instances.
G. The foreground process on the requesting instance communicates with the LMD0 process on the mastering instance if they are not the same instance.
Which three statements are true about Quality of Service Management (QoS)?
A. A server-pool can be managed by QoS even if it does have database instances running on any server in the pool.
B. It can manage database services only if they are defined as UNIFORM services.
C. It requires Oracle Grid Infrastructure for a Cluster to be installed and Clusterware to be running.
D. It supports multiple databases assigned to the same server pool.
E. Databases managed by QoS can be administrator managed or policy managed.
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.
When using Oracle 12 Clusterware, which two actions are required to repair the ocr.loc file on host01 in a cluster having three other nodes called host02, host03, and host04?
A. Run ocr.config 璻epair on another node in the cluster to repair the ocr.loc file on host01
B. Stop the clusterware stack on host01 only.
C. Stop the clusterware stack on all cluster nodes.
D. Run ocrconfig 璻epair on host01.
E. Stop the clusterware stack on host01 and on the node used to issue the ocrconfig 璻epair command.
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 are true regarding the actions performed? (Choose two.)
A. The ACFS file system will be permanently removed from the volume.
B. The ACFS mount registry with Oracle restart is automatically deleted.
C. The volume can be enabled and the file system can be mounted back again to access the existing data.
D. The ACFS file system will be permanently removed from the volume only if the file system is empty.
E. The disabling of volume does not destroy data in the file system.
Which three statements are true about ASM Cloud File System (ACFS) encryption? (Choose three.)
A. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.
B. acfsutil encr init is used to establish role separation between encryption managers and encryption auditors.
C. acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.
D. acfsutil encr on can be used to specify the encryption key length for a directory or file.
E. An ACFS snapshot can be ACFS encrypted.
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 statement is true concerning the execution of the addNode.sh script for adding a node to an Oracle 12c Clusterware standard Cluster that uses Grid Naming Service (GNS)?
A. Adding a node to a Standard Cluster requires the specification of the CLUSTER_NEW_NODE_ROLES parameter.
B. Multiple nodes may be added to a standard cluster by a single execution of addNode.sh.
C. Nodes in a Standard Cluster must have a VIP specified when adding the node to a cluster.
D. Nodes in a Standard Cluster must have a High Availability IP (HAIP) adaptor specified when adding the node to a cluster.