1z0-068 practice test

1. Question 1 · 1

   You just added an ASM disk to the DATA diskgroup. Which two can be used to monitor the rebalancing?

   Choose all answers that apply.

   • ams_cmd lsop
   • v$asm_disk
   • v$asm_operation
   • v$asm_diskgroup
   • v$session_longops
   • amscmd lsdg

2. Question 2 · 1

   Examine this command: $ srvctl modify service -db RACDB -service SRVBl -clbgoal LONG This three-Instance RAC database uses Flex ASM. Which two statements are true regarding server-side connect-time load balancing using SCAN listeners for this service? (Choose two.)

   Choose all answers that apply.

   • It is enabled only when LOAD_BALANCE=YES is coded in the client-side TNS entry used by the client.
   • The SCAN listeners redirect clients to the node listener serving the instance that has the fewest sessions for the SRVB1 service.
   • The SCAN listeners automatically balance the connections across the instances accepting logins for the SRVB1 service.
   • It is disabled because the -c1bgoal attribute is set to LONG.
   • The SCAN listeners redirect clients to the node listener serving the instance that has the fastest response time for the SRVB1 service.

3. Question 3 · 1

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

   Choose all answers that apply.

   • surviving node failures
   • surviving storage network failures
   • surviving interconnect failures
   • automatic workload management for services on local connections
   • automatic workload management for services on Oracle Net connections
   • parallel execution across all instances supporting a balanced policy-management service
   • parallel execution across all instances supporting a singleton policy-management service

4. Question 4 · 1

   Which three statements are tuning recommendations for RAC database? (Choose three.)

   Choose all answers that apply.

   • Set PARALLEL_DEGREE_POLICY=AUTO to enable In Memory Parallel Query.
   • Use sequences with CACHE and ORDER, if possible.
   • Use Locally Managed Tablespaces with large uniform extent sizes.
   • Use Locally Managed Tablespaces with autoallocate.
   • Set PARALLEL_DEGREE_POLICY=AUTO to enable automatic Parallel Statement Queueing.
   • Use sequences with CACHE and NOORDER, if possible.

5. Question 5 · 1

   You administer a three-instance, policy-managed, multitenant RAC database CDB1 with three PDBs: PDB_1, PDB_2, and PDB_3. You want to drop PDB_3. Which two statements are true? (Choose two.)

   Choose all answers that apply.

   • PDB_3 must be closed on all CDB1 instances.
   • Manually created services for PDB_3 are not removed automatically from the OCR when dropping PDB_3.
   • CDB1 must be open in restricted mode on all cluster nodes.
   • PDB_3 must be open READ ONLY in all CDB1 instances.
   • Manually created services for PDB_3 are removed automatically from the OCR when dropping PDB_3.

6. Question 6 · 1

   Examine this command and output: You want to relocate this database online to node 016n2. Which two statements must be true for a successful online migration? (Choose two.)

   Choose all answers that apply.

   

   • The database must be stored on shared storage.
   • The database must have at least two UNDO tablespaces.
   • The database must have at least two redo threads defined by the DBA.
   • Database clients must disconnect before the online relocation timeout expires.
   • Database clients must use Transaction Guard to prevent them from losing their connection.
   • The database must be open.

7. Question 7 · 1

   You plan to use DBCA to convert a single-instance Oracle 12c database on a local filesystem on a stand-alone server to RAC by using ASM. You installed Grid Infrastructure 12c on a four-node cluster. Examine this list of possible conversion steps: 1. Create a template and image files from the single-instance database by using DBCA. 2. Perform an RMAN backup of the single-instance database. 3. Validate the cluster using CLUVFY. 4. Copy the template and image files to a cluster node. 5. Restore the RMAN backup to the recovery area disk group on the cluster. 6. Perform an Oracle Database 12c RAC installation. 7. Create a RAC database with DBCA using the RMAN backup. 8. Create a RAC database with DBCA using the template. Which statement correctly lists the minimum steps required to perform the conversion?

   Choose one answer.

   • 1, 3, 4, 6, 8
   • 2, 3, 5, 7
   • 2, 5, 6, 7
   • 1, 4, 6, 8
   • 1, 4, 8
   • 2, 5, 7

8. Question 8 · 1

   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_1 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.

   Choose one answer.

   

   • 1, 3, 4, 5 and 6
   • 2, 3, 4, 5 and 6
   • 1, 4, 5 and 6
   • 2, 4, 5 and 6
   • 1, 4 and 6
   • 2, 4 and 6

9. Question 9 · 1

   Which three statements are true concerning backups of the OCR and OLR in Oracle Clusterware 12c? (Choose three.)

   Choose all answers that apply.

   • The OCR can be backed up using ocrconfig.
   • The OCR is backed up automatically every four hours.
   • The OCR is backed up by default to a cluster file system location.
   • The OLR can be backed up using ocrconfig.
   • The OLR is backed up automatically every four hours.
   • The OLR is backed up by default to a cluster file system location.

10. Question 10 · 1

    Which two actions guarantee that time is synchronized properly on all nodes in a cluster after installing Oracle Grid Infrastructure 12c? (Choose two.)

    Choose all answers that apply.

    • Configure network time protocol (NTP) on all cluster nodes, and then start the Oracle Cluster Time Synchronization Service (CTSSD) in active mode on all cluster nodes.
    • Configure network time protocol (NT P) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in observer mode when the clusterware is started.
    • Deactivate network time protocol (NTP) on all cluster nodes; Oracle Cluster Time Synchronization Service (CTSSD) will then start automatically in active mode when the clusterware is started.
    • If network time protocol (NT P) is not configured properly on all cluster nodes, then Oracle Cluster Time Synchronization Service (CTSSD) will start automatically in active mode when the clusterware is started.
    • If network time protocol (NTP) time servers are unreachable on any cluster node, then Oracle CTSSD Time Synchronization Service (CTSSD) will start

11. Question 11 · 1

    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.)

    Choose all answers that apply.

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

12. Question 12 · 1

    Which statement is true concerning the execution of the addNode.sh script for adding a node to an Oracle 12c Clusterware standard Cluster that uses Grid Naming Service (GNS)?

    Choose one answer.

    • Adding a node to a Standard Cluster requires the specification of the CLUSTER_NEW_NODE_ROLES parameter.
    • Multiple nodes may be added to a standard cluster by a single execution of addNode.sh.
    • Nodes in a Standard Cluster must have a VIP specified when adding the node to a cluster.
    • Nodes in a Standard Cluster must have a High Availability IP (HAIP) adaptor specified when adding the node to a cluster.

13. Question 13 · 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.)

    Choose all answers that apply.

    • Pluggable Databases (PDBs)
    • administrator-defined resources
    • local resources
    • database transactions
    • cluster resources

14. Question 14 · 1

    Which two are characteristics of leaf nodes in an Oracle Clusterware 12c Flex Cluster? (Choose two.)

    Choose all answers that apply.

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

15. Question 15 · 1

    Which three commands can be used to verify the integrity of Oracle Clusterware 12c OCR and OLR files? (Choose three.)

    Choose all answers that apply.

    • ocrcheck
    • ocrcheck -config -local
    • ocrcheck -local
    • ocrcheck -config
    • cluvfy comp ocr -n all -verbose

Paid access to all 33 questions

Each purchase applies to this certification. Prices are one-time payments, not monthly subscriptions.