Up To Date 1Z0-068 Pack 2021

NEW QUESTION 1
When installing Oracle Grid Infrastructure 12c, which three options exist for the configuration of Grid naming Service (GNS)?

• A. using Shared GNS for the leaf nodes and local GNS for the hub nodes in a Flex Cluster
• B. using Shared GNS running on another cluster
• C. using Shared GNS for the hub nodes and local GNS for the leaf nodes in a Flex Cluster
• D. creation of a new GNS for this cluster
• E. using DHCP to assign Node Virtual IP addresses for nodes in the cluster

Answer: ADE

NEW QUESTION 2
Which two statements are true about the UNDROP clause of the ALTER DISKGROUP statement? (Choose two.)

• A. It cancels pending drops of disks dropped using the DROP DISKGROUP command.
• B. ASM disks can never be undropped as a result of a DROP DISKGROUP.
• C. It automatically unmounts the disks after successfully undropping them.
• D. Disks must be rebalanced manually after successfully undropping them.
• E. It is not possible to cancel pending drops of disks dropped using the force option.

Answer: BE

NEW QUESTION 3
Which two types of IP addresses does Oracle Clusterware 12c acquire from DHCP when it started up on a cluster node using Grid Naming Service (GNS)? (Choose two.)

• A. Single Client Access Name (SCAN) virtual IP addresses (VIPs)
• B. Grid Naming Service (GNS) VIPs
• C. ASM Listener VIPs
• D. High Available IP (HAIP) addresses uses for the cluster interconnect
• E. Intelligent Platform Management Interface (IPMI) IP addresses

Answer: DE

NEW QUESTION 4
Which three statements are true concerning policy-based cluster management in Oracle 12c Clusterware?

• A. Server Pools must be managed with the crsctl utility for servers hosting an application or other administrator-defined high-availability resource.
• B. All servers in a new cluster installation belong to the generic server pool.
• C. The server pool contains servers that host administrator-defined high availability resources.
• D. Server pools must be managed with the srvctl utility for servers hosting a database.
• E. All servers in a new cluster installation belong to the free server pool.

Answer: CDE

Explanation:
C: Server pools divide the cluster into logical groups of servers hosting both singleton and uniform applications. The application can be a database service or a non-database application.
D: You manage server pools that contain Oracle RAC databases with the Server Control (SRVCTL) utility.
E: When Oracle Clusterware is installed, two internal server pools are created automatically: Generic and Free. All servers in a new installation are assigned to the Free server pool, initially
References: https://docs.oracle.com/database/121/CWADD/pbmgmt.htm#CWADD92594

NEW QUESTION 5
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 6
Examine this command:
SQL> CREATE DISKROUP data NORMAL REDANDUNCY:
FAILGROUP fgrpl 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’ = ’11.2’,
‘compatible.rdbms’ = ’11.2’,
‘compatible.advm’ = ’11.2’, ‘content_type’ = ‘recovery’;
Which two statements a true about this disk group, created using Grid Infrastructure 12.1?

• A. Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failuregroups.
• B. File created in this disk group always has two copies for each allocation unit: one primary and one secondary.
• C. It can contain ASM Dynamic Volume Manager (ADVM) volumes.
• D. Any database instance with the COMPATIBLE parameter set to 11.2 or higher can access it.
• E. The ASM compatible attributes can be changed to 11.1 for this disk group.

Answer: CD

NEW QUESTION 7
You administer a three-instance, policy-managed, multitenant RAC database CDB1 with two PDBs: PDB_1 and PDB_2.
Examine these commands executed on host01:
$ srvctl add service –db CDB1 –pdb PDB_1 –serverpool prod_pool –cardinality singleton
$ srvctl start service –db CDB1 –service CRM
$ srvctl stop service –db CDB1 –service CRM Which three statements are true?

• A. CRM is only available for new logins on the CDB1 instance on host01.
• B. CRM is available for new logins on one CDB1 instance.
• C. The srvctl start service command automatically opens PDB_1 if not already opened.
• D. The srvctl stop service command does not close PDB_1 on any instance of CDB1.
• E. The CRM service is not available for new logins on any instance of CDB1.

Answer: CDE

NEW QUESTION 8
Which three statements are true about Oracle 12 RACDatabase software installations?

• A. It is possible to install RAC database software on a one node cluster.
• B. It is possible to install multiple RAC database 12c software homes on the same cluster.
• C. The RAC database 12c software home and Grid infrastructure homes must be owned by separate OS users.
• D. The Cluster Verification Utility (CLUVFY) must be used to check the cluster before installing the RAC database software.
• E. The Cluster Verification Utility (CLUVFY) must be used to check the cluster after installing the RAC database software.
• F. The RAC database 12c software home and Grid Infrastructure homes must be owned by the same OS user.

Answer: ABD

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
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 11
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 12
Which two utilities support the “what-if” command evaluation?

• A. asmcmd
• B. ocrconfig
• C. oifcfg
• D. crsctl
• E. srvctl

Answer: DE

Explanation:
The What-If Command Evaluation feature is designed to evaluate the impact of a command executed against the cluster prior to its execution. There are two levels of the What-If Command Evaluation:
The difference between the two – other than the fact that they are provided by either CRSCTL (for the cluster administrator) or SRVCTL (for the database administrator) – is their information detail.
References:
http://www.oracle.com/technetwork/products/clustering/rac-wp-12c-1896129.pdf

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

• A. Audit information gathered by each cluster node can be consolidated into the unified ACFS audit trail.
• B. acfsutil audit archive must be used to archive audit files that are larger than 10MB.
• C. acfsutil audit init must be run by a system administrator.
• D. acfsutil audit purge can be run by an audit manager.
• E. acfsutil audit read marks audit files to indicate that it is safe to purge them.

Answer: CDE

Explanation:
C: The acfsutil audit init command must be run by the system administrator before enabling auditing for any of the audit sources on a file system.
D: Only an audit manager can run the acfsutil audit purge command.
E: acfsutil audit read marks the audit trail to indicate to the audit manager that the log archive file for the current node has been reviewed, backed up as necessary, and is safe to purge.

NEW QUESTION 14
Which three statements are true about Oracle 12c multitenant RAC databases created using the Database Configuration Assistant (DBCA) on a cluster from a RAC database home? (Choose three.)

• A. They are automatically configured to use Enterprise Manager Express.
• B. They have their pluggable databases (PDBs) opened in each container database (CDB) instance automatically after CDB creation.
• C. They can be policy managed.
• D. They can be administrator managed.
• E. They have a unique service name created for each pluggable database (PDB) automatically registered as a cluster service resource.
• F. They can have multiple pluggable databases (PDB) when the container database (CDB) is created.

Answer: CDF

NEW QUESTION 15
Which three statements are true about Oracle Flex ASM? (Choose three.)

• A. It always requires a Flex cluster.
• B. Only three ASM instances are supported in Flex ASM.
• C. The SPFILE and password file for ASM are stored by default an ASM disk group.
• D. An ASM instance can run on a leaf node.
• E. A designated network is used for communication between ASM instances and theirclients.
• F. ASM clients can fail over to other ASM instances.

Answer: CEF

NEW QUESTION 16
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 17
Which two statements are true about High Availability NFS (HANFS)? (Choose two.)

• A. HANFS does not depend on NFS services provided by the underlying operating system.
• B. HANFS performance depends on the characteristics of the underlying ASM disks.
• C. HANFS provides high availability in case of an NFS client failure.
• D. HANFS provides high availability in case of cluster node failure.
• E. NFS client requests are distributed by DNS in a round-robin fashion to the cluster nodes that export the NFS filesystem.

Answer: BC

NEW QUESTION 18
Which three are benefits of using RAC databases with multiple instances? (Choose three.)

• A. surviving node failures
• B. surviving storage network failures
• C. surviving interconnect failures
• D. automatic workload management for services on local connections
• E. automatic workload management for services on Oracle Net connections
• F. parallel execution across all instances supporting a balanced policy-management service
• G. parallel execution across all instances supporting a singleton policy-management service

Answer: BCD

NEW QUESTION 19
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 20
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 21
You must replace a failed disk that was dropped from a disk group.
You want the rebalance operation to occur with minimal performance impact.
Which two options exist to achieve this? (Choose two.)

• A. Make sure that the ASM_POWER_LIMIT parameter is set to 1 before rebalancing the disk group.
• B. Increase the value of the DISK_REPAIR_TIME attribute for the disk group.
• C. Use the WAIT clause with the ALTER DISKGROUP command.
• D. Decrease the value of the DISK_REPAIR_TIME attribute for the disk group.
• E. Set the POWER clause to 1 in the ALTER DISKGROUP command.

Answer: AB

NEW QUESTION 22
A Java application using thick JDBC connections will soon be deployed, and you must configure a RAC database to support highly available connections.
Broken connections must be re-established as quickly as possible. Which feature will support this requirement?

• A. Fast Connection Failover (FCF) with Transparent Application Failover (TAF)
• B. Transparent Application Failover (TAF)
• C. Transparent Application Failover (TAF) using Fast Application Notification (FAN)
• D. Fast Connection Failover (FCF)

Answer: C

Explanation:
The Fast Connection Failover (FCF) feature is an Oracle RAC/Fast Application Notification (FAN) client implemented through the connection pool. The feature requires the use of an Oracle JDBC driver and an Oracle RAC database.
References: https://docs.oracle.com/cd/B28359_01/java.111/e10788/rac.htm

NEW QUESTION 23
Which two statements are true about vsam views in a 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 vfixed_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 the instance type.
• E. gvasm_attribute can be used to display the ASM_POWER_LIMIT attribute of all ASM instances in the cluster.

Answer: BD

Explanation:
You can use the views to obtain information about Oracle Automatic Storage Management Cluster File System (Oracle ACFS). These views are accessible from the Oracle ASM instance.
References: https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmviews.htm#OSTMG94187

NEW QUESTION 24
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 25
......