100% Guarantee of 1Z0-068 exam fees materials and rapidshare for Oracle certification for IT specialist, Real Success Guaranteed with Updated 1Z0-068 pdf dumps vce Materials. 100% PASS Oracle Database 12c: RAC and Grid Infrastructure Administration exam Today!
2017 NEW RECOMMEND
Free VCE & PDF File for Oracle 1Z0-068 Real Exam
Pass on Your First TRY 100% Money Back Guarantee Realistic Practice Exam Questions
Q1. 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.
Q2. Which two statements are true about ASM default templates?
A. Default data file templates are only created by ASM when a normal redundancy disk group is created.
B. Default template settings for redundancy depends on the disk group redundancy.
C. Default templates for a disk group can be modified.
D. Default template setting for striping depends on disk group redundancy.
E. Templates may be shared across disk groups.
Default template settings depend on the disk group type. The default template for data files for a normal redundancy.
Q3. 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)
Q4. After creating a RAC One Node database using SQL statements, you want to register this database with Oracle Clusterware as a policy-managed resource.
Which command, or sequence of commands, should you use?
A. srvctl add srvpool âserverpool ron âimportance 100 âmin 2 âmax 2 âservers 016n1, 016n2 srvct1 add db âdb ron âoraclehome $ORACLE_HOME âdbtype raconenode âserverpool ron
B. srvct1 add db âdb ron âoraclehome $ORACLE_HOME âdbtype raconenode âserver 016n1, 016n2
C. srvct1 add db âdb ron âoraclehome $ORACLE_HOME âdbtype raconenode âserverpool ron âserver016n1, 016n2
D. srvctl add srvpool âserverpool ron âimportance 100 âmin 2 âmax 2 âservers 016n1, 016n2 srvct1 add db âdb ron âoraclehome $ORACLE_HOME âdbtype raconenode âserver 016n1, 016n2
54. 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 querry 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.
Q5. Examine the output of the asmcmd and srvctl commands:
$ asmcmd showclustermode
ASM cluster : Flex mode enabled $ srvctl status asm âdetail ASM is running on host01,
host03 ASM is enabled.
$ srvctl config asm
ASM home: /u01/app/12.1.0/grid
Password file: +DATA/orapwASM
ASM listener: LISTENER
ASM instance count: 2
Cluster ASM listener: ASMNET1LSNR_ASM Then you execute this command:
$ srvctl relocate asm â currentnode host03 âtargetnode host02
Which three statements are true regarding the execution of this command based on the
A. It fails because an ASM instance is not configured to run on HOST02.
B. It succeeds and starts an ASM instance on HOST02 and shuts down the ASM instance on HOST03.
C. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnectedto the ASM instance on HOST02.
D. It fails because the ASM instance has not been shut down first on HOST03.
E. It succeeds and starts an ASM instance on HOST02 but the ASM instance on HOST03 is not shut downuntil all connected clients disconnected.
F. It succeeds and 12c database instances connected to the ASM instance on HOST03 can be reconnectedto the ASM instance on HOST01.
Q6. Which three statements are true regarding Flex ASM on a four-node cluster consisting of
three-hub nodes and a leaf node?
A. An ASM instance and database instances can coexist on the same hub node.
B. A database instance on a hub node can be a client of an ASM instance running on any leaf node.
C. A database instance on a hub node can be a client of an ASM instance running on any hub node.
D. A database instance on a leaf node can be a client of an ASM instance running on any hub node.
E. A database instance on a hub node uses an ASM instance as an I/O server when requesting I/O todiskgroups.
F. ASM Cluster File System (ASFS) can only be deployed on hub nodes.
Q7. Which two statements are true about initialization parameters for Clustered ASM instances?
A. A change to ASM_DISKSTRING requires a restart of all ASM instances for the change to take effect.
B. ASM_POWER_LIMIT controls he number of RDBMS instances that can access a disk group while it isbeing rebalanced.
C. The ASM_DISKGROUP parameter is optional.
D. The default value of INSTANT_TYPE is ASM.
E. The maximum value of ASM_POWER_LIMIT is 1024.
Q8. You just added an ASM disk to the DATA diskgroup. Which two can be used to monitor the rebalancing?
A. ams_cmd lsop
F. amscmd lsdg
Q9. 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.
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;