Act now and download your Oracle 1Z0-068 test today! Do not waste time for the worthless Oracle 1Z0-068 tutorials. Download Renovate Oracle Oracle Database 12c: RAC and Grid Infrastructure Administration exam with real questions and answers and begin to learn Oracle 1Z0-068 with a classic professional.
♥♥ 2021 NEW RECOMMEND ♥♥
Free VCE & PDF File for Oracle 1Z0-068 Real Exam (Full Version!)
★ Pass on Your First TRY ★ 100% Money Back Guarantee ★ Realistic Practice Exam Questions
Free Instant Download NEW 1Z0-068 Exam Dumps (PDF & VCE):
Available on:
http://www.surepassexam.com/1Z0-068-exam-dumps.html
Q1. 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: A,B,E
Q2. PROD1, PROD2 and PROD3 are three instances that have multitenant container database PROD open. PROD contains multiple PDBs.
Examine these successful commands:
$ srvctl add service –db PROD –pdb PRDPDB1 –service SRVPDB1 $ srvctl start service –db PROD –service SRVPDB1
Which statement is true about the srvctl start service command?
A. It opens the PRDPDB1 PDB if not already opened.
B. It can open the PRDPDB1 PDB only if it is policy managed.
C. It can open the PRDPDB1 PDB automatically.
D. It can open the PRDPDB1 PDB only if it is manually managed.
Answer: B
Q3. Examine the output of this command: ASMCMD> volinfo –G ACFS -a Diskgroup Name: ACFS Volume Name: VOL1 Volume Device: /dev/asm/vol1-280 State: ENABLED Size (MB): 248 Resize Unit (MB): 32 Redundancy: MIRROR Stripe Columns: 4 Stripe Width (K): 128 Usage: ACFS Mountpath: /u01/app/grid/acfsmount The ACFS disk group is a normal redundancy disk group with 5 GB of free space. To increase the size of the ACFS file system, you execute this command as the root user: $ /sbin/acfsutil size +200M /u01/app/grid/acfsmount
Which two statements are true regarding the outcome of this command?
A. It resizes VOL1.
B. It fails to resize the filesystem because it must be unmounted before resizing.
C. It fails to resize VOL1 because it must be executed as a user belonging to the SYSASM group.
D. It succeeds but leaves the filesystem unmounted.
E. It resizes the filesystem mounted on /u01/app/grid/acfsmount.
Answer: A,D
Q4. Which two statements are true about Flex ASM in a Flex Cluster?
A. Oracle databases from releases older than 12c cannot use Flex ASM.
B. ASFS may only be configured on a hub node running an ASM instance.
C. Instances of ASM-based databases on hosts that have no ASM instance running, require Flex ASM.
D. Flex ASM requires that I/Os requests be sent through an ASM Proxy Instance, regardless of database andASM instance placement in a cluster.
E. Hub nodes with connections from multiple leaf nodes must run an ASM instance.
Answer: A,E
Q5. Which three statements are true concerning diagnostic components and requirements of Oracle 12c Clusterware?
A. There is one ologgered service for the cluster health monitor (CHM) on each cluster node regardless ofcluster size.
B. The Grid Infrastructure Management Repository database must run on a hub node if Flex Clusters areused.
C. There is one osysmond service for the cluster health monitor (CHM) on each cluster node regardless ofcluster 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 usedby the cluster health monitor (CHM).
Answer: B,C,E
Q6. Which three statements are true about opatch version 12?
A. It can apply patches to a database ORACLE_HOME.
B. It can apply a patchset to a database ORACLE_HOME.
C. It cannot apply a patch to a Grid Infrastructure ORACLE_HOME.
D. It cannot run with root privileges on a Unix-like system.
E. It can apply some patches without shutting down database instances.
F. It can only apply patches on the cluster node from where it is issued.
Answer: A,D,E
Q7. Which two tasks must be performed before launching the Oracle universal installer to install Oracle Database Software for RAC?
A. ssh user equivalence for the Oracle software owner must be configured on all cluster nodes.
B. Grid infrastructure must be installed on all cluster nodes where the Database software will be installed.
C. ssh user equivalence for the Oracle software owner must be configured on all cluster nodes where theDatabase Software will be installed.
D. Grid infrastructure must be installed on all cluster nodes.
E. The Clusterware stack must be up on all cluster nodes.
Answer: A,D
Q8. You plan to apply a patchset to a RAC database running on a two-node cluster.
The cluster has this configuration: Grid infrastructure release 12.1.0.1.0 RAC database release 12.1.0.1.0
All software installed on local file systems
The database is deployed on ASM disk groups.
Examine this list of possible tasks:
Apply the patchset to Grid Infrastructure by installing it in a new location. Stop all database instances.
Apply the database patchset in a new location.
Apply the database patchset on top of the existing ORACLE_HOME.
Start only one database instance in upgrade mode and run the upgrade script.
Start all database instances in upgrade mode and run the upgrade script.
Start all database instances and run the upgrade script. Start all database isntances.
Identify the required tasks in the correct order to apply the patchset with the least amount of down time.
A. 1, 3, 2, 5 and 8 B. 3, 2, 5 and 8
B. 1, 2, 3, 5 and 8
C. 3, 2, 6 and 8
D. 3, 2, 5, 2 and 8
Answer: C
Q9. You are developing a user callout procedure to send an email to the helpdesk whenever a
RAC database instance fails to restart after node failure.
Examine these tasks:
1.Create a shell-script with the name callout.sh to send an email for the instance event.
2.Create a shell script with any name to send an email for the instance event.
3.Store the script in the <Grid Home>/racg/usrco directory on the first node of the cluster.
4.Store the script in the <Grid Home>/racg/usrco directory on all the nodes of the cluster.
5.Store the script in the <DB Home>/racg/usrco directory on the first node of the cluster.
6.Store the script in the <DB Home>/racg/usrco directory on all the nodes of the cluster.
7.Give the Clusterware owner execute permissions on the script.
8.Give the Database owner execute permissions on the script.
Identify the minimum steps required, in the correct sequence, to implement this.
A. 1, 3, 7
B. 1, 4, 6
C. 2, 5, 8
D. 2, 4, 7, 8
E. 2, 4, 7
F. 1, 4, 7, 8
Answer: F
Q10. 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: A,D
