Online Access Free 1z0-063 Practice Test

You execute the RMAN commands:
RMAN> BACKUP VALIDATE DATABASE;
RMAN> RECOVER CORRUPTION LIST;
Which task is performed by these commands?

• A.Only those data files that have corrupted blocks are backed up.
• B.Corrupted blocks, if any, are repaired in the backup created.
• C.Corrupted blocks in the data files are checked and repaired before performing the database backup.
• D.The database is checked for physically corrupt blocks and any corrupted blocks are repaired.

Which two statements are true about roles in multitenant container databases (CDBs)? (Choose two.)

• A.Local roles can be granted to local and common users.
• B.A local role can be assigned to a common role in a PDB.
• C.A common role can be granted only system privileges.
• D.A common role can be granted only to a common user.
• E.The root container can have both local and common roles.
• F.A common user can create a local role by default in any pluggable database (PDB) that is plugged in to a CDB.

Your multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode contains two pluggable databases (PDBs), PDB2_1 and PDB2_2, both of which are open. RMAN is connected to the target pluggable database PDB2_1.
RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
Which statement is true about the execution of this command to back up the database?

• A.All data files belonging to PDB2_1 are backed up and all archive log files are deleted.
• B.Only the data files belonging to pdb2_1 are backed up.
• C.All data files belonging to PDB2_1 are backed up along with the archive log files.
• D.This command gives an error because archive log files can be backed up only when RMAN is connected to the root container database.

You issued these commands for one of your databases:
RMAN> BACKUP INCREMENTAL LEVEL 0 DATABASE;
RMAN> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING
FILE '/mydir/rman_change_track.f';
RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which two are true? (Choose two.)

• A.Future cumulative incremental level 1 database backups will reference the block change tracking file.
• B.The block change tracking file will be updated automatically after creation to refer to modified blocks contained in the incremental level 0 database backup.
• C.Future incremental level 0 database backups will reference the block change tracking file.
• D.The cumulative incremental level 1 database backup fails.
• E.The cumulative incremental level 1 database backup ignores the block change tracking file.

As part of a manual upgrade process, after installing the software for Oracle Database 12c and preparing the new Oracle home, you shut down the existing single-instance database.
Which step should you perform next to start the upgrade of the database?

• A.Start up the database instance by using the STARTUP UPGRADE command, which opens the existing database, and then performs additional upgrade operations.
• B.Start up the database instance by using the new location of the server parameter file and run the cact1.pl script from the new Oracle home to use parallel upgrade options that reduce down time.
• C.Start up the database instance by using the new location of the server parameter file and run the catuppst.sqi script to generate informational messages and log files during the upgrade.
• D.Start up the database instance by using the STARTUP UPGRADE command and gather fixed object statistics to minimize the time needed for recompilation.