Oracle 1Z0-068 Online Practice Questions and Exam Preparation

Oracle 1Z0-068 Online Questions & Answers

• Question 81:

  Which three statements are true about ASM Cloud File System (ACFS) encryption? (Choose three.)

  A. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.
  B. acfsutil encr init is used to establish role separation between encryption managers and encryption auditors.
  C. acfsutil encr off can be run by an encryption manager who may not have system administrator privileges.
  D. acfsutil encr on can be used to specify the encryption key length for a directory or file.
  E. An ACFS snapshot can be ACFS encrypted.
  A. A copy of an encrypted file is not encrypted unless it is created in an encrypted directory.
  D. acfsutil encr on can be used to specify the encryption key length for a directory or file.
  E. An ACFS snapshot can be ACFS encrypted.

  ---

  Reference: https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmfilesystem.htm#OSTMG30000

• Question 82:

  PROD1, PROD2, and PROD3 are three Instance that have the PROD database open.

  The OLTP service was created using:

  $ srvctl add service -db prod -service OLTP -preferred PROD1, PROD2 -available PROD3

  After starting the OLTP service, you execute this command:

  $ srvctl stop instance -db prod -instance " PROD1, PROD2 " -stopoption immediate -f

  Which statement is true about the outcome of this command?

  A. It shuts down PROD1 and PROD2; OLTP will be started automatically on PROD3.
  B. It shuts down PROD1 and PROD2; OLTP will not be started on PROD3.
  C. PROD1and PROD2 are not shut down because OLTP must first be stopped.
  D. PROD1and PROD2 are not shut down because OLTP must first be manually relocated to PROD3.
  E. It shuts down either PROD1or PROD2 but not both, so that OLTP remains available on a preferred instance.
  A. It shuts down PROD1 and PROD2; OLTP will be started automatically on PROD3.
  D. PROD1and PROD2 are not shut down because OLTP must first be manually relocated to PROD3.

• Question 83:

  Which three statements are true about diagnostic reporting for the OCR and OLR flies? (Choose three.)

  A. The OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes.
  B. The OCRDUMP utility can dump specific keys from the OLR in an online fashion with the clusterware running on all nodes.
  C. The OCRCONFIG utility can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes.
  D. The OCRCHECK utility can check the OLR in an online fashion with the clusterware running on all nodes.
  E. The CLUVFY utility can check the integrity of the OCR but not the OLR
  A. The OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes.
  C. The OCRCONFIG utility can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes.
  E. The CLUVFY utility can check the integrity of the OCR but not the OLR

• Question 84:

  Which three statements are true about Oracle 12 RAC Database 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.
  A. It is possible to install RAC database software on a one node cluster.
  D. The Cluster Verification Utility (CLUVFY) must be used to check the cluster before installing the RAC database software.
  F. The RAC database 12c software home and Grid Infrastructure homes must be owned by the same OS user.

  ---

  A: An Oracle home is the directory in which you install Oracle Database binaries, and from which Oracle Database runs. Use Oracle Appliance Manager (through oakcli commands) to create and manage multiple Oracle homes and databases

  on Oracle Database Appliance. Oracle Database Appliance supports multiple Oracle Homes including different versions for Oracle Database 11g Release 2, 11gR2 and Oracle Database Release 12c Release 1.

  D: You can use Cluster Verification Utility (CVU) to assist you with system checks in preparation for starting an upgrade.

  F: The same user that owned the earlier release Oracle Grid Infrastructure software must perform the Oracle Grid Infrastructure 12c Release 1 (12.1) upgrade. Before Oracle Database 11g, either all Oracle software installations were owned

  by the Oracle user, typically oracle, or Oracle Database software was owned by oracle, and Oracle Clusterware software was owned by a separate user, typically crs.

  Reference:

  https://docs.oracle.com/cd/E22693_01/doc.12/e55580/dbadmin.htm#CHDJIBEE https://docs.oracle.com/database/121/CWLIN/procstop.htm#CWLIN517

• Question 85:

  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
  A. Pluggable Databases (PDBs)
  B. administrator-defined resources
  E. cluster resources

• Question 86:

  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.
  A. Use srvctl stop vip 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.

