Oracle 1Z0-067 Online Practice Questions and Exam Preparation

Oracle 1Z0-067 Online Questions & Answers

• Question 211:

  Examine the command used to perform an incremental level-0 backup:

  RMAN>BACKUP INCREMENTAL LEVEL0 DATABASE;

  To enable block change tracking, after the incremental level 0 backup, you issue the command:

  SQL>ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE'/mydir/rman_change_track.f';

  To perform an incremental level-1 cumulative backup, you issue the command:

  RMAN>BACKUP INCREMENTAL LEVEL1 CUMULATIVE DATABASE;

  Which two statements are true in the preceding situation?

  A. The block change tracking data is used only from the next incremental backup.
  B. The incremental level 1 backup fails because a block change tracking file Is created after the level 0 backup.
  C. The incremental level 1 backup does not use change tracking data for accomplishing the backup.
  D. The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup.
  E. The block change tracking data is used for the next incremental level 1 backup only after the next level 0 backup.
  C. The incremental level 1 backup does not use change tracking data for accomplishing the backup.
  E. The block change tracking data is used for the next incremental level 1 backup only after the next level 0 backup.

• Question 212:

  Which three statements are true about Flashback Data Archieve? (Choose three.)

  A. A table enabled for Flashback Data Archieve cannot be dropped unless Flashback Data Archieve is disabled or disassociated first
  B. While enabling Flashback Data Archieve for a table, if no name is provided for Flashback Data Archieve, it is enabled using the default Flashback Data Archieve
  C. To use Flashback Data Archieve, users must have unlimited quota on the Flashback Data Archieve tablespace
  D. Flashback Data Archieve prevents flashback queries from getting a snapshot-too-old error
  E. To enable Flashback Data Archieve for a table, it is mandatory to have a default Flashback Data Archieve for a database
  A. A table enabled for Flashback Data Archieve cannot be dropped unless Flashback Data Archieve is disabled or disassociated first
  C. To use Flashback Data Archieve, users must have unlimited quota on the Flashback Data Archieve tablespace
  D. Flashback Data Archieve prevents flashback queries from getting a snapshot-too-old error

• Question 213:

  You need to perform a block media recovery on the tools01.dbf data file in your database by using Recovery Manager (RMAN). Which two are prerequisites for performing this operation? (Choose two.)

  A. You must take the tools01.dbf data file offline.
  B. You must ensure that the database is mounted or open.
  C. You must use an incremental level-1 backup to restore blocks.
  D. You must configure a block change tracking file.
  E. You must have full or level-0 backups to restore blocks.
  B. You must ensure that the database is mounted or open.
  E. You must have full or level-0 backups to restore blocks.

  ---

  Reference: https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmblock.htm#BRADV89785

• Question 214:

  Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).

  A. to store backup information of multiple databases in one place
  B. to restrict the amount of space that is used by backups
  C. to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause
  D. to store RMAN scripts that are available to any RMAN client that can connect to target databases registered in the recovery catalog
  E. to automatically delete obsolete backups after a specified period of time
  A. to store backup information of multiple databases in one place
  C. to maintain a backup for an indefinite period of time by using the KEEP FOREVER clause
  D. to store RMAN scripts that are available to any RMAN client that can connect to target databases registered in the recovery catalog

• Question 215:

  Which three conditions must be met before you create a Virtual Private Catalog (VPC)?

  A. A base recovery catalog should exist.
  B. The owner of VPC cannot own recovery catalog.
  C. At least one target database should be registered in the recovery catalog.
  D. The register database privilege should be granted to the virtual catalog owner.
  E. The recovery_catalog_owner role should be granted to the virtual catalog owner.
  A. A base recovery catalog should exist.
  D. The register database privilege should be granted to the virtual catalog owner.
  E. The recovery_catalog_owner role should be granted to the virtual catalog owner.

  ---

  References: http://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta013.htm

