← Back to exam page

1z0-067 – Upgrade Oracle9i/10g/11g OCA OR OCP to Oracle Database 12c OCP

Loading demo links...

Showing 13–15 of 15 questions

Question 13

Examine the RMAN command:

RMAN> RUN {

ALLOCATE CHANNEL c1 DEVICE TYPE sbt;

ALLOCATE CHANNEL c2 DEVICE TYPE sbt;

ALLOCATE CHANNEL c3 DEVICE TYPE sbt;

BACKUP

INCREMENTAL LEVEL = 0

(DATAFILE 1, 4, 5 CHANNEL c1)

(DATAFILE 2, 3, 9 CHANNEL c2)

(DATAFILE 6, 7, 8 CHANNEL c3)

SQL ‘ALTER SYSTEM ARCHIVE LOG CURRENT’; }

Which statement is true about the command? Choose the best answer.

Select an option, then click Submit answer.

  • ○

    It uses multisection backup.
  • ○

    It uses parallelization for the backup set.
  • ○

    It uses asynchronous I/O for the backup.
  • ○

    It creates compressed backup sets.
Question 14

In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file.

What precaution must you take for the read-only tablespaces before performing an incomplete recovery?

Select an option, then click Submit answer.

  • ○

    All the read-only tablespaces should be taken offline.
  • ○

    All the read-only tablespaces should be restored separately.
  • ○

    All the read-only tablespaces should be renamed to have the MISSINGnnnn format.
  • ○

    All the read-only tablespaces should be made online with logging disabled.
Question 15

You are administering a multitenant container database (CDB) CDB1 with two pluggable databases (PDBs), PDB1 and PDB2. You execute the following commands on CBD$ROOT as the SYS user:

SQL> CREATE USER c##scott IDENTIFIED BY scottorcl1;

SQL> GRANT CREATE SESSION TO c##scott;

Which statement is true about the C##SCOTT user?

Choose the best answer.

Select an option, then click Submit answer.

  • ○

    It is created in all the PDBs with CREATE SESSION privilege.
  • ○

    It is created in all the PDBs but has CREATE SESSION privilege only in CDB$ROOT.
  • ○

    It is created and has the CREATE SESSION privilege only in a PDB that is open.
  • ○

    It is created only in CDB$ROOT and has the CREATE SESSION privilege.