The latest version of the updated leads4pass 1Z0-063 dumps with 1Z0-063 free exam questions helps you easily pass the challenging Oracle 1Z0-063 exam.
leads4pass has completed the 1Z0-063 dumps https://www.leads4pass.com/1z0-063.html latest version update, providing you with the latest 276+ exam question and answer questions (PDF or VCE), all of which match the exam content and ensure that you can pass.
Not only that but leads4pass shares the latest 1Z0-063 free exam questions with you to study.
Check the following 1Z0-063 free dumps or 1Z0-063 exam questions here.
Question 1:
Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). (Choose three.)
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 the target database registered in the recovery catalog
E. to automatically delete obsolete backups after a specified period of time
Correct Answer: ACD
Question 2:
Which two statements are true regarding Oracle Data Pump? (Choose two.)
A. EXPDP and IMPDP are the client components of Oracle Data Pump.
B. DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
C. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
D. Oracle Data Pump imports can be done from the export files generated in the Original Export Utility.
E. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.
Correct Answer: AB
Reference: http://docs.oracle.com/cd/B19306_01/server.102/b14215/dp_overview.htm
Question 3:
Which two statements are true about making RMAN image copies of a database? (Choose two.)
A. They can only be written to disk.
B. They can be made only when the database is running in NOARCHIVELOG mode.
C. They can be made only when the database is in the MOUNT state.
D. They consist of all used and unused blocks in the data files.
E. They can be made only when the database is running in ARCHIVELOG mode.
Correct Answer: AD
An image copy can be written only to disk.
An image copy is the same as data file. The disadvantage of image copy backup mode is that it occupies much space and does not skip unused data blocks. References: http://www.dba-oracle.com/t_rman_10_image_copies.htm
Question 4:
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
Question 5:
You issue the command:
SQL> ALTER DATABASE BACKUP CONTROL FILE TO TRACE;
Which statement is true about the command?
A. It creates a copy of the control file and stores it in the location specified in the diagnostic_dest initialization parameter.
B. It creates a file that contains the SQL statement, which is required to re-create the control file.
C. It updates the alert log file with the location and contents of the control file.
D. It creates a binary backup of the control file.
Correct Answer: B
Question 6:
Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):
Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1 role?
A. The command fails and gives an error because object privileges cannot be granted to a common user.
B. The command fails because the container is not set to current.
C. The command succeeds and the common user c##admin can create a session and query the DBA_users view in cdb$root and all the PDBs.
D. The command succeeds and the common user c##admin can create a session in cdb$root and all the PDBs, but can only query the dba_users view in cdb$root.
E. The command succeeds and the common user c##admin can create a session and query the DBA_users view only in cdb$root.
Correct Answer: C
Question 7:
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 8:
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 9:
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 CATALOG option and use the SET NEWNAME command to change the location.
C. Restore the control file from the backup by using the CATALOG 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 THE DATABASE
References: https://docs.oracle.com/database/121/BRADV/rcmadvre.htm
Question 10:
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 the source database to the 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 need to transport using the DataPump export utility.
Step 3 (4): Once the metadata export is generated on the source database for all the tablespaces that need 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 11:
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 locally 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 clause 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 12:
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 the 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 the 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 13:
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 is 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 a 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. The 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 14:
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 the disk is not specified in the BACKUP command.
B. It backs up two copies of 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 log.
Correct Answer: D
Question 15:
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.
Correct Answer: A
In the current release, Data Recovery Advisor can only be used to diagnose and repair data corruptions in
non-CDBs and the root of a multitenant container database (CDB). Data Recovery Advisor is not
supported for pluggable databases (PDBs).
Note: You can run the LIST FAILURE command to show all known failures.
References: https://docs.oracle.com/database/121/BRADV/rcmrepai.htm
The leads4pass 1Z0-063 dumps have been validated as an effective tool for passing the Oracle 1Z0-063 exam. And it’s already updated to the latest version, feel free to with 1Z0-063 dumps https://www.leads4pass.com/1z0-063.html Updated.
