Question 96
One of your databases is in ARRCHIVELOG mode.
You back up the database by using RMAN with a recovery catalog.
One data file and all the control files are corrupt due to corruption in the storage array.
Examine this list of possible actions to recover the database:
1. Restore the control files by using the RESTORE CONTROLFILE command.
2. Mount the database.
3. Restore the data files by using the RESTORE DATABASE command.
4. Open the database with the RESETLOGS option.
5. Recover the data files by using the RECOVER USING BACKUP CONTROLFILE command.
6. Start the target database instance in NOMOUNT state.
7. Connect to the target database and the recovery catalog database instance.
8. Restore the SPFILE by using the RESTORE SPFILE command
9. Restore the corrupt data file.
10. Recover the restored data file.
Identify the minimum required steps in the correct order.
You back up the database by using RMAN with a recovery catalog.
One data file and all the control files are corrupt due to corruption in the storage array.
Examine this list of possible actions to recover the database:
1. Restore the control files by using the RESTORE CONTROLFILE command.
2. Mount the database.
3. Restore the data files by using the RESTORE DATABASE command.
4. Open the database with the RESETLOGS option.
5. Recover the data files by using the RECOVER USING BACKUP CONTROLFILE command.
6. Start the target database instance in NOMOUNT state.
7. Connect to the target database and the recovery catalog database instance.
8. Restore the SPFILE by using the RESTORE SPFILE command
9. Restore the corrupt data file.
10. Recover the restored data file.
Identify the minimum required steps in the correct order.
Question 97
You use RMAN to take regular backups for your database.
Examine the RMAN commands:
RMAN> CROSSCHECK BACKUP;
RMAN> DELETE EXPITED BACKUP;
Which statement is true?
Examine the RMAN commands:
RMAN> CROSSCHECK BACKUP;
RMAN> DELETE EXPITED BACKUP;
Which statement is true?
Question 98
You execute the RMAN commands:
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2;
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/disk1/%U;
RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/disk2/%U;
RMAN> BACKUP DATABASE;
Which statement is true about the backup set created by the BACKUPcommand?
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO disk;
RMAN> CONFIGURE DEVICE TYPE disk PARALLELISM 2;
RMAN> CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT '/disk1/%U;
RMAN> CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT '/disk2/%U;
RMAN> BACKUP DATABASE;
Which statement is true about the backup set created by the BACKUPcommand?
Question 99
You want to export the pluggable database (PDB) hr pdb1 from the multitenant container database (CDB)CDB1 and import it into the cdb2 CDB as the emp_pdb1 PDB.
Examine the list of possible steps required to perform the task:
1.Create a PDB named emp_pdb1.
2.Export the hr_pdb1 PDB by using the full clause.
3.Open the emp_pdb1 PDB.
4.Mount the emp_pdb1 PDB.
5.Synchronize the emp_pdb1 PDB in restricted mode.
6.Copy the dump file to the Data Pump directory.
7.Create a Data Pump directory in the emp_pdb1 PDB.
8.Import data into emp_pdb1 with the full and remap clauses.
9.Createthe same tablespaces in emp_pdb1 as in hr_pdb1 for new local user objects.
Identify the required steps in the correct order.
Examine the list of possible steps required to perform the task:
1.Create a PDB named emp_pdb1.
2.Export the hr_pdb1 PDB by using the full clause.
3.Open the emp_pdb1 PDB.
4.Mount the emp_pdb1 PDB.
5.Synchronize the emp_pdb1 PDB in restricted mode.
6.Copy the dump file to the Data Pump directory.
7.Create a Data Pump directory in the emp_pdb1 PDB.
8.Import data into emp_pdb1 with the full and remap clauses.
9.Createthe same tablespaces in emp_pdb1 as in hr_pdb1 for new local user objects.
Identify the required steps in the correct order.
Question 100
The CATDB12Cdatabase contains an Oracle Database 12c catalog schema owned by the RC12Cuser.
The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user.
A database with DBID=1423241is registered in the CATDB11catalog. Both the recovery catalog databases are open.
In the CATDB12cdatabase, you execute the commands:

What is the outcome of the import?
The CATDB11 database contains an Oracle Database l1g catalog schema owned by the RC11 user.
A database with DBID=1423241is registered in the CATDB11catalog. Both the recovery catalog databases are open.
In the CATDB12cdatabase, you execute the commands:

What is the outcome of the import?