Note! Following 1z0-063 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

1z0-063 Exam Dumps - Oracle Database 12c: Advanced Administration

Go to page:

Question # 9

An incremental level 1 backup is taken every week day. A new tablespace is created before the backup is performed.

You execute:

RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE;

Which two are true? (Choose two.)

It returns an error because there is no existing level 0 backup for the new data files.

It creates a level 1 incremental backup set containing all the previously existing data files.

It creates a level 0 backup set containing all the new data files.

It creates image copies of all the new data files.

It creates a level 1 incremental backup set containing all the new data files.

Full Access

Question # 10

Examine this command:

RMAN> BACKUP VALIDATE DATABASE;

Which three statements are true? (Choose three.)

The command checks for blocks containing all zeros.

The command checks for blocks containing an invalid checksum.

The command checks for blocks containing a corrupt block header.

The command checks for blocks that contain invalid column lengths.

The command backs up the database regardless of the state of the blocks.

The command backs up the database only if all blocks are valid.

Full Access

Question # 11

Identify three reasons for using a recovery catalog with Recovery Manager (RMAN). (Choose three.)

to report on the database schema at an earlier point in time

to store backups that would cause the controlfile to become too large

to allow database duplication without a connection to the target instance

to allow database duplication without a connection to the auxiliary instance

to store backup metadata that would cause the controlfile to become too large

Full Access

Question # 12

Because of logical corruption of data in a table, you want to recover the table from an RMAN backup to a specified point in time.

Examine the steps to recover this table from an RMAN backup:

1. Determine which backup contains the table that needs to be recovered.

2. Issue the RECOVER TABLE RMAN command with an auxiliary destination defined and the point in time specified.

3. Import the Data Pump export dump file into the auxiliary instance.

4. Create a Data Pump export dump file that contains the recovered table on a target database.

Identify the required steps in the correct order.

1, 4, 3

1, 2

1, 4, 3, 2

1, 2, 4

Full Access

Question # 13

You issue the RMAN commands:

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;

RMAN> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COPY;

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

RMAN> BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

Which three tasks are performed by the BACKUP DATABASE command? (Choose three.)

switching the online redo log

backing up all data files as image copies and archive logs, and deleting those archive logs

backing up only the used blocks in the data files

backing up all used and unused blocks in the data files

backing up all archived logs and marking them as obsolete

Full Access

Question # 14

Your multitenant container database (CDB) CDB1 that is running in ARCHIVELOG mode contains two pluggable databases (PDBs), PDB2_1 and PDB2_2. RMAN is connected to the target database PDB2_1.

Examine the command executed to back up PDB2_1:

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

Which statement is true about the execution of this command?

It fails because archive log files cannot be backed up using a connection to a PDB.

It succeeds but only the data files belonging to the PDB2_1 pluggable database are backed up.

It succeeds and all data files belonging to PDB2_1 are backed up along with the archive log files.

It fails because the PLUGGABLE clause is missing.

Full Access

Question # 15

Your multitenant container database (CDB) contains multiple pluggable databases (PDBs). You execute the command to create a common user:

SQL> CREATE USER c##a_admin

IDENTIFIED BY password

DEFAULT TABLESPACE users

QUOTA 100M ON users

TEMPORARY TABLESPACE temp;

Which statement is true about the execution of the command?

The common user is created in the CDB and all the PDBs, and uses the USERS and TEMP tablespaces of the CDB to store schema objects.

The command succeeds only if all the PDBs have the USERS and TEMP tablespaces.

The command gives an error because the CONTAINER=ALL clause is missing.

The command succeeds and sets the default permanent tablespace of a PDB as the default tablespace for the C##A_ADMIN user if the USERS tablespace does not exist in that PDB.

Full Access

Question # 16

Which two statements are true regarding Oracle Data Pump? (Choose two.)

EXPDP and IMPDP are the client components of Oracle Data Pump.

DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.

Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.

Oracle Data Pump imports can be done from the export files generated in the Original Export Utility.

EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

Full Access