NEW QUESTION 1
Which two statements are true regarding server-side connect-time load balancing for a RAC database when using SCAN listeners?

• A. It is based on performance metrics provided by the database instances LREG processes.
• B. LOCAL_LISTENER must be configured to point to the SCAN to enable server-side load balancing.
• C. The service’s connection load balancing goal must be manually configured to enable server-side connect-time load balancing.
• D. It’s enabled only when LOAD_BALANCE=YES is included in the TNS entry used by the client.
• E. Server-side load balancing requires the REMOTE_LISTENER to point to the SCAN.

Answer: CE

Explanation: C: With server-side load balancing, the SCAN listener directs a connection request to the best instance currently providing the service, based on the -clbgoal and -rlbgoal settings for the service.
E: The SCAN is an essential part of Database configuration. So, by default, the REMOTE_LISTENER parameter is set to the SCAN, assuming that the Database is created using standard Oracle tools. This enables the instances to register with the SCAN Listeners as remote listeners to provide information on what services are being provided by the instance, the current load, and a recommendation on how many incoming connections should be directed to the instance.
Note: Single Client Access Name (SCAN) is an Oracle Real Application Clusters (Oracle RAC) feature that provides a single name for clients to access Oracle Databases running in a cluster.

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

• A. asmcmd lsct
• B. v$session
• C. v$process
• D. v$asm_client
• E. asmcmd lsdg

Answer: AD

NEW QUESTION 3
Which two statements are true concerning ASM diskgroups using disks with a 4k sector size?

• A. Their COMPATIBLE.ASM attributes must be set to 12.1 or higher.
• B. Their COMPATIBLE.ASM attributes must be set to 11.2 or higher.
• C. Performance of ACFS is improved by using these diskgroups.
• D. Their COMPATIBLE.RDBMS attributes must beset to 11.2 or higher.
• E. Their sector size attributes can be changed using the ALTER DISKGROUP command.

Answer: BD

Explanation: The values for SECTOR_SIZE can be set to 512, 4096, or 4K if the disks support those values. The default value is platform dependent. The COMPATIBLE.ASM and COMPATIBLE.RDBMS disk group attributes must be set to 11.2 or higher to set the sector size to a value other than the default value.

NEW QUESTION 4
Which statement is true about using OPatch to patch Oracle Grid Infrastructure 12c?

• A. All grid infrastructure patches may be applied in a rolling fashion with Opatch.
• B. Opatch can patch all cluster nodes simultaneously without stopping the clusterware on all nodes.
• C. Opatch can patch all cluster nodes simultaneously only for nonrolling patches.
• D. Applying patches with Opatch must be done in an out-of-place fashion.

Answer: A

Explanation: As with standard upgrades to Oracle Grid Infrastructure, at any given point in time for normal operation of the cluster, all the nodes in the cluster must have the same software release and patch level. Because one-off patches can be applied as rolling upgrades, all possible patch levels on a particular software release are compatible with each other.
Note: Starting with Oracle Grid Infrastructure 12c Release 1 (12.1), a new cluster state called "Rolling Patch" is available. This mode is similar to the existing "Rolling Upgrade" mode in terms of the Oracle ASM operations allowed in this quiesce state.
References: https://docs.oracle.com/database/121/CWLIN/procstop.htm#CWLIN528

NEW QUESTION 5
Which two components must always be defined or specified by an administrator to make an application highly available using Oracle 12c Clusterware?

• A. A Server Pool
• B. an application VIP
• C. an application resource
• D. a resource dependency definition
• E. a script agent

Answer: CE

Explanation: Oracle Clusterware manages applications when they are registered as resources with Oracle Clusterware. Oracle Clusterware has access to application-specific primitives that have the ability to start, stop, and monitor a specific resource. Oracle Clusterware runs all resource-specific commands through an entity called an agent.
Note: When initializing the agent framework, if any of the mandatory entry points are not provided, then the agent framework invokes a script pointed to by the ACTION_SCRIPT resource attribute.
References: https://docs.oracle.com/database/121/CWADD/crschp.htm#CWADD92082

NEW QUESTION 6
Examine the output of the asmcmd and srvct1 commands:

You execute this command:
$ srvctl modify asm –count 2
All databases on the cluster are running from Oracle 12c homes. Which statement is true about the outcome of this command?

• A. One ASM instance is shut down and the instance count is reduced by one.
• B. ASM instances continue running on all three nodes until all database instances connected to one of the ASM instances shut down.
• C. The command fails because one ASM instance must be shut down manually before executing the command.
• D. The command fails because the instance count cannot be reduced to less than the minimum value of 3.

Answer: A

NEW QUESTION 7
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 le system can be mounted back again to access the existing data.
• D. The ACFS le 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.

Answer: CE

NEW QUESTION 8
You created a RAC database with DBCA and decide to verify it. The server pool large_db has four servers.
Examine the output shown:

Which two statements are true based on this output? (Choose two.)

• A. The sales database resource will be started and the database instances will be started automatically when restarting the clusterware stack after normal shutdown of the sales database.
• B. The sales database resource will be restored to its previous running condition when restarting theclusterware stack after normal shutdown of the sales database.
• C. The sales database resource will be restarted automatically after an instance failure.
• D. The concurrency values are not shown because sales in not a RAC One Node database.
• E. The concurrency values are not shown because sales has only one of its four instances running.

Answer: BD

NEW QUESTION 9
Which two statements are true concerning the installation of Oracle Grid Infrastructure 12c when using a Standard Cluster? (Choose two.)

• A. The Clusterware binaries may be installed without installing ASM binaries.
• B. The Grid Infrastructure Management Repository is only required when using ASM.
• C. Specifying the use of Grid Naming Service is optional.
• D. Normal Redundancy ASM Disk Groups used for Clusterware flies will contain three voting files regardless of the number of failgroups.
• E. High Redundancy ASM Disk Groups used for Clusterware files will contain two OCRs.

