1z0-060 Free Practice Test

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).
Examine the query and its output:
<>

1. A. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
2. B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
3. C. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.
4. D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
5. E. Re-create the password file in the Oracle Database 12c format.

Correct Answer: BD

You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC?

1. A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.
2. B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array
3. C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files
4. D. Database files stored in ZFS and accessed using conventional NFS mounts.
5. E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature
6. F. Database files stored in any file system and accessed using the Oracle Direct NFS feature
7. G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

Correct Answer: AEG

Identify two correct statements about multitenant architectures.

1. A. Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.
2. B. Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources.
3. C. Multiple CDBs share certain PDB resources.
4. D. Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.
5. E. Patches are always applied at the CDB level.
6. F. A PDB can have a private undo tablespace.

Correct Answer: BE

In your multitenant container database (CDB) with two pluggable database (PDBs). You want to create a new PDB by using SQL Developer.
Which statement is true?

1. A. The CDB must be open.
2. B. The CDB must be in the mount stage.
3. C. The CDB must be in the nomount stage.
4. D. Alt existing PDBs must be close

Correct Answer: A

You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server.
All databases of all versions use Automatic Storage Management (ASM).
Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?

1. A. The ASM compatibility attribute controls the format of the disk group metadat
2. B. RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.
3. C. The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.
4. D. The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.
5. E. The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10 g database.

Correct Answer: ABD