NEW QUESTION 1
Which three statements are true about diagnostic reporting for the OCR and OLR flies? (Choose three.)

• A. The OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes.
• B. The OCRDUMP utility can dump specific keys from the OLR in an online fashion with the clusterware running on all nodes.
• C. The OCRCONFIG utility can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes.
• D. The OCRCHECK utility can check the OLR in an online fashion with the clusterware running on all nodes.
• E. The CLUVFY utility can check the integrity of the OCR but not the OLR

Answer: ACE

NEW QUESTION 2
Which two statements are true concerning buffer states as shown in GV$BH.STATUS in Oracle 12c RAC?

• A. An XCUR block image may exist for a specific database block in only one instance.
• B. ACR image may get served from one instance to another to satisfy a read request.
• C. An XCUR image is not downgraded to a SCUR image for shipping to another instance until commits occur for updated rows on the block.
• D. A PI block image may exist for a specific database block in only one instance.

Answer: AB

Explanation: A: xcur is a RAM block that has been acquired in exclusive current mode. According the Oracle documentation, if a buffer state is exclusive current (XCUR), an instance owns the resource in exclusive mode.
B: cr mode indicates a "cloned" RAM block (a "stale" block), that was once in xcur mode. The instance has shared access to the block and can only perform reads. The cr state means the owning instance can perform a consistent read of the block, if the instance holds an older version of the data.
References:
http://www.dba-oracle.com/t_v$bh_status_free_buffer_blocks.htm

NEW QUESTION 3
Which 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: BCE

Explanation: 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"
References: https://docs.oracle.com/database/121/CWADD/pbmgmt.htm#CWADD92594

NEW QUESTION 4
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

Answer: AC

NEW QUESTION 5
Which three statements are true about ASM Cloud File System (ACFS) encryption?

• 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.

Answer: ADE

Explanation: acfsutil encr on –k key_length specifies the encryption key length for a directory or file.

NEW QUESTION 6
You are installing Oracle Grid Infrastructure 12c and configuring a Flex Cluster? Which two elements are required to support this configuration? (Choose two.)

• A. a Grid Management Repository database
• B. a network interface for ASM and private interconnect traffic
• C. a network interface for private interconnect only
• D. a network interface for the public network
• E. a Grid Management Cluster Health Management (CHM) application server

Answer: AC

NEW QUESTION 7
The DGRP1 diskgroup has these attributes:
- Normal redundancy
- Two failgroups with four asmdisks in each failgroup
- compatible.asm set to 12.1
The ASM_POWER_LIMIT parameter is currently set to 1 in the ASM instances.
There are three databases whose instances are up and which access data in the DGRP1 diskgroup. No other clients use this diskgroup.
You want to add two asmdisks to each failgroup, complete the rebalance as quickly as possible, by avoiding checks for access to allocation units, and then restore database availability.
Examine the list of actions (see exhibit): Exhibit:

Identify the correct sequence of required steps:

• A. 1, 2, 3, 4, 5, 2, 10, 7
• B. 1, 3, 5, 7
• C. 1, 8, 6, 3, 5, 8, 9, 7
• D. 1, 8, 6, 3, 5, 2, 10, 7

Answer: C

NEW QUESTION 8
Examine this tnsnames entry from a RAC configuration using a SCAN listener: HR=(DESCRIPTION=
(LOAD_BALANCE =on) (ADDRESS=(PROTOCOL=TCP)(HOST=cluster01-scan)(FORT=1521)) (CONNECT_DATA=(SERVICE_NAME=HRSRV)))
Which two statements are true about clients using this entry to connect? (Choose two.)

• A. The host name in the tnsnames entry must be changed if nodes are added or removed from the Cluster.
• B. Clients using EZConnect can benefit from connect time load balancing because the tnsnames entry refers to a SCAN listener.
• C. Client connection requests are automatically balanced across all IP addresses defined for the SCAN.
• D. A client connection request is received by a SCAN listener that creates the connection to the least-loaded database instance.
• E. Client connection requests are automatically failed over to another SCAN listener if the chosen SCAN listener is not available.

Answer: BD

NEW QUESTION 9
Examine these commands:
srvctl add service -db RACDB -service CRM -preferred RACDB_1 -available RACDB_2 - tafpolicy preconnect
srvcl start service -db RACDB -service CRM
Instances RACDB_1 and RACDB_2 run on host0l and host02, respectively. This is the only TNS entry in the client side tnsnames.ora:
CRM =
(DESCRIPTION =(FAILOVER=ON) (LOAD_BALANCE=ON)
(ADDRESS= (PROTOCOL=TCP) (HOST=host0l-VIP.example.com)(PORT=1521)) (ADDRESS= (PROTOCOL=TCP) (HOST=host02-VIP.example.com)(PORT=1521)) (CONNECT_DATA = (SERVICE_NAME = CRM)
(FAILOVER_MODE = (BACKUP=CRM_PRECONNECT) (TYPE=SESSION)(METHOD=PRECONNECT))))
Which statement is true regarding the TAF settings?

• A. Clients using this configuration fail over and restart any active queries automatically.
• B. Clients using this configuration fail over and restart any active transactions automatically.
• C. This configuration will work only for a policy-managed RAC database.
• D. The configuration is incomplete because the TNS entry for the preconnected backup session is missing.

Answer: D

NEW QUESTION 10
Which three statements are true about ASM Cloud File System (ACFS) replication?

• A. ACFS auditing information is replicated from the primary file system to the standby file system.
• B. One site of an ACFS replication configuration can be host both primary and standby file systems.
• C. Replication is automatically terminated if the primaries file system has less than 2GB free space.
• D. Standby redo log files are required on the standby site for synchronous redo transport.
• E. The privilege SYSREPL has been introduced for ACFS replication.

