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

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

Comment: *

Name: *

Email: *

Verification: *

Which three are true in Oracle 19c and later releases? (Choose three.)

• A.An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.
• B.Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.
• C.A transportable data pump import can leave a plugged-in tablespace in read/write mode.
• D.A transportable data pump import can leave a plugged-in tablespace in read-only mode.
• E.Tablespaces never remain in read/write mode during transportable tablespace operations.
• F.Tablespaces always remain in read/write mode during transportable tablespace operations.

Comment: *

Name: *

Email: *

Verification: *

Choose three. Your container database, CDB1, is in local undo mode. You successfully execute this command while connected to CDB1: CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES= (CONNECT) CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1' ; Which three are true about PDB1?

• A.It has only local roles.
• B.It is in mount state after creation.
• C.Service PDB1 is created for remote logins to PDB1.
• D.It has the same common users defined as does CDB1.
• E.It has the same number of roles as CDB1.
• F.It has no local users.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about managing memory components in an Oracle database instance? (Choose three.)

• A.With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
• B.Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
• C.With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
• D.Automatic Memory Management must be used together with locking the System Global Area into physical memory.
• E.With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
• F.On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

Comment: *

Name: *

Email: *

Verification: *

Which three are true about monitoring waits for sessions and services? (Choose three.)

• A.V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.
• B.V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.
• C.V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.
• D.V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.
• E.V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.
• F.V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.

Comment: *

Name: *

Email: *

Verification: *