• Question 216:

  Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?

  A. A PDB opened in restricted mode allows only local users to connect.
  B. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.
  C. When a CDB is in mount state, PDBs are automatically placed in mount state.
  D. All PDBs must be shut down before shutting down a CDB instance.
  E. When a CDB instance is started, PDBs can be placed in open state by using database triggers or by executing the alter pluggable database command.
  B. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.
  C. When a CDB is in mount state, PDBs are automatically placed in mount state.
  E. When a CDB instance is started, PDBs can be placed in open state by using database triggers or by executing the alter pluggable database command.

  ---

  Reference: https://oracle-base.com/articles/12c/multitenant-startup-and-shutdown-cdb-and-pdb-12cr1

• Question 217:

  Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (COB) plan using Oracle Database Resource Manager?

  A. maximum undo per consumer group
  B. maximum idle time for a session in a PDB
  C. parallel server limit
  D. CPU
  E. maximum number of sessions for a PDB
  C. parallel server limit
  D. CPU

• Question 218:

  Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)?

  A. Use the DBMS_pdb package to plug the Oracle 11g database into the existing CDB as a PDB.
  B. Use the create database ... enable pluggable database statement to create a PDB by copying data files from pd3Sseed and use data pump to load data from the Oracle 11g database into the newly created PDB.
  C. Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB.
  D. Pre-create a PDB in CDB and use the network_link and parallel parameters with data pump import to import data from the Oracle 11g database to the newly created PDB.
  E. Upgrade the Oracle 11g database to a 12c non-CDB and use the dbms_pdb.describe procedure to plug the database as a new PDB into the CDB.
  D. Pre-create a PDB in CDB and use the network_link and parallel parameters with data pump import to import data from the Oracle 11g database to the newly created PDB.
  E. Upgrade the Oracle 11g database to a 12c non-CDB and use the dbms_pdb.describe procedure to plug the database as a new PDB into the CDB.

• Question 219:

  Examine the command to create a pluggable database (PDB):

  SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1

  FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/') PATH_PREFIX = '/disk2/oracle/pdb2';

  Which two statements are true?

  A. The pluggable database pdb2 is created by cloning pdb1 and is in mount state.
  B. Details about the metadata describing pdb2 are stored in an XML file in the '/disk2/oracle/pdb2/' directory.
  C. The tablespace specifications of pdb2 are the same as pdb1.
  D. All database objects belonging to common users in PD3I are cloned in PD32.
  E. pdb2 is created with its own private undo and temp tablespaces.
  A. The pluggable database pdb2 is created by cloning pdb1 and is in mount state.
  C. The tablespace specifications of pdb2 are the same as pdb1.

  ---

  References: https://docs.oracle.com/database/121/ADMIN/cdb_plug.htm#ADMIN13586

• Question 220:

  Identify three scenarios in which RMAN will use backup sets to perform active database duplication.

  A. when the duplicate ... from active database command contains the section size clause
  B. when you perform active database duplication on a database with flashback disabled
  C. when you specify set encryption before the duplicate ... from active database command
  D. when the number of auxiliary channels allocated is equal to or greater than the number of target channels
  E. when you perform active database duplication on a database that has read-only tablespaces
  A. when the duplicate ... from active database command contains the section size clause
  C. when you specify set encryption before the duplicate ... from active database command
  D. when the number of auxiliary channels allocated is equal to or greater than the number of target channels

  ---

  Starting with Oracle Database 12c Release 1 (12.1), RMAN can use backup sets to transfer the source database files that need to be duplicated. The backup sets are transferred over the network to the auxiliary database. Backup sets can be encrypted for additional security. Specify the encryption algorithm by using the SET ENCRYPTION ALGORITHM command before the DUPLICATE command. RMAN uses backup sets to perform active database duplication when the connection to the target database is established using a net service name and any one of the following conditions is satisfied: The DUPLICATE ... FROM ACTIVE DATABASE command contains either the USING BACKUPSET, USING COMPRESSED BACKUPSET, or SECTION SIZE clause. The number of auxiliary channels allocated is equal to or greater than the number of target channels allocated. Reference:http://docs.oracle.com/database/121/BRADV/rcmdupdb.htm#BRADV298