Free 1Z0-068 Exam Dumps

Question 6

Examine these commands:
$ srvctl add service –db racdb –service erp –serverpool srvpooll
- failovertype TRANSACTION –commit_outcome TRUE – replay_init_time 1800
- retention 86400 –notification TRUE –rlbgoal SERVICE_TIME –clbgoal SHORT
- failoverretry 30 – failoverdelay 10
$ srvctl start service – db racdb – service erp
Instances RACDB_1 and RACDB_2 run on host01 and host02, respectively. Which three statements are true regarding the service erp?

A. Connections to the database using erp benefit from Application Continuity.
B. erp is configured for an administrator-managed RAC database.
C. Load Balancing Advisory (LBA) will be disabled for this service.
D. Connections to the database using erp benefit from Load Balancing.
E. Connections to the database using erp benefit from Transaction Guard.

Correct Answer:ADE
A: To enable Application Continuity for Java, set the failovertype parameter to TRANSACTION. D: -clbgoal {SHORT | LONG}
Connection Load Balancing Goal. Use a value of SHORT for this parameter for run-time load balancing, or if using an integrated connection pool.
E: Enable Transaction Guard through the -commit_outcome parameter. When it is set to TRUE, the commit outcome for a transaction is accessible after the transaction's session fails due to a recoverable outage.

Question 7

Which three statements are true about using ADVM volumes and mounting ACFS file systems from leaf nodes in a Flex Cluster? (Choose three.)

A. Partitioning ADVM-managed volumes using fdisk or other utilities on a leaf node is not supported.
B. An ADVM volume cannot be used as a boot device on a leaf node.
C. To use ADVM volumes, an ASM proxy instance is not required on a leaf node.
D. ADVM volumes can be used to store the OCR and voting les to be used by a leaf node.
E. An ADVM volume cannot be used as the root file system on a leaf node.
F. To use ADVM volumes on a leaf node, the oraclesacfs, oracleoks, and oracleadvm drivers must be loaded on all hub nodes.

Correct Answer:BEF

Question 8

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;

Correct Answer:AC
A: Increasing sequence caches improves instance affinity to index keys deriving their values from sequences. That technique may result in significant performance gains for multi-instance insert-intensive applications.
C: When creating sequences for a RAC environment, DBAs should use the noorder keyword to avoid an additional cause of SQ enqueue contention that is forced ordering of queued sequence values. In RAC, a best practice is to specify the “noordered” clause for a sequence. With a non-ordered sequence, a global lock not required by a node whenever you access the sequence.

Question 9

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.

Correct Answer:ACE

Question 10

Which two utilities can be used to predict the consequences of a filesystem failure for the Oracle 12c Clusterware stack?

A. asmcmd
B. srvctl predict....
C. crsctl fail….
D. asmca
E. acfsutil
F. advmutil

Correct Answer:BE
B: The srvctl predict filesystem command predicts the consequences of file system failure.
E: The acfsutil info fs command displays detailed Oracle ACFS file system information, such as: iscorrupt - 1 if the file system is corrupt, 0 if file system is not corrupt.