Which two are true about the Program Global Area (PGA) and its management in an Oracle database instance? (Choose two.)

• A.The private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers.
• B.The private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated servers.
• C.Sorts and Hash Joins use PGA memory.
• D.PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.
• E.The entire PGA is located in the System Global Area (SGA) when using shared servers.

Comment: *

Name: *

Email: *

Verification: *

You must transport the UNIVERSITYtablespace from one database to another.
The UNIVERSITYtablespace is currently open read/write.
The source and destination platforms have different endian formats.
Examine this list of actions:
1. Make the UNIVERSITY tablespace read-only on the source system.
2. Export the UNIVERSITYtablespace metadata using EXPDP.
3. Convert the UNIVERSITYtablespace data fies to the destination platform format using RMAN on the source system.
4. Copy the UNIVERSITYtablespace data files to the destination system.
5. Copy the Data Pump dump set to the destination system.
6. Convert the UNIVERSITYtablespace data files to the destination platform format using RMAN on the destination system.
7. Import the UNIVERSITYtablespace metadata using IMPDP.
8. Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITYtablespace?

• A.1, 2, 4, 5, 7, 8
• B.1, 2, 4, 6, 7, 8
• C.1, 2, 3, 4, 5, 7, 8
• D.1, 2, 3, 4, 5, 6, 7, 8
• E.2, 4, 5, 6, 7

Comment: *

Name: *

Email: *

Verification: *

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-enable redaction policies that use FULL data redaction.
• B.Re-create redaction policies that use FULL data redaction.
• C.Re-connect the sessions that access objects with redaction policies defined on them.
• D.Flush the shared pool.
• E.Restart the database instance.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)

• A.The BACKUP PLUGGABLE DATABASEcommand can be used to back up CDB$ROOT.
• B.SPFILEbackups can be created while connected to an application root PDB.
• C.Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.
• D.The BACKUP DATABASE PLUS ARCHIVELOGcommand will back up archive logs when RMAN is connected to a PDB.
• E.The BACKUP DATABASEcommand will create a pluggable database (PDB) backup when RMAN is connected to a PDB.

Comment: *

Name: *

Email: *

Verification: *

You plan to perform cross-platform PDB transport using XTTS. Which two are true?

• A.The source PDB must not be an application root.
• B.Automatic conversion of endianess occurs.
• C.The source and target platforms must have the same endianess.
• D.A backup of the PDB must exist, taken using the BACKUP command with the To PLATFORM clause.
• E.The source PDB must be in MOUNT state.
• F.The source PDB can be in MOUNT or OPEN state.

Comment: *

Name: *

Email: *

Verification: *