Examine the RMAN command:RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;Which type of encryption is used for the backup performed by using this command?
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 command9. Restore the corrupt data file.10. Recover the restored data file.Identify the minimum required steps in the correct order.
The following parameters are set for your Oracle 12c database instance:OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUEYou want to manage the SQL plan evolution task manually. Examine the following steps:1.Set the evolve task parameters.2.Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function.3.Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.4.Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.5.Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.Identify the correct sequence of steps.
Flashback Data Archive has been configured to retain data on all transactions that modify a table for a period of four years.Three years later, it is decided to change the retention period.You execute this command:SQL> ALTER FLASHBACK ARCHIVE fda1 MODIFY RETENSION RETENTION 2 YEAR;Which is true?
You created a database with DBCA by using one of the Oracle supplied templates.Which is the default permanent tablespace for all users except DBSNMP and OUTLN?
Which two statements are true about scheduling operations in a pluggable database (PDB)?
