Oracle Oracle Certifications 1Z0-063 Questions & Answers

• Question 261:

  You are connected to a recovery catalog and target database. You execute the command:

  RMAN> CATALOG START WITH `/disk1/backups';

  Which statement is true?

  A. Only valid data file copies, existing in the /disk1/backups directory, are cataloged.

  B. Only valid backup pieces and archived logs, existing in the /disk1/backups directory, are cataloged.

  C. It lists all the data file copies, backup pieces, and achieved logs cataloged in the recovery catalog in the /disk1/backups directory and its subdirectories.

  D. It lists and catalogs all valid data file copies, backup pieces, and archived logs that exist in all directory paths with the prefix /disk1/backups and their subdirectories.

  Correct Answer: D

  If you have data file copies, backup pieces, or archived logs on disk, then you can catalog them in the

  recovery catalog with the CATALOG command.

  The following command catalogs all files in all of these directories, because /disk1/backups is a prefix for

  the paths for all of these directories:

  CATALOG START WITH '/disk1/backups';

  To catalog only backups in the /disk1/backups directory, the correct command is as follows:

  CATALOG START WITH '/disk1/backups/';

  References: https://docs.oracle.com/database/121/BRADV/rcmcatdb.htm

• Question 262:

  You execute the commands to configure settings in RMAN:

  

  Then, you issue the following command to take a backup:

  

  Which statement is true about the execution of these commands?

  A. The backup terminates because the backup destination for disk is not specified in the BACKUP command.

  B. It backs up two copies each of the data files to disk and media, and two copies of archived logs to media.

  C. It backup up the data files and archived logs, making one copy of each data file and archived log on disk and media.

  D. It backs up the data files and archived logs to media, making two copies of each data file and archived logs.

  Correct Answer: D

• Question 263:

  Which two statements are true about setting the FAST_START_MTTR_TARGET parameter to a nonzero value? (Choose two.)

  A. The MTTR advisor is enabled only if the value is greater than the default value.

  B. Automatic checkpoint tuning is enabled.

  C. The value of the LOG_CHECKPOINT_INTERVAL parameter overrides the value of the FAST_START_MTTR_TARGET parameter.

  D. The time taken to recover an instance after a crash is always exactly the same as the value set for the FAST_START_MTTR_TARGET parameter.

  Correct Answer: AC

  The FAST_START_MTTR_TARGET initialization parameter lets you specify in seconds the expected

  "mean time to recover" (MTTR), which is the expected amount of time Oracle takes to perform crash or

  instance recovery for a single instance.

  To enable MTTR advisory, set the initialization parameter FAST_START_MTTR_TARGET to a nonzero

  value. If FAST_START_MTTR_TARGET is not specified, then MTTR advisory will be OFF.

  When specified, FAST_START_MTTR_TARGET is overridden by LOG_CHECKPOINT_INTERVAL.

  Note: The default value is 0. Range of values is 0 to 3600 seconds.

  References: https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams079.htm#REFRN10058

  https://docs.oracle.com/cd/A97630_01/server.920/a96533/instreco.htm

• Question 264:

  Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests? (Choose three.)

  A. RMAN preauthorization on the host

  B. OSB encryption for data in transport and on tape

  C. matching the OS user identity of the Oracle instance associated with the database username

  D. assigned to a class with rights to back up or restore Oracle database

  E. scheduling of the RMAN backup to occur automatically at user-defined intervals

  F. assigned to a class with rights to browse all directories and catalogs

  Correct Answer: ADF

  A: Performing Oracle database backups using RMAN requires RMAN user preauthorization within OSB

  D: The preauthorized Oracle Secure Backup user must also be assigned to an Oracle Secure Backup

  class possessing the following rights:

  access Oracle backups (set to owner, class, or all)

  perform Oracle backups and restores

  F: The preauthorized Oracle Secure Backup user must be mapped to operating system privileges to

  access the files to be backed up or restored. the preauthorized Oracle Secure Backup user can perform

  RMAN operations only on the host where it has access to files.

  References: https://docs.oracle.com/cd/E16926_01/doc.121/e16564/osb_rman_backup.htm#OBADM199

• Question 265:

  In which three situations must you use a recovery catalog? (Choose three.)

  A. when you want to store RMAN global scripts that can be used across multiple databases

  B. when you want to restrict the amount of space used by backups

  C. when you want to perform incremental backups by using a block change tracking file

  D. when you want to list data files that were in a target database at a given time by using the AT clause with the REPORT SCHEMA command

  E. when you want to maintain backup metadata longer than the period specified by the CONTROL_FILE_RECORD_KEEP_TIME parameter

  Correct Answer: ADE

  A: Some RMAN features function only when you use a recovery catalog. For example, you can store RMAN scripts in a recovery catalog. The chief advantage of a stored script is that it is available to any RMAN client that can connect to the target database and recovery catalog. Command files are only available if the RMAN client has access to the file system on which they are stored.

  A local stored script is associated with the target database to which RMAN is connected when the script is created, and can only be executed when you are connected to this target database. A global stored script can be run against any database registered in the recovery catalog.

  D: If you use a recovery catalog, then you can use the atClause to specify a past time, SCN, or log sequence number, as shown in these examples of the command:

  RMAN> REPORT SCHEMA AT TIME 'SYSDATE-14'; # schema 14 days ago RMAN> REPORT SCHEMA AT SCN 1000; # schema at scn 1000 RMAN> REPORT SCHEMA AT SEQUENCE 100 THREAD 1; # schema at sequence 100 RMAN> REPORT SCHEMA FOR DB_UNIQUE_NAME standby1;

  E: The CONTROL_FILE_RECORD_KEEP_TIME initialization parameter determines the minimum number of days that records are retained in the control file before they are candidates for being overwritten. Thus, you must ensure that you resynchronize the recovery catalog with the control file records before these records are erased.

  References: https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmcatdb.htm

  https://docs.oracle.com/database/121/BRADV/rcmreprt.htm#BRADV90911

• Question 266:

  Examine the list of possible steps to transport a tablespace across platforms that have the same compatibility level, character sets, and endian format:

  1.

  Make the tablespace read-only at the source database.

  2.

  Export metadata from the source database.

  3.

  Import metadata into the target database.

  4.

  Transfer the dump file and data files to the target machine.

  5.

  Convert data files by using Recovery Manager (RMAN).

  6.

  Make the tablespace read-write at the target database.

  Identify the required steps in the correct order.

  A. 2, 4, and 3

  B. 2, 4, 3, and 5

  C. 1, 5, 2, 4, 3, and 6

  D. 1, 2, 4, 3, and 6

  Correct Answer: D

  Step 1 (1) : To copy tablespaces from one database to another using transportable tablespace, the source tablespaces are first kept in READ-ONLY mode (to ensure data consistency). Once the tablespaces are in READ-ONLY mode, the actual datafiles belonging to the source tablespaces are copied from source database to target database (using any available methods like scp, sftp, rcp, etc).

  Step 2 (2): Once the tablespace is kept in READ-ONLY mode, we need to generate the metadata export of the tablespaces that needs to transported using the DataPump export utility.

  Step 3 (4): Once the metadata export is generated on the source database for all the tablespaces that needs to be transported, we need to copy the Export Dump file as well as all the datafiles belonging to the tablespaces to be transported to the target database server.

  References: http://www.oraclebuffer.com/oracle/migrate-oracle-database-using-transportable-tablespace/

• Question 267:

  Your database is running on the host OUSERVER. You back up your database regularly using RMAN and the backups are cataloged in a recovery catalog. For testing purposes, you want to replicate your database to another host, OUSERVER1, with the same directory structure. So, you copy the backups to the new host.

  What must you do to make the database operational in OUSERVER1?

  A. Restore the control file from the backup by using the CATALOG option, restore the data files by using the SET NEWNAME command, and recover the data files.

  B. Restore the data files by using the NOCATALOG option and use the SET NEWNAME command to change the location.

  C. Restore the control file from the backup by using the NOCATALOG option, and then restore and recover the data files.

  D. Restore the data files from the backup by using the recovery catalog, use the SWITCH command to change the location, and recover the data files.

  Correct Answer: A

  Catalog any backups not recorded in the repository with the CATALOG command.

  Restore the data files to their original locations. If volume names have changed, then run SET NEWNAME commands before the restore operation and perform a switch after the restore operation to update the control file with the new locations for the data files, as shown in the following example.

  Note: One way to name duplicate data files is to use the SET NEWNAME command before executing the DUPLICATE command. RMAN supports the following commands, listed in order of precedence:

  1.

  SET NEWNAME FOR DATAFILE and SET NEWNAME FOR TEMPFILE

  2.

  SET NEWNAME FOR TABLESPACE

  3.

  SET NEWNAME FOR DATABASE

  References: https://docs.oracle.com/database/121/BRADV/rcmadvre.htm

• Question 268:

  You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES:

  

  Which two statements are true? (Choose two.)

  A. The root and seed databases are included in the duplication.

  B. Only the SALES PDB is duplicated as the non-CDB CDBDUP.

  C. A backup of the SALES PDB must exist before the execution of the command.

  D. An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASE set to TRUE.

  E. RMAN must be connected to a recovery catalog for the execution of the command.

  Correct Answer: AD

  D: When duplicating a whole CDB or one more PDBs:

  You must create the auxiliary instance as a CDB. To do so, start the instance with the following declaration in the initialization parameter file: enable_pluggable_database=TRUE

  A: To duplicate PDBs, you must create the auxiliary instance as a CDB. To do so, start the instance with

  the declaration enable_pluggable_database=TRUE in the initialization parameter file. When you duplicate one or more PDBs, RMAN also duplicates the root (CDB$ROOT) and the seed database (PDB$SEED). The resulting duplicate database is a fully functional CDB that contains the root, the seed database, and the duplicated PDBs.

  References: https://docs.oracle.com/database/121/BRADV/rcmdupdb.htm

• Question 269:

  You create a new database by using the CREATE DATABASE command in SQL *Plus, with the ENABLE PLUGGABLE DATABASE clause specified.

  Which statement is true about the database that is created?

  A. It is created as a container database (CDB) with CDB$ROOT, PDB$SEED, and a pluggable database (PDB).

  B. It is created as a non-CDB that becomes a CDB after the first PDB is plugged in.

  C. It is created as a PDB that must be plugged into an existing CDB.

  D. It is created as a CDB with the CDB$ROOT and PDB$SEED databases.

  Correct Answer: D

  The CREATE DATABASE command with the ENABLE PLUGGABLE DATABASE clause indicates that a CDB is being created. The CDB will contain a root (CDB$ROOT) and a seed (PDB$SEED).

  References: https://docs.oracle.com/database/121/SQLRF/statements_5005.htm

• Question 270:

  The CATDB12C database contains an Oracle Database 12c catalog schema owned by the RC12C user. The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user.

  A database with DBID=1423241 is registered in the CATDB11 catalog. Both the recovery catalog databases are open.

  In the CATDB12c database, you execute the commands:

  

  What is the outcome of the import?

  A. It fails because the target database and recovery catalog database are of different versions.

  B. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RC12C catalog are automatically renamed.

  C. It succeeds but the database is not automatically registered in the RC12c catalog.

  D. It fails because RMAN is not connected to the target database with DBID=1423241.

  Correct Answer: A