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.Automatic Memory Management must be used together with locking the System Global Area into physical memory.
• D.With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
• E.On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.
• F.With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.

Comment: *

Name: *

Email: *

Verification: *

Choose two. You are managing this configuration: 1. CDB1 is a container database. 2. PDB1 and PDB2 are two pluggable databases in CDB1. 3. USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2 . CDB1 user SYS executes these commands after connecting successfully to PDB2: SQL> ALTER SESSION SET CONTAINER=pdb1; Session altered. SQL> INSERT INTO user1.emp VALUES (100, 'Alan' ,1) ; 1 row created. SQL> INSERT INTO user1.emp VALUES (101, 'Ben' ,1) ; 1 row created. SQL> ALTER SESSION SET CONTAINER=pdb2; Session altered. SQL> INSERT INTO user2.dept VALUES(1, 'IT'); Which two are true? Which two are true? (Choose two.)

• A.The inserts on USER1.EMP were committed when the session inserted a row into USER2. DEPT.
• B.The insert on USER2.DEPT is uncommitted.
• C.The insert on USER2.DEPT is a recursive autonomous transaction by the child session and is committed.
• D.The insert on USER2.DEPT fails because of the active transaction in the parent container.
• E.The inserts on USER1.EMP were rolled back when the session connected to PDB2
• F.The inserts on USER1.EMP remain uncommitted when the session connected to PDB2.
• G.The inserts on USER1.EMP were committed when the session connected to PDB2.

Comment: *

Name: *

Email: *

Verification: *

RMAN is connected to a target database instance and an auxilary instance. You execute 3625the command: RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE SECTION SIZE 1G; What is the outcome?

• A.RMAN uses the pull method to restore files using backup sets
• B.RMAN uses the pull method to restore files using image copies
• C.RMAN uses the push method to transfer backup sets
• D.RMAN uses the push method to transfer image copies

Comment: *

Name: *

Email: *

Verification: *

Choose three. Which three are true about cloning databases into an existing CDB with RMAN?

• A.A non-CDB can be cloned into a PDB.
• B.A user with SYSDBA or SYSBKUP must be logged in with RMAN to CDB$ROOT when cloning a PDB.
• C.A user with SYSDBA or SYSBKUP must be logged in with RMAN to the non-CDB being cloned when cloning a non-CDB.
• D.Only one PDB can be cloned at a time.
• E.The target and auxiliary instance passwords must be the same.
• F.Two or more PDBs can be cloned with the same command.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *