Oracle 1Z0-067 Online Practice Questions and Exam Preparation

Oracle 1Z0-067 Online Questions & Answers

• Question 261:

  Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB):

  1.Start the RMAN client by using the RMAN target / command.

  2.Start the RMAN client by using the OSB user.

  3.RMAN creates the backup pieces.

  4.Run the RMAN backup command with the sbt channels.

  5.OSB creates a backup job and assigns a unique identifier.

  6.OSB creates a backup job request through the OSB sbt library.

  7.OSB stores metadata about RMAN backup pieces in the OSB catalog.

  8.OSB starts the backup operation.

  9. OSB updates the RMAN catalog.

  Identify the required steps/operations performed in correct order.

  A. 1, 4, 6, 5, 8, 3, 9
  B. 1, 6, 4, 5, 8, 3, 9
  C. 2, 4, 6, 5, 8, 3, 7
  D. 2, 4, 5, 8, 3, 7, 9
  C. 2, 4, 6, 5, 8, 3, 7

  ---

  The Oracle Secure Backup catalog is stored and managed completely separately from the RMAN recovery catalog. Oracle Secure Backup stores each backup piece and corresponding metadata about the piece.

  Reference:

  https://docs.oracle.com/cd/E26569_01/doc.104/e21476/osb_rman_backup.htm#OBADM190

• Question 262:

  Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):

  $> impdp full=Y network_link=hrdb_test transportable=always

  transport_datafiles=

  `/u01/app/oracle/oradata/hrdb/sales01.dbf',

  `/u01/app/oracle/oradata/hrdb/cust01.dbf',

  `/u01/app/oracle/oradata/hrdb/emp01.dbf',

  version=12 logfile=import.log

  Which three are prerequisites for successful execution of the command?

  A. The impdp operation must be performed by the same user that performed the expdp operation.
  B. The path of data files on the target database must be the same as that on the source database.
  C. The export dump file must be created before starting the import on the target database.
  D. All the user defined tablespaces must be in read-only mode on the source database.
  E. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXP_FULL_DATABASE role.
  F. The source and target databases must be running on the same platform with the same endianness.
  A. The impdp operation must be performed by the same user that performed the expdp operation.
  C. The export dump file must be created before starting the import on the target database.
  E. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXP_FULL_DATABASE role.

• Question 263:

  Your multitenant container database (CDB) cdb1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:

  SQL>STARTUP

  Which two statements are true about the successful execution of the command?

  A. All redo log files are opened.
  B. The root, the seed, and all the PDBs are opened in read-write mode.
  C. All the PDBs are opened in read-write mode.
  D. All the PDBs are in closed state.
  E. Only the root database is opened in read-write mode.
  A. All redo log files are opened.
  E. Only the root database is opened in read-write mode.

  ---

  The 12.1.0.2 patchset has introduced the ability to preserve the startup state of PDBs, so you probably shouldn't be implementing a trigger in the manner discussed in this section. Prior to 12.1.0.2, when the CDB is started, all PDBs remain in mounted mode. There is no default mechanism to automatically start them when the CDB is started. The way to achieve this is to use a system trigger on the CDB to start some or all of the PDBs.

• Question 264:

  You want to create a guaranteed restore point for your database by executing the command:

  SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;

  Identify two prerequisites for the successful execution of this command.

  A. The database must be running in archivelog mode.
  B. Flashback Database must be enabled.
  C. Fast Recovery Area must be enabled.
  D. The recyclebin must be enabled for the database.
  E. Undo retention guarantee must be enabled.
  F. A database backup must be taken.
  A. The database must be running in archivelog mode.
  C. Fast Recovery Area must be enabled.

  ---

  SQL> select flashback_on from v$database; FLASHBACK_ON

  NO SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE; Restore point created. SQL> archive log list; Database log mode Archive Mode Automatic archival Enabled Archive destination USE_DB_RECOVERY_FILE_DEST Oldest online log sequence 113 Next log sequence to archive 115 Current log sequence 115 SQL> Reference: http://docs.oracle.com/cd/B19306_01/backup.102/b14192/rpfbdb002.htm