Online Access Free 1Z0-083 Practice Test

Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)?
(Choose three.)

• A.temporary tablespaces
• B.SYSAUX tablespaces
• C.undo tablespaces
• D.the data dictionary in CDB$ROOT
• E.the log writer process (LGWR)
• F.the Process Monitor Process (PMON)

Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)

• A.CDB$ROOT and PDB$SEED are automatically duplicated.
• B.A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the PDB to duplicate it.
• C.The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.
• D.Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.
• E.All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.

Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and later releases? (Choose two.)

• A.A PDB snapshot is always a full copy of the source PDB.
• B.A PDB snapshot depends on a storage snapshot which can be stored on any file system.
• C.A snapshot copy PDB can be created from a stand-alone clone PDB.
• D.A snapshot copy PDB depends on a storage snapshot which can be stored on any file system.
• E.A PDB snapshot depends on a storage snapshot which can only be stored on specific file systems.
• F.A snapshot copy PDB depends on a storage snapshot which can only be stored on specific file systems.
• G.A PDB snapshot is always a sparse copy of the source PDB.

After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:
SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL;
NUMBER_VALUE
-------------------------
SQL> EXEC DBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1)
PL/SQL procedure successfully completed.
SQL> select number_value from redaction_values_for_type_full;
NUMBER VALUE
------------------------
After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.
What must you do to activate the new default value for numeric full redaction?

• A.Re-connect the sessions that access objects with redaction policies defined on them.
• B.Re-create redaction policies that use FULL data redaction.
• C.Re-enable redaction policies that use FULL data redaction.
• D.Restart the database instance.
• E.Flush the shared pool.

Which three statements are true about Flashback Database?

• A.Flashback Database can recover a database to the state that it was in before a reset logs operation.
• B.Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.
• C.The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.
• D.Flashback Database can recover a data file that was dropped during the span of time of the flashback.
• E.Flashback Database uses a restored control file to recover a database.
• F.Flashback logs are written sequentially, and are archived.