Oracle 1Z0-063 Online Practice Questions and Exam Preparation

Oracle 1Z0-063 Online Questions & Answers

• Question 81:

  Your database is running in ARCHIVELOG mode. You use RMAN to take image copies and you update these copies incrementally every six hours. After a regular maintenance task, when you attempt to restart the instance, it halts in MOUNT

  state with an error indicating that one of the data files belonging to the EXAMPLE tablespace is lost.

  You want to recover the data file as quickly as possible while maximizing availability for the database.

  Examine the possible steps involved in the recovery process:

  1.

  Mount the database.

  2.

  Take the data file offline.

  3.

  Bring the tablespace online.

  4.

  Use the RMAN SWITCH command to switch to the image copy.

  5.

  Recover the tablespace.

  6.

  Open the database.

  7.

  Use the RMAN RESTORE command to switch to the image copy. Identify the correct sequence of the required steps.

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

• Question 82:

  Which two statements are true about encrypted backups performed by using RMAN? (Choose two.)

  A. Transparent encryption of backups uses an encryption wallet.
  B. A database uses the same encryption key for every encrypted backup.
  C. A password encryption of backups uses the password while creating and restoring backups.
  D. Image copy backups can be created by using password encryption.
  E. Encrypted backups can only be written to disk.
  A. Transparent encryption of backups uses an encryption wallet.
  C. A password encryption of backups uses the password while creating and restoring backups.

• Question 83:

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

  SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;

  Identify two prerequisites for the successful execution of this command. (Choose two.)

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

• Question 84:

  Your database is running in noarchivelog mode. One of the data files belonging to the system tablespace is corrupted. You notice that all online redo logs have been overwritten since the last backup. Which method would you use to recover the data file?

  A. Shut down the instance if not already shut down, restore all data files belonging to the system tablespace from the last backup, and restart the instance.
  B. Shut down the instance if not already shut down, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the instance.
  C. Shut down the instance if not already shut down, restore all data files for the entire database from the last backup, and restart the instance.
  D. Mount the database, restore all data files belonging to the system tablespace from the last backup, and open the database.
  C. Shut down the instance if not already shut down, restore all data files for the entire database from the last backup, and restart the instance.

• Question 85:

  Which three statements are true about unplugging a pluggable database (PDB)? (Choose three.)

  A. The PDB must be open in read only mode.
  B. The PDB must be dosed.
  C. The unplugged PDB becomes a non-CDB.
  D. The unplugged PDB can be plugged into the same multitenant container database (CDB)
  E. The unplugged PDB can be plugged into another CDB.
  F. The PDB data files are automatically removed from disk.
  B. The PDB must be dosed.
  D. The unplugged PDB can be plugged into the same multitenant container database (CDB)
  E. The unplugged PDB can be plugged into another CDB.

• Question 86:

  You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.

  You have set the db_smart_flash_file parameter:

  DB_FLASH_CACHE_FILE= ` /dev/f lash_device_1`,` /dev/f lash_device_2`

  How should the D3_flash_cache_size be configured to use both devices?

  A. Set DB_FLASH_CACHE_SIZE=64G.
  B. Set D3_FLASH_CACHE_SIZE=64G, 64G.
  C. Set D3_FLASK_CACKE_SI2E=128G.
  D. db_flash_cache_SI2E is automatically configured by the instance at startup.
  B. Set D3_FLASH_CACHE_SIZE=64G, 64G.

• Question 87:

  Which two statements are true when row-archival management is enabled? (Choose two.)

  A. Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.
  B. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.
  C. The row archival visibility session parameter defaults to all rows.
  D. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.
  E. The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.
  B. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.
  D. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.

• Question 88:

  You want to move your existing recovery catalog to another database.

  Examine the steps:

  1) Export the catalog data by using the Data Pump Export utility in the source database.

  2) Create a recovery catalog user and grant the necessary privileges in the target database.

  3) Create a recovery catalog by using the CREATE CATALOG command.

  4) Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target database.

  5) Import the source recovery catalog schema by using the RMAN IMPORT CATALOG command.

  6) Connect to the destination database.

  7) Connect as CATALOG to the destination recovery catalog schema.

  Identify the option with the correct sequence for moving the recovery catalog.

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

• Question 89:

  You are administering a multitenant container database (CDB) that contains multiple pluggable databases (PDBs). RMAN is connected to CDB$ROOT.

  Examine the command:

  RMAN> LIST FAILURE;

  Which statement is true about this command?

  A. It lists failures only for the CDB root database.
  B. It lists failures for a PDB only when RMAN is connected to a recovery catalog.
  C. It lists failures for the CDB and all the PDBs in this CDB.
  D. It lists failures only if RMAN is connected to a PDB.
  A. It lists failures only for the CDB root database.

• Question 90:

  In CDB$ROOT of your multitenant container database (CDB), you create a common user, C##A_ADMIN, and then execute the command:

  

  Which statement is true?

  A. The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root database.
  B. The command executes successfully, enabling the C##A_ADMIN user to create tablespaces in the root database, as well as in the pluggable databases (PDBs).
  C. The command fails because the CONTAINER clause is not used.
  D. The command fails because system privileges cannot be granted to a common user.
  A. The command executes successfully, enabling the C##A_ADMIN user to create a tablespace only in the root database.