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

Answer: ABDF

Explanation: A: Create redo threads that have at least two redo logs for each additional instance.
B: If your single-instance database was using automatic undo management, then create an undo tablespace for each additional instance using the CREATE UNDO TABLESPACE SQL statement.
Note:
ABF: You can use Database Configuration Assistant to convert from single-instance Oracle databases to Oracle RAC. DBCA automates the configuration of the control file attributes, creates the undo tablespaces and the redo logs, and makes the initialization parameter file entries for cluster-enabled environments. It also configures Oracle Net Services, Oracle Clusterware resources, and the configuration for Oracle RAC database management for use by Oracle Enterprise Manager or the SRVCTL utility.
References: https://docs.oracle.com/cd/B28359_01/install.111/b28264/cvrt2rac.htm

NEW QUESTION 2
Which three are among the minimum components in a software image that is part of a Grid Plug and Play (GPnP) profile in Oracle Clusterware? (Choose three.)

• A. an operating system version
• B. a version of Oracle database server used in Real Application Cluster (RAC) databases
• C. software required to configure nodes at startup
• D. the GPnP software
• E. a file system version used for the software to be installed
• F. a version of Automatic Storage Management (ASM) used for the cluster

Answer: BDF

NEW QUESTION 3
View the Exhibit.

Which three statements are true? (Choose three.)

• A. The three listed disks may have previously belonged to a disk group.
• B. The three listed disks may already be members of an existing disk group.
• C. To allow an 11g R2 database to use this disk group, ASM Compatibility must be 11.2 or lower.
• D. The COMPATIBLE parameter of any database client using this disk group can be less than or equal to 12.1.
• E. ADVM compatibility can be set greater than or equal to 11.2 without changing the value of ASM compatibility.
• F. The three listed disks are have definitely not been provisioned using ASMLIB.

Answer: DEF

NEW QUESTION 4
You are administering an ORACLE RAC database with multiple instances. Examine this command executed from the PROD1 instance which succeeds: CREATE SPFILE FROM MEMORY;
Which statement is true?

• A. An SPFILE is created and contains parameter settings only for PROD1.
• B. An SPFILE is created and contains parameter settings for all instances.
• C. An SPFILE is created for each instance containing instance-specific parameter settings only.
• D. An SPFILE is created for each instance and contains parameter settings for all instances.

Answer: C

NEW QUESTION 5
For which three entities can the “what-if” command evaluation be used to determine the impact of clusterware management operations in Oracle 12c Clusterware? (Choose three.)

• A. Pluggable Databases (PDBs)
• B. administrator-defined resources
• C. local resources
• D. database transactions
• E. cluster resources

Answer: ABE

NEW QUESTION 6
Which two are characteristics of any node that is part of a Grid Plug and Play (GPnP) Domain in Oracle Clusterware?

• A. It has at least two nonroutable interfaces inside the GPnP domain for the private interconnect.
• B. It has at least two routable interfaces outside the GPnP domain for the public interface.
• C. It has at least one routable interface inside the GPnP domain for the private interconnect.
• D. It has at least one routable interface outside the GPnP domain for the public interface.
• E. It has a unique identifier that is unique outside the GPnP domain.
• F. It has a unique identifier that is unique inside the GPnP domain.

Answer: DF

Explanation: Each node participating in a GPnP domain has the following characteristics:
References: https://docs.oracle.com/cd/E11882_01/server.112/e41360/chapter1.htm#NEWFT107

NEW QUESTION 7
Which three resources are managed using global concurrency control in an Oracle 12c RAC multi-instance database? (Choose three.)

• A. latches
• B. enqueues
• C. database block buffers
• D. mutexes
• E. cursors
• F. redo log buffers

Answer: ABC

NEW QUESTION 8
Which three are characteristics of leaf nodes in an Oracle Clusterware 12c Flex Cluster? (Choose three.)

• A. They can be on a different subnet to the hub nodes.
• B. Grid Naming Service (GNS) must exist on one of the leaf nodes.
• C. They discover hub nodes automatically at startup.
• D. They require direct access to shared storage.
• E. They may discover hub nodes without having the DNS delegation configured by network administrators.
• F. Oracle database 12c RAC instances may not run on leaf nodes.

Answer: CEF

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

Answer: C

