Want to know Ucertify 1Z0-068 Exam practice test features? Want to lear more about Oracle Oracle Database 12c: RAC and Grid Infrastructure Administration certification experience? Study Top Quality Oracle 1Z0-068 answers to Down to date 1Z0-068 questions at Ucertify. Gat a success with an absolute guarantee to pass Oracle 1Z0-068 (Oracle Database 12c: RAC and Grid Infrastructure Administration) test on your first attempt.
Q1. 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
Q2. Examine this output: ASMCMD> volinfo – G ACFS –a Diskgroup Name: ACFS Volume Name: VOL1 Volume Device: /dev/asm/vol1-280
State: ENABLED
Size (MB): 2048
Resize Unit (MB): 32
Redundancy: MIRROR
Stripe Columns: 4
Stripe Width (K): 128
Usage: ACFS
Mountpath: /u01/app/grid/acfsmount
The ACFS disk group has 10 GB free space and the file system is currently mounted.
You execute this command to increase the volume size: ASMCMD >volresize –G ACFS –s
3G VOL1
Which statement is true regarding the outcome?
A. It succeeds
B. It fails because the file system must be unmounted before resizing.
C. It fails because resizing a volume containing an ACFS file system must be performed using ACFSUTIL.
D. It succeeds but the file system is automatically unmounted.
E. It fails because the –f option is not specified.
Answer: C
Q3. 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 thesoftware running anywhere in the cluster
D. When performing rolling patches, the VIPs for the node being patched are relocated to another node.
Answer: C
Q4. Which two statements are true regarding server-side connect-time load balancing for a RAC database when using SCAN listeners?
A. It is based on performance metrics provided by the database instances LREG processes.
B. LOCAL_LISTENER must be configured to point to the SCAN to enable server-side load balancing.
C. The service’s connection load balancing goal must be manually configured to enable server-side connect-time load balancing.
D. It’s enabled only when LOAD_BALANCE=YES is included in the TNS entry used by the client.
E. Server-side load balancing requires the REMOTE_LISTENER to point to the SCAN.
Answer: C,E
Q5. Oracle Clusterware manages an administrator-managed database service defined with the MANUAL management policy.
Which two statements are true?
A. The service must be manually restarted with SRVCTL every time the instance hosting the service fails.
B. Clusterware will monitor the service while it is active.
C. The service must be manually restarted with SRVCTL after restarting the Clusterware stack on the nodehosting the service.
D. When manually started, the service will always start on one or more available instances rather than on theirpreferred instances.
E. The service must be manually started with SRVCTL after a planned restart of the instance hosting theservice.
Answer: B,D
Q6. Which two types of IP address details are administered using the srvctl command for Oracle Clusterware 12c?
A. the Grid Naming Service (GNS) VIP
B. public IP addresses
C. High Available VIP (HAIP) addresses
D. Single Client Access Name (SCAN) VIPs
E. Storage Network IP addresses
Answer: C,D
Q7. Examine this command to create a volume in the DATA disk group:
SQL>ALTER DISKGROUP DATA ADD VOLUME vo11 SIZE 10g HIGH
STRIPE_WIDTH 1M;
STRIPE_COLUMNS 1;
The DATA disk group has 50GB free space.
Which two are prerequisites for successful execution of this command?
A. COMAPTIBLE.ASM and COMPATIBLE.ADVM must be set to 11.2 or higher for the DATA disk group.
B. The DATA disk group must not be created with external redundancy.
C. The DATA disk group must not contain any other volume.
D. The DATA disk group must have at least three failure groups.
E. The DATA disk group must have an AU size of 1MB.
Answer: A,D
Explanation:
The compatibility parameters COMPATIBLE.ASM and COMPATIBLE.ADVM must be set to
11.2 or higher for the disk group.
A high redundancy disk group must contain at least three failure groups.
Reference:
https://docs.oracle.com/cd/E11882_01/server.112/e18951/asmdiskgrps.htm#OSTMG1007
2 https://docs.oracle.com/cd/E18283_01/server.112/e16102/asmdiskgrps.htm
Q8. Which three statements are true about the Global Enqueue Service and Global Enqueue Service (GES) Resources in Oracle 12c RAC?
A. The mastering instance for a GES resource is never the same as the instance that owns the enqueue inexclusive mode.
B. The LMD0 runs only on the instance that masters all GES resources.
C. When a GES resource is dequeued, converters if any exist for that resource, are processed before anywaiter for that resource.
D. The LMD0 process on the requesting instance communicates with the LMD0 process on the masteringinstance if they are not the same instance.
E. The mastering instance for a GES resource is never the same as the instance that owns an enqueue inshared mode.
F. An LMD0 process runs on all instances.
G. The foreground process on the requesting instance communicates with the LMD0 process on themastering instance if they are not the same instance.
Answer: A,F,G