A.The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.

B.The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.

C.The restore point is a label for the system change number (SCN) before the archival backup was taken.

D.All archive logs created after this backup are kept for two years.

E.The SPFILEis included in the self-contaied archival backup.

F.The control file is included in the self-contained archival backup.

A.It obeys all hints.

B.It considers the filters in WHERE clauses when generating execution plans for SQL statements.

C.It can re-optimize execution plans after previous executions detect suboptimal plans.

D.It considers object statistics when generating execution plans for SQL statements.

E.It updates stale object statistics in the Data Dictionary.

F.It can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated.

A.All files in any previous FRA that have not yet been backed up, are backed up.

B.All Oracle recovery files normally written to the FRA and which have not yet been backed, are backed up.

C.All Oracle recovery files normally written to the FRA and which have been backed up already to the current FRA, are backed up.

D.All files in any previous FRA that have been backed up already, are backed up.

E.All Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up.

F.All files in the current fast recovery area (FRA) that have not yet been backed up, are backed up. C)All files in the current FRA that have been backed up already, are backed up.

A.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using RMAN while connected to PDB1.

B.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using SQL while connected to PDB1.

C.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using SQL while connected to CDB$ROOT.

D.Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1by using RMAN while connected to CDB$ROOT.

E.This cannot be done due to the lack of a clean restore point.

A.The Oracle Database time model should be used to find the database and instance areas most in need of tuning.

B.Tuning activities should stop once the user is satisfied with performance.

C.The alert log should be used to find the database and instance areas most in need of tuning.

D.Tuning activities should stop once agreed service levels for performance have been met.

E.SQL statements should always be tuned before tuning any file systems.

F.The database instance memory should always be tuned before tuning any file systems.