Explanation: To check the software versions on a single node. Software version is the lastest version installed in on an cluster.
You would use this option when you do the rolling upgrade.
$ crsctl query crs softwareversion [hostname]
References: https://blogs.oracle.com/myoraclediary/entry/how_to_check_clusterware_version

NEW QUESTION 10
Which two utilities can be used to predict the consequences of a filesystem failure for the Oracle 12c Clusterware stack?

• A. asmcmd
• B. srvctl predict....
• C. crsctl fail….
• D. asmca
• E. acfsutil
• F. advmutil

Answer: BE

Explanation: B: The srvctl predict filesystem command predicts the consequences of file system failure.
E: The acfsutil info fs command displays detailed Oracle ACFS file system information, such as: iscorrupt - 1 if the file system is corrupt, 0 if file system is not corrupt.

NEW QUESTION 11
Identify two placeholder wait events that can be observed while a session is waiting to access a block. (Choose two.)

• A. gc cr block busy
• B. gc current request
• C. gc current block busy
• D. gc cr request
• E. gc current grant busy
• F. gc cr grant busy

Answer: BD

NEW QUESTION 12
Identify two reasons for the gc current block busy wait event. (Choose two.)

• A. A block is busy in the local cache.
• B. A block is busy in the remote cache.
• C. The Cluster Interconnect is congested.
• D. Either the local or remote CPUs have too large a run queue.

Answer: AB

NEW QUESTION 13
You administer a RAC database that currently runs on a four-node cluster but which has three instances. Which two statements are always true about redo logs for this RAC database? (Choose two.)

• A. A thread of redo must be created before starting a fourth instance if a thread is not already available.
• B. A thread of redo must contain at least two log groups before it can be enabled.
• C. A redo log group added using ALTER DATABASE ADD LOGFILE without the INSTANCE clause is added to each instance.
• D. All the instances must have the same number of redo log groups and each group must have the same number of redo log members.
• E. A thread of redo is automatically dropped when an instance is removed from a RAC database by using SRVCTL.

Answer: AB

NEW QUESTION 14
Which three statements are true about the Global Resource Directory (GRD) in Oracle 12c RAC database and in Clustered ASM? (Choose three.)

• A. All GRDEnqueue 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 GRDEnqueue 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.

Answer: BDF

NEW QUESTION 15
Examine this command and output:
[root@host01 ~]# / sbin/acfsutil snap create snap001 /u0l/app/grid/acfsmount/ acfsutil snap create: Snapshot operation is complete.
Examine this command:
[root@host01 ~]# / sbin/acfsutil snap create –p snap001 Snap002 /u01/app/grid/ acfsmount/
Which statement must be true for the successful execution of the second command?

• A. The disk group compatibility attribute for ADVM must be set to 12.1 or higher.
• B. The parent snapshot must be read-only.
• C. The underlying ADVM volume must be configured with high redundancy.
• D. The parent snapshot must be read/write.

Answer: C

NEW QUESTION 16
You plan to apply a patchset to a RAC database running on a two-node cluster. The cluster has this configuration:
Examine this list of possible tasks (see exhibit). Exhibit:

Identify the required tasks in the correct order to apply the patchset with the least amount of down time.

• A. 1, 3, 2, 5 and 8
• B. 3, 2, 5 and 8
• C. 1, 2, 3, 5 and 8
• D. 3, 2, 6 and 8
• E. 3, 2, 5, 2 and 8

Answer: A

NEW QUESTION 17
Your four-node cluster runs Oracle 12c Clusterware and supports a mix of RAC databases from Oracle 10g Release 2 to Oracle 12c Release 1.
All databases have one or more services defined.
The Oracle 10g Release 2 database clients connect to the database instances using the public VIP.
The Oracle 11g Release 2 and 12c Release 1 clients connect to the database instances using the Single Client Access Name (SCAN).
You must change the public VIPS.
Which three steps must be done to change the VIPs on host01, the first node in the cluster? (Choose three.)

• A. Use srvctl stop vip to stop the VIP on host01.
• B. Use oifcfg setif to stop the VIP on host01.
• C. Use srvctl start vip to start the VIP on host01.
• D. Use srvctl modify nodeapps to change the VIP on host01.
• E. Use oifcfg setif to start the VIP on host01.

Answer: ACD