Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)?

• A.If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
• B.If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.
• C.In a PDB plan, subplans may be used with up to eight consumer groups.
• D.If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.
• E.If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about the FLASHBACK DATABASE feature? (Choose three.)

• A.FLASHBACK LOGS are archived after a log switch.
• B.FLASHBACK DATABASE only uses FLASHBACK LOGS to get the database to the desired flashback time.
• C.A database can be flashed back using SQL*PLUS.
• D.It always generates REDO and UNDO.
• E.Queries and DML have the same FLASHBACK LOG overhead when flashback is enabled for a database.
• F.It requires that the target database be in ARCHIVELOG mode.

Comment: *

Name: *

Email: *

Verification: *

For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)

• A.to specify a default tablespace in a PDB cloned from another PDB in the same CDB.
• B.to exclude a temp tablespace when plugging in a PDB
• C.to include specific user tablespaces only when relocating a PDB
• D.to specify the list of tablespaces to include when creating a PDB from the CDB seed
• E.to specify the list of user tablespaces to include when moving a non-CDB to a PDB
• F.to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB

Comment: *

Name: *

Email: *

Verification: *

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

• 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.PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.
• D.Sorts and Hash Joins use PGA memory.
• E.The entire PGA is located in the System Global Area (SGA) when using shared servers.

Comment: *

Name: *

Email: *

Verification: *

Which three methods can be used for heap table data migration after upgrading a database? (Choose three.)

• A.using Database Replay
• B.using SQL Developer
• C.using Oracle Data Pump
• D.using operating system file copy utilities
• E.using Database Upgrade Assistant
• F.using the CREATE TABLE AS SELECT SQL statement

Comment: *

Name: *

Email: *

Verification: *