1Z0-063 Exam Dumps 2023 | Easy Way To Get Exam Success
Knowing that 1Z0-063 exam dumps are the easiest way to pass the Oracle 1Z0-063 exam, we’ve updated the latest 1Z0-063 exam dumps 2023 to help you easily pass the Oracle Database 12c: Advanced Administration exam.
PassITDump 1Z0-063 exam dumps 2023 updates the study materials that meet the exam requirements with 276 exam questions and answers that can really help you pass the exam.
Questions and answers from 1Z0-063 free dumps are 100% free and guaranteed. See our full 1Z0-063 dumps if you want to get a further understanding of the materials.
You can first experience the 1Z0-063 free dumps questions below
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 target databasesregistered 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 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 datafiles. 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:
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 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 6:
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 7:
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 8:
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 9:
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 10:
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 11:
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 12:
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
Question 13:
Which three methods can be used to create a pluggable database (PDB) in an existing multitenant container database (CDB)? (Choose three.)
A. Use PDB$SEED for creating a PDB.
B. Use the DBMS_PDB package to plug a non-CDB into an existing CDB.
C. Clone an existing PDB.
D. Use Enterprise Manager Database Express to create a PDB in an existing CDB.
E. Use the DBMS_PDB package to plug a pre-Oracle 12c database into an existing CDB.
Correct Answer: BCD
Question 14:
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 15:
A database instance uses an SPFILE. Examine the parameter: You plan to multiplex the control file to a new location, parallelization for the backup set./u01/app/oracle/oradata/cdb1/disk3/control03.ctl/.
Examine the possible steps that are in random order:
1. Shut down the database instance.
2.Issue ALTER SYSTEM SET CONTROL_FILES= `/u01/app/oracle/oradata/cdb1/disk1/control01.ctl, /u01/
app/oracle/oradata/cdb1/disk2/control02, ctl, /u01/app/oracle/oradata/cdb1/disk3/control03.ctl\’
SCOPE=SPFILE;.
3.
Issue ALTER SYSTEM SET CONTROL_FILES=
`/u01/app/oracle/oradata/cdb1/disk1/control01.ctl, /u01/app/oracle/oradata/cdb1/disk2/control02.ctl, /u01/
app/oracle/oradata/cdb1/disk3/control03.ctl\’;.
4.
Copy the control file from the existing location to `/u01/app/oracle/oradata/cdb1/disk3/control03.ctl\’.
5.
Mount the database.
6.
Open the database.
Identify the required steps in the correct order to accomplish the task.
A. 3, 4
B. 2, 1, 4, 6
C. 3, 1, 4, 6
D. 1, 5, 2, 4, 6
E. 2, 6
Correct Answer: B