Question 6 of 176
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.
    Correct Answer: D

    To recover a table from an RMAN backup to a specified point in time due to logical corruption, you need to determine the backup containing the table, issue the recover table RMAN command with the appropriate parameters, and then create a Data Pump export dump file for the recovered table. Step 1 is necessary to identify the correct backup, step 2 involves using the RMAN recover table command with the auxiliary destination and specified recovery time, and step 4 allows for the creation of the dump file on the target database. Importing the Data Pump export dump file into the auxiliary instance (step 3) is not required in this process. Hence, the correct sequence is 1, 2, 4.

Question 7 of 176
Examine the command:
SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;
In which two scenarios is this command required?
    Correct Answer: A, D

    The command 'RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;' is used in scenarios where the current state of the control file is unreliable or missing, requiring the use of a backup control file to proceed with recovery. One common scenario is when the current online redo log file is missing, making it necessary to use a backup control file (Option A). Another scenario is when the database backup is older than the control file backup, necessitating this command to ensure consistency during the recovery process (Option D).

Question 8 of 176
Which two are prerequisites for setting up Flashback Data Archive?
    Correct Answer: D, F

    To set up Flashback Data Archive, Automatic Undo Management must be enabled because it ensures that undo data is managed automatically without user intervention, which is necessary for Flashback operations. Additionally, the tablespace in which the Flashback Data Archive is created should have Automatic Segment Space Management (ASSM) enabled because ASSM provides efficient space management and is required for the storage and management of historical data in Flashback Data Archives.

Question 9 of 176
The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to /u01/app/oracle/product/12.1.0/db 1.
You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database.

NAMETYPEVALUE -
-------------------------------------------- ------------------- ------------------------------------------------ audit_file_deststring/u01/app/oracle/admin/eml2rep/adump background_dump_deststring core_dump_deststring db_create_file_deststring db_recovery_file_deststring/u01/app/oracle/fast_recovery_area diagnostic_deststring
What is the location of the ADR base?
    Correct Answer: C

Question 10 of 176
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.Create the same tablespaces in emp_pdb1 as in hr_pdb1 for new local user objects.
Identify the required steps in the correct order.
    Correct Answer: C