Answer: BCD

Explanation: B: A site can host both primary and standby file systems.
C: If the primary file system has less than 2 GB available free disk space, Oracle ACFS attempts to automatically terminate replication on the primary file system.
D: On the standby system, the remote file server (RFS) receives redo data over the network from the LGWR process and writes the redo data to the standby redo log files.
References:

NEW QUESTION 11
Which three statements are true about the administration and use of policy sets in Oracle 12c Clusterware? (Choose three.)

• A. All server pools in a cluster are controlled by the policy set, when user-defined policy management is used.
• B. Servers in a server pool outside the control of policy set are never affected by policy changes, when user-defined policy management is used.
• C. Clusterware administrators cannot directly modify the policy set when Quality of Service (QoS) Management is used.
• D. A server pool can have the same attributes defined for different policies in the policy set, when user-defined policy management is used.
• E. A server pool can have different attributes defined for different policies in the policy set, when user-defined policy management is used.

Answer: ACE

Explanation: A: A cluster configuration policy set is a document that defines the names of all server pools configured for the cluster and definitions for all policies.
C: If you create policies with Oracle Database Quality of Service Management (Oracle Database QoS Management), then you categorize servers by setting server pool directive overrides, and CRSCTL commands using the policy and policyset nouns are disabled.
Note: Oracle Database 12c has introduced the policy sets, a feature that allows preparing in advance all the different workload scenarios and activating them with a single command. The easiest way to create policy sets is dumping the current configuration into a file, edit it, and reload it into the cluster.
References: https://docs.oracle.com/database/121/CWADD/pbmgmt.htm#CWADD92635

NEW QUESTION 12
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?

• A. You can create subdirectories under the USERS directory.
• B. You cannot rename a user-created subdirectory.
• C. You cannot drop a directory containing aliases unless you delete the aliases first.
• D. You cannot create a user-defined directory at the root (+) level.
• E. You cannot create a nested subdirectory /USERS/2014 under USERS with a single CREATE DIRETORY command even if directory USER1 doesn’t exist.

Answer: DE

NEW QUESTION 13
Which two actions are performed by installing the Oracle 12c Preinstall RPM on Oracle Linux?

• A. It creates the grid user if not already defined.
• B. It modifies the /etc/sysctl.conf Linux file.
• C. It installs kernel modules required for the ASM Cluster File System (ACFS).
• D. It installs the OpenSSH client package.
• E. It creates the oinstall group if not already defined.

Answer: BE

Explanation: When installed, the Oracle Preinstallation RPM does the following:
Note: The Oracle RPMs for your Oracle Linux distributions and Oracle RDBMS releases automatically install any additional packages needed for installing Oracle Grid Infrastructure and Oracle Database, and configure your server operating system automatically, including setting kernel parameters and other basic operating system requirements for installation.
References: https://docs.oracle.com/database/121/LADBI/pre_install.htm#LADBI7493

NEW QUESTION 14
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? (Choose two.)

• A. The DB_CREATE_FILE_DEST parameter must be set to +DATA(newtemplate).
• B. newtemplate must be defined for the +DATA disk group.
• C. Existing data les in TBS1 must also use the same template.
• D. The +DATA disk group should not be part of Flex ASM.
• E. User-defined subdirectories ORCL and USERS must already exist.

Answer: CD

NEW QUESTION 15
Which three statements are true regarding ACFS snapshots in Oracle 12c ASM?

• A. They are contained in a directory on the same volume as their parent file system.
• B. All ACFS snapshot operations for all filesystem are serialized clusterwide.
• C. You can create a snapshot from an existing snapshot.
• D. They can be administered using ASMCMD.
• E. They can only be accessed when the file system is mounted.
• F. They are always point-in-time copies of the parent file system.

Answer: BCE

Explanation: All Oracle ACFS snapshot operations are serialized clusterwide in the kernel.
You chose to create a snapshot image on an existing snapshot group, select a snapshot group from the existing snapshot group table (make sure you select a snapshot group that has not reached its maximum limit of snapshot images).
Before you can access the files on a file system, you need to mount the file system. References:
https://docs.oracle.com/database/121/OSTMG/GUID-5A3EF695-A795-4FEA-8BE2-AF657BD2238C.htm#OST http://mysupport.netapp.com/NOW/public/eseries/amw/index.html#page/SANtricity_v11.20_Array_Manageme (Creating a Snapshot image 3rd point, 1st line).
https://docs.oracle.com/cd/E19455-01/805-7228/6j6q7ueup/index.html (1st paragraph, 1st line).

NEW QUESTION 16
Which three statements are true about fully qualified file names in ASM? (Choose three.)

• A. They are system generated at the time of ASM file creation.
• B. They can be used to reference existing ASM files.
• C. They can be created only if OMF is enabled.
• D. They are the only valid form that can be used for single file creation of a control file.
• E. An alias may be created for an existing le by referring to the fully qualified file name.

Answer: ABE

NEW QUESTION 17
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.

Answer: BDE

Explanation: D: The cssdagent and cssdmonitor provide the following services to guarantee data integrity:
Note If the Oracle Clusterware itself is working perfectly but one of the RAC instances is hanging , the database LMON process will request a member kill escalation and ask the CSS process to remove the hanging database instance from the cluster.
On a Linux/Unix system CSS consists of ocssd.bin, cssdmonitor, and cssdagent.
E: Cluster kill daemon (oclskd) handles instance/node evictions requests that have been escalated to the Cluster Synchronization Service (CSS).