Answer: AD

NEW QUESTION 10
Examine this query and output:
SQL> select order_flag, cache_size, session_flag, keep_value,
2 from user_sequences where sequence_name = ‘SEQ1’; O CACHE_SIZE S K
-- ------------------- -- -- Y 10 N N
Performance analysis revealed severe SQ enqueue contention on the SEQ1 sequence. The SEQ1 sequence is incremented from all instances equally and is frequently used. Which two statements should you execute to reduce SQ enqueue contention?

• A. alter sequence seq1 cache 10000;
• B. alter sequence seq1 order;
• C. alter sequence seq1 noorder;
• D. exec sys.dbms_shared_pool.keep (‘SEQ1’, ‘Q’)
• E. alter sequence seq1 keep;

Answer: AC

Explanation: A: Increasing sequence caches improves instance affinity to index keys deriving their values from sequences. That technique may result in significant performance gains for multi-instance insert-intensive applications.
C: When creating sequences for a RAC environment, DBAs should use the noorder keyword to avoid an additional cause of SQ enqueue contention that is forced ordering of queued sequence values. In RAC, a best practice is to specify the “noordered” clause for a sequence. With a non-ordered sequence, a global lock not required by a node whenever you access the sequence.

NEW QUESTION 11
Which three statements are true about using ADVM volumes and mounting ACFS file systems from leaf nodes in a Flex Cluster? (Choose three.)

• A. Partitioning ADVM-managed volumes using fdisk or other utilities on a leaf node is not supported.
• B. An ADVM volume cannot be used as a boot device on a leaf node.
• C. To use ADVM volumes, an ASM proxy instance is not required on a leaf node.
• D. ADVM volumes can be used to store the OCR and voting les to be used by a leaf node.
• E. An ADVM volume cannot be used as the root file system on a leaf node.
• F. To use ADVM volumes on a leaf node, the oraclesacfs, oracleoks, and oracleadvm drivers must be loaded on all hub nodes.

Answer: BEF

NEW QUESTION 12
Which three statements are true concerning diagnostic components and requirements of Oracle 12c Clusterware? (Choose three.)

• A. There is one ologgered service for the cluster health monitor (CHM) on each cluster node regardless of cluster size.
• B. The Grid Infrastructure Management Repository database must run on a hub node if Flex Clusters are used.
• C. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless of cluster 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 used by the cluster health monitor (CHM).

Answer: BCD

Explanation: B: The Oracle Grid Infrastructure Management Repository Runs on one node in the cluster.This must be a Hub Node in an Oracle Flex Cluster configuration.
C: There is one system monitor service on every node. The system monitor service (osysmond) is a real-time, monitoring and operating system metric collection service that sends the data to the cluster logger service.
D: Use the oclumon manage command to view and change configuration information from the system monitor service.
Syntax
oclumon manage -repos {{changeretentiontime time} | {changerepossize memory_size}} | -get {key1 [key2 ...] | alllogger [-details] | mylogger [-details]}
Where changerepossize memory_size: Use this option to change the CHM repository space limit to a specified
number of MB.
Note: The OCLUMON command-line tool is included with CHM and you can use it to query the CHM repository to display node-specific metrics for a specified time period. You can also use OCLUMON to perform miscellaneous administrative tasks, such as changing the debug levels, querying the version of CHM, and changing the metrics database size.

NEW QUESTION 13
Which two statements are true about ASM alias names?

• A. ASM files created using an alias name are not OMF files even if OMF is enabled.
• B. Alias file names cannot be used together with templates when creating tablespaces.
• C. ASM files created using an alias name are OMF files even if OMF is not enabled.
• D. Alias names can be stored only in user-defined directories.
• E. ASM files created using an alias name also have a fully qualified name and can be accessed by either name.

Answer: CE

NEW QUESTION 14
Which two statements are true about the UNDROP clause of the ALTER DISKGROUP statement?

• A. It cancels pending drops of disks dropped using the DROP DISKGROUP command.
• B. A disk cannot be undropped as a result of a drop diskgroup.
• C. It automatically unmounts the disks after successfully undropping them.
• D. It is not possible to cancel pending drops of disks dropped using the force option.

Answer: BD

Explanation: The UNDROP DISKS clause of the ALTER DISKGROUP statement cannot be used to restore disks that are being dropped as the result of a DROP DISKGROUP statement, or for disks that are being dropped using the FORCE clause.
References:

NEW QUESTION 15
Examine this command executed on the first node of a four-node cluster:
$ <DATABASE_ORACLE_HOME>/0Patch/opatch apply 18031528 What does this command do?

• A. It applies a patch to one ORACLE_HOME only on the first cluster node.
• B. It applies a patch to all database ORACLE_HOMEs with the same release only on the first cluster node.
• C. It applies a patch to one database ORACLE_HOME on all cluster nodes.
• D. It applies a patch to all database ORACLE_HOMEs with the same release on all cluster nodes.
• E. It applies a patch to all database ORACLE_HOMEs with the same release on the first cluster node.

Answer: D

NEW QUESTION 16
Which two types of IP address details are administered using the srvctl command for Oracle Clusterware 12c? (Choose two.)

• A. the Grid Naming Service (GNS) VIP
• B. public IP addresses
• C. High Available VIP (HAIP) addresses
• D. Single Client Access Name (SCAN) VIPs
• E. Storage Network IP addresses

Answer: AD

Explanation: A: To convert a cluster that is not running GNS to a GNS server cluster, run the following command as root, providing a valid IP address and a domain:
# srvctl add gns -vip IP_address -domain domain D: Example:

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

Answer: DEG