Refined 1Z0-068 Braindumps 2021

NEW QUESTION 1
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 2
You must deploy several Oracle 12c databases on an Oracle Grid Infrastructure Managed Cluster, and are required to have the ability to perform these actions without down time:
1. Apply a Grid Infrastructure interim patch.
2. Apply a Grid Infrastructure Patch Set Update (PSU).
3. Apply a database on-line patch.
4. Apply a Grid Infrastructure patchset.
5. Apply a database patchset.
6. Upgrade Grid Infrastructure from one release to another.
7. Upgrade databases from one release to another. Your plan is to perform these tasks:
1. Install and configure Oracle Grid Infrastructure on a local le system.
2. Install Oracle Database software on an ACFS le system.
3. Create several RAC One Node databases. Which of the 7 requirements are met by your plan?

• A. 1, 2, 3, 4, 5, 6 and 7.
• B. 1, 2, 3, 4 and 6.
• C. 1, 2, 3, 4, 5 and 6.
• D. 1, 2, 3 and 4.
• E. 2, 3, 4 and 6.
• F. 2, 3, 4, 5 and 6.

Answer: F

NEW QUESTION 3
Which three options have a RAC-specific tuning component?

• A. contention on index leaf blocks
• B. sequence definitions
• C. the size of the online redo log buffers
• D. contention for online redo log files
• E. contention for archived redo log files
• F. the load on the Cluster Interconnect

Answer: ACF

Explanation: A: Contention for data and index blocks in a single instance database will probably magnify in a RAC environment.
C: A typical cause of high latencies is when the LMS process must flush uncommitted changes to the redo log prior to sending the block to the requesting instance. If the application design is such that uncommitted blocks are often in demand across instances in the cluster then these redo log flushes might become common.
F: Examining the interconnect
When Global Cache waits are high, we should first determine if the latency is primarily the result of interconnect network waits.
References:
http://www.toadworld.com/platforms/oracle/w/wiki/10939.optimizing-oracle-rac#rac-tuning-principles

NEW QUESTION 4
You support a three-instance, policy-managed, multitenant RAC database CDB1 with two PDBs PDB_1 and PDB_2.
It runs on an eight-node cluster and a serverpool prod_pool has three servers. Examine these commands executed on HOST01:
$ srvctl add service –db CDB1 –pdb PDB_1 –service HR –serverpool prod_pool
$ srvctl start service –db CDB1 –service HR
$ srvctl stop service –db CDB1 –service HR Which two statements are true?

• A. HR is uniformly managed across all instances in prod_pool.
• B. srvctl stop service only closes PDB_1 in the instance on HOST01.
• C. srvctl stop service closes PDB_1 on all CDB1 instances.
• D. srvctl stop service prevents logins for HR only to CDB1 on HOST01.
• E. srvctl stop service prevents logins to any instance of CDB1 using service HR.
• F. HR is available on a single instance of prod_pool.

Answer: AE

NEW QUESTION 5
Which two statements are true about Oracle Clustered ASM performance? (Choose two.)

• A. Data files, redo logs, and RMAN backup pieces must be stored in different ASM disk groups for optimal performance.
• B. All ASM Disks belonging to a disk group should have the same hardware specifications and storage attributes for optimal performance.
• C. To improve performance a database must have two disk groups; one for data and one for the fast recovery area.
• D. Hardware-based mirroring combined with ASM mirroring guarantees optimal performance.
• E. All ASM Disks belonging to a disk group should be of the same size for optimal performance.

Answer: BE

NEW QUESTION 6
Which two statements are true about Quality of Service Management?

• A. It can enable a more efficient sharing of hardware resources.
• B. It can improve the performance of SQL statements.
• C. It can improve system stability as the workload changes.
• D. It can improve the performance of PL/SQL.
• E. It can reduce the load on the system caused by Oracle background processes.

Answer: AC

Explanation: Oracle Database QoS Management provides the following benefits: Note: More benefits are:

NEW QUESTION 7
Examine this command and output:

Examine this list of commands:
1. srvct1 convert db -db ron -dbtype rac -node o16n1
2. srvct1 convert db -db ron -dbtype raconenode -node 016n1
3. srvct1 add instance -db ron -instance ron_1 -node 016n1
4. srvct1 add instance -db ron -in5tance ron_2 -node 016n2
5. srvct1 start instance -db ron -instance ron_1
6. srvct1 start instance -db ron -instance ron_2
Currently, there is an instance of database ron running on o16n1.
You want to convert ron to a RAC database and make all instances available. Identify the commands required, in the correct order, to accomplish this.

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

Answer: A

NEW QUESTION 8
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 9
Which three commands can be used to verify the integrity of Oracle Clusterware 12c OCR and OLR files? (Choose three.)

• A. ocrcheck
• B. ocrcheck -config -local
• C. ocrcheck -local
• D. ocrcheck -config
• E. cluvfy comp ocr -n all -verbose

Answer: ABE

NEW QUESTION 10
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 to diskgroups.
• F. ASM Cluster File System (ASFS) can only be deployed on hub nodes.

Answer: ACF

NEW QUESTION 11
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 12
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 13
Which two commands will stop the Oracle High Availability Services (OHAS) and prevent it from starting automatically at system boot on the local node? (Choose two.)

• A. crsctl stop crs
• B. crsctl stop cluster
• C. crsctl disable crs
• D. crsctl config crs

Answer: AC

NEW QUESTION 14
Which two statements are true regarding the configuration of ASM disk groups when installing Oracle Grid Infrastructure 12c?

• A. The installer permits the creation of a disk group for use by the voting disks and OCR file.
• B. If no ASM disk groups are specified during installation, then ASM instances are not started after the installation completes on any cluster node.
• C. The installer permits the creation of a disk group to be used for the Recovery Area for the ASM instance.
• D. If ASM disk groups are configured for the Clusterware files, then ASM must be used for all databases on the cluster.
• E. ASM disk groups used for voting files and OCR files require a quorum failgroup.

Answer: AB

Explanation: You can store Oracle Cluster Registry (OCR) and voting files in Oracle ASM disk groups. d

NEW QUESTION 15
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 database opened.
• 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 the top of the hour before taking its AWR snapshot.
• E. AWR snapshots are created when control_management_pack_access is set to “none”

Answer: ADE

Explanation: AWR snapshots are collect at database level.
Oracle extends the AWR tool for RAC databases by adding the possibility to generate snapshots reports against the whole cluster database, some database instances of the cluster database, a specific database instance of the cluster database, statistics for a specific select query.
D: AWR_SNAPSHOT_TIME_OFFSET specifies an offset for the AWR snapshot start time. AWR snapshots normally start at the top of the hour (12:00, 1:00, 2:00, and so on). This parameter allows DBAs to specify an offset for the AWR snapshot start time.

NEW QUESTION 16
Which three events occur when a hub node fails in an Oracle Clusterware 12c Flex Cluster?

• A. The hub node is evicted from the cluster
• B. Leaf nodes connected to the failing hub node are reconnected to a surviving hub node without service disruption.
• C. Cluster resources running on leaf nodes connected to the failed hub node are relocated to one or more surviving hub nodes.
• D. Cluster resources running on leaf nodes connected to the failed hub node are relocated to one or more surviving leaf nodes.
• E. Cluster resources running on the failed hub node are relocated to one or more surviving hub nodes.
• F. Cluster resources running on the failed hub node are relocated to one or more surviving leaf nodes.
• G. Cluster resources running on the failed hub node are relocated to one or more surviving hub nodes or leaf nodes, or both.

Answer: ABE

NEW QUESTION 17
Which three statements are true about Server Categorization in Oracle 12c Clusterware?

• A. All server attributes that may be used to determine the server category are discovered automatically by Oracle Clusterware.
• B. Different Hub nodes in a flex cluster may belong to separate administrator-defined categories.
• C. All hub nodes in a flex cluster belong to the same Oracle-supplied category.
• D. A server may be added to only one category using the crsctl utility.
• E. All leaf nodes in a flex cluster belong to the same Oracle-supplied category.
• F. All server attributes used for categorization are administrator modifiable.

Answer: CEF

Explanation: CE: The SERVER_CATEGORY is the name of a registered server category, used as part of server categorization. Oracle Clusterware standard Clusters and Oracle Flex Clusters have default categories of hub and leaf.
F: Server Category Attributes
You define servers into named categories, and assign attributes that define servers as members of that category. Some attributes that you can use to define members of a category describe the state conditions for the server, and others describe the physical characteristics of the server. You can also create your own characteristics to define servers as members of a particular category.
References: https://docs.oracle.com/database/121/CWADD/pbmgmt.htm#CWADD92638

NEW QUESTION 18
Which three statements are true about the cluster file system archiving scheme?

• A. Each node can read only the archived logs written by itself.
• B. Nodes don’t use network to archive files.
• C. Each node can read the archive redo log files of the other nodes.
• D. Each node archives to a uniquely named local directory.
• E. Each node archives to a local directory with the same path on each cluster node.
• F. Each node writes to a single location on the cluster file system while archiving the redo log files.

Answer: ABD

Explanation: AB: In a cluster file system each node can only read from and write to its own local file system.
D: Configure each node to write to a local archiving directory that is named the same on each node. References:
https://docs.oracle.com/cd/E18283_01/rac.112/e16795/rman.htm