• Question 87:

  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.
  A. The three listed disks may have previously belonged to a disk group.
  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.

• Question 88:

  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
  A. ocrcheck
  B. ocrcheck -config -local
  E. cluvfy comp ocr -n all -verbose

• Question 89:

  Which three statements are true about ASM Cloud File System (ACFS) tagging?

  A. acfssettag is a command provided by a platform-independent API to tag files.
  B. acfssettag is a command provided by a platform-dependent API to tag files.
  C. ACFS tagging is used to mark a subset of files in an ACFS file system for replication.
  D. acfsutil encr on can be used to specify the tag names of the files to be encrypted.
  E. acfsutil tag set can be used to tag files.
  A. acfssettag is a command provided by a platform-independent API to tag files.
  C. ACFS tagging is used to mark a subset of files in an ACFS file system for replication.
  E. acfsutil tag set can be used to tag files.

  ---

  A: The acfssettag command sets the tag name on an Oracle ACFS file.

  Syntax

  sb8 acfssettag(const oratext *path, const oratext *tagname, oratext *value, size_t size, ub4 flags);

  C: Oracle ACFS tagging assigns a common naming attribute to a group of files. Oracle ACFS Replication can use this tag to select files with a unique tag name for replication to a different remote cluster site. The tagging option avoids having

  to replicate an entire Oracle ACFS file system.

  E: The acfsutil tag set command adds the given tag to the specified files or directories in an Oracle ACFS file system. Incorrect Answers:

  D: The acfsutil encr on command encrypts an Oracle ACFS file system, directories, or individual files. However, you specify a directory not a tag name.

  References: https://docs.oracle.com/database/121/OSTMG/GUID-9D88AC84-F3E1-432B-8907- E6D7647E1B0F.htm#OSTMG95633 https://docs.oracle.com/database/121/OSTMG/GUID-5A980C0A-BE5E-4489-8A25- ED9596BF6CA2.htm#OSTMG34700

• Question 90:

  Which three statements are true about displaying the location of voting files, OCR files, or OLR files in Oracle Clusterware 12c on a UNIX system?

  A. Use cat /etc/oracle/ocr.loc to view the location of the OCR if stored in ASM.
  B. Use ocrcheck command to view the location of the OCR only if stored in a file system.
  C. Use crsctl querry votedisk to view the location of voting files if stored in ASM.
  D. Use the ls command in the asmcmd utility to view the location of voting files if stored in ASM.
  E. Use crsctl query votedisk to view the location of voting files if stored in a file system.
  F. Use cat /etc/oracle/olr.loc to view the location of the OCR and OLR if stored on a file system.
  B. Use ocrcheck command to view the location of the OCR only if stored in a file system.
  E. Use crsctl query votedisk to view the location of voting files if stored in a file system.
  F. Use cat /etc/oracle/olr.loc to view the location of the OCR and OLR if stored on a file system.

  ---

  B: The OCRCHECK utility displays the version of the OCR's block format, total space available and used space, OCRID, and the OCR locations that you have configured

  Use the ocrconfig -add command to add an OCR location to a shared file system or Oracle Automatic Storage Management (Oracle ASM) disk group.

  Note: The example shows using the ocrcheck -config -details command to obtain the location of OCR in an Oracle ASM disk group.

  Using OCRCHECK to Obtain OCR Information:

  $ ocrcheck -config -details

  Oracle Cluster Registry configuration is :

  Device/File Name : +ocrvd11/mjk_1/OCRFILE/registry.255.842574113 Device/File Name : +ocrdv2/mjk_1/OCRFILE/registry.255.842574125

  E: To determine the current voting disk by issuing the following command:

  crsctl query votedisk css

  F: The olr.loc file consists of the OLR config file location and the crs_home location.

  $ cat olr.loc

  olrconfig_loc=/u01/app/oracle/grid/11.2.0/cdata/.olr crs_home=/u01/app/oracle/grid/11.2.0

  So, by default the location is olrconfig_loc =/cdata/.olr.

  References:

  https://docs.oracle.com/database/121/CWADD/ocrsyntax.htm#CWADD92028 https://gjilevski.com/2009/09/23/what-is-a-voting-disk/