Which two methods exist for enabling the collection of additional resource debugging information for specific resources controlled by Oracle 12c Clusterware?

Candidates should take all of the three standalone courses listed to prepare for this exam.
D81242GC10-Oracle Database 12c: ASM Administration and
D81246GC10-Oracle Database 12c: Clusterware Administration and
D81250GC10-Oracle Database 12c: RAC Administration

The rest of the questions.

Which three statements are true concerning the Automatic Workload Repository (AWR) in a RAC environment?
A. Taking an AWR snapshot in a RAC database captures data from all instances that have the databaseopened.
B. Taking an AWR snapshot in a RAC database captures data from the local instance only.
C. Data captured by an AWR is aggregated across all instances before being stored in the database.
D. The awr_snapshot_time_offset parameter specifies the number of seconds each instance waits after thetop of the hour before taking its AWR snapshot.
E. AWR snapshots are created when control_management_pack_access is set to “none”

Which four tasks are performed by DBCA when you convert a single-instance database to a four- instance RAC database?
A. creating additional redo threads
B. creating additional undo tablespaces
C. creating shared ASM disk groups
D. adding cluster resources
E. creating database services
F. adding additional initialization parameters

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 isntances.
D. PARALLEL_MIN_SERVERS will be 200 for PROD2 and PROD3 and 100 for PROD1.

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

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 thesoftware running anywhere in the cluster
D. When performing rolling patches, the VIPs for the node being patched are relocated to another node.

Which two types of network adapters are required in which quantity in order to comply with Oracle recommendations for hardware in a cluster?
A. at least one for the public network
B. at least one for the storage network
C. at least one for the interconnect
D. at least two for the public network
E. at least two for the storage network F. at least two for the interconnect

Which two statements are true concerning Oracle 12c Clusterware-managed application VIPs?
A. If an application sends messages to be displayed and sets the DISPLAY variable, then an application VIP isrequired.
B. An application VIP is created on the default network by the appvipcfg utility.
C. An application VIP is created on the interconnect network by the crsctl utility.
D. An application VIP can be created with the crsctl utility.
E. Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails.

Which two utilities support the “what-if” command evaluation?
A. asmcmd
B. ocrconfig
C. oifcfg
D. crsctl
E. srvctl

Which three statements are true concerning diagnostic components and requirements of Oracle 12c Clusterware?
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).

Which two statements are true about v$asm – views in clustered environment?
A. They exist both in ASM and RDBMS instances, and display the same output.
B. Their names can be seen in dict when connected to an ASM instance.
C. Their names can be seen in v$fixed_table when connected to an instance of any type that is started.
D. They exist in both in ASM and RDBSM instances, but they can display different outputs depending on theinstance type.
E. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in thecluster.

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

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 todiskgroups.
F. ASM Cluster File System (ASFS) can only be deployed on hub nodes.

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

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 DIRETORYcommand even if directory USER1 doesn’t exist.

Which three components are integral parts of High Availability NFS (HANFS)?
A. Application VIP
B. DHCP
C. ExportFS
D. HAVIP
E. NFS
F. HAIP

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 DISKROUP 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 three statements a 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.
~ ❯❯❯ pwd
/Users/tmihalicek
~ ❯❯❯ mv 1z0-068-questions Work/.
~ ❯❯❯ cat Work/1z0-068-questions
Which three statements are true concerning the Automatic Workload Repository (AWR) in a RAC environment?
A. Taking an AWR snapshot in a RAC database captures data from all instances that have the databaseopened.
B. Taking an AWR snapshot in a RAC database captures data from the local instance only.
C. Data captured by an AWR is aggregated across all instances before being stored in the database.
D. The awr_snapshot_time_offset parameter specifies the number of seconds each instance waits after thetop of the hour before taking its AWR snapshot.
E. AWR snapshots are created when control_management_pack_access is set to “none”

Which four tasks are performed by DBCA when you convert a single-instance database to a four- instance RAC database?
A. creating additional redo threads
B. creating additional undo tablespaces
C. creating shared ASM disk groups
D. adding cluster resources
E. creating database services
F. adding additional initialization parameters

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 isntances.
D. PARALLEL_MIN_SERVERS will be 200 for PROD2 and PROD3 and 100 for PROD1.

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

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 thesoftware running anywhere in the cluster
D. When performing rolling patches, the VIPs for the node being patched are relocated to another node.

Which two types of network adapters are required in which quantity in order to comply with Oracle recommendations for hardware in a cluster?
A. at least one for the public network
B. at least one for the storage network
C. at least one for the interconnect
D. at least two for the public network
E. at least two for the storage network F. at least two for the interconnect

Which two statements are true concerning Oracle 12c Clusterware-managed application VIPs?
A. If an application sends messages to be displayed and sets the DISPLAY variable, then an application VIP isrequired.
B. An application VIP is created on the default network by the appvipcfg utility.
C. An application VIP is created on the interconnect network by the crsctl utility.
D. An application VIP can be created with the crsctl utility.
E. Application VIPs do not fail over to surviving cluster nodes when the node hosting the VIP fails.

Which two utilities support the “what-if” command evaluation?
A. asmcmd
B. ocrconfig
C. oifcfg
D. crsctl
E. srvctl

Which three statements are true concerning diagnostic components and requirements of Oracle 12c Clusterware?
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).

Which two statements are true about v$asm – views in clustered environment?
A. They exist both in ASM and RDBMS instances, and display the same output.
B. Their names can be seen in dict when connected to an ASM instance.
C. Their names can be seen in v$fixed_table when connected to an instance of any type that is started.
D. They exist in both in ASM and RDBSM instances, but they can display different outputs depending on theinstance type.
E. gv$asm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in thecluster.

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

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 todiskgroups.
F. ASM Cluster File System (ASFS) can only be deployed on hub nodes.

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

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 DIRETORYcommand even if directory USER1 doesn’t exist.

Which three components are integral parts of High Availability NFS (HANFS)?
A. Application VIP
B. DHCP
C. ExportFS
D. HAVIP
E. NFS
F. HAIP

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 DISKROUP 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 three statements a 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.

Hi all,

In the last year I use the exam of ‘examcollection.com’ with 91 questions, almost all erroneous answers but identical to the official exam, the same that appear corrected in this forum.
This year they have updated it to 158 questions,
Does anyone know or have new questions?

Thank you very much to all.
Greetings.

Hi, I sent the TestKing questions, question 93 to 157, to [email protected]. An extra of 65 questions that are not found in this forum ((well, one or two might be duplicates). The first 92 questions are the same as the ones in this forum, although the order differs.

Hi Jipenlee,
please send me questions too: [email protected]

Hi Jipenlee,
Please send it to me as well ,my email [email protected]

Congratulations Ziad. Could you put here yours answers ??

Thanks in advance.

Hi JipeenLee/David,

can u send me the dump to [email protected] ?

Thanks in advance!

can anyone send the 157 ques dumps with correct answer
[email protected]

hy , congrats …. can you share this dump with me : [email protected]

Tks for information colu

C is correct

https://docs.oracle.com/cd/E11882_01/rac.112/e41959/crsref.htm#CWADD92388

You can enable debugging for Oracle Clusterware resources by running the crsctl set log command, using the following syntax:

crsctl set log res “resource_name=debugging_level”

lollipop thanks for the info!