Online Access Free 1z0-068 Exam Questions

Disk group DGRP1 has these attributes:
1. Normal redundancy
2. Two failure groups FG1 and FG2 with two disks each
3. Compatibility settings set to 12.1
The FG1 failure group goes offline due to hardware failure.
Which two statements are true? (Choose two.)

• A.Transactions on database objects stored in tablespaces in the DGRP1 disk group fail.
• B.The redundancy is lowered until the FG1 failgroup is restored and the disk group resynchronized.
• C.New allocation units are mirrored in the FG2 failure group until FG1 is restored and the disk group resynchronized.
• D.New allocation units are not mirrored but changes to allocation units are tracked in the FG2 failure group.

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 can open the PRDPDB1 PDB only if it is policy managed.
• B.It can open the PRDPDB1 PDB only if it is manually managed.
• C.It cannot open the PRDPDB1 PDB automatically.
• D.It opens the PRDPDB1 PDB if not already opened.

Which three statements are true about diagnostic reporting for the OCR and OLR flies? (Choose three.)

• A.The OCRCHECK utility can check the OLR in an online fashion with the clusterware running on all nodes.
• B.The OCRDUMP utility can dump specific keys from the OCR in an online fashion with the clusterware running on all nodes.
• C.The CLUVFY utility can check the integrity of the OCR but not the OLR
• D.The OCRDUMP utility can dump specific keys from the OLR in an online fashion with the clusterware running on all nodes.
• E.The OCRCONFIG utility can be used to repair a corrupt OCR file in an online fashion with the clusterware running on all nodes.

View the Exhibit.

Which three statements are true? (Choose three.)

• A.The three listed disks may have previously belonged to a disk group.
• B.The COMPATIBLE parameter of any database client using this disk group can be less than or equal to
  12.1.
• C.To allow an 11g R2 database to use this disk group, ASM Compatibility must be 11.2 or lower.
• D.The three listed disks may already be members of an existing disk group.
• E.The three listed disks are have definitely not been provisioned using ASMLIB.
• F.ADVM compatibility can be set greater than or equal to 11.2 without changing the value of ASM compatibility.

Examine this command:
SQL> CREATE DISKROUP data NORMAL REDANDUNCY:
FAILGROUP fgrp1 DISK
'/dev/disk1' NAME disk1,
'/dev/disk2' NAME disk2,
'/dev/disk3' NAME disk3,
FAILGROUP fgrp2 DISK
'/dev/disk4' NAME disk4,
'/dev/disk5' NAME disk5,
'/dev/disk6' NAME disk6,
FAILGROUP fgrp3 DISK
'/dev/disk7' NAME disk7,
'/dev/disk8' NAME disk8,
'/dev/disk9' NAME disk9,
ATTRIBUTE 'au_size'='4M',
'compatible.asm' = '11.2',
'compatible.rdbms' = '11.2',
'compatible.advm' = '11.2',
'content_type' = 'recovery';
Which two statements a true about this disk group, created using Grid Infrastructure 12.1?

• A.The ASM compatible attributes can be changed to 11.1 for this disk group.
• B.Each disk in each of the three fail groups is a mirror of the corresponding disk of the other two failure groups.
• C.Files created in this disk group always has two copies for each allocation unit: one primary and one secondary.
• D.Any database instance with the COMPATIBLE parameter set to 11.2 or higher can access it.
• E.It can contain ASM Dynamic Volume Manager (ADVM) volumes.