Choose three. You must migrate a non-CDB Oracle 11g Database to a CDB without first performing an upgrade to the non-CDB. User-defined objects are stored in several tablespaces in the non-CDB. Which three methods can you use?

• A.replication using GoldenGate
• B.Data Pump transportable tablespaces
• C.cloning the non-CDB as a PDB
• D.Data Pump full database export and import
• E.Data Pump full transportable database
• F.the DBMS_PDB package

Comment: *

Name: *

Email: *

Verification: *

You have configured RMAN SBT channels to write backups to media.
You then take an RMAN backup by using this command:

Which three are true? (Choose three.)

• A.The SPFILEis included in the self-contaied archival backup.
• B.All archive logs created after this backup are kept for two years.
• C.The restore point is a label for the system change number (SCN) before the archival backup was taken.
• D.The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.
• E.The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.
• F.The control file is included in the self-contained archival backup.

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 Large Pool size by reducing the Shared Pool size.
• B.With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
• C.Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
• 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 Program Global Area size by reducing the System Global Area 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 an application container? (Choose three.)

• A.It must have an application seed PDB.
• B.It must have an application root PDB.
• C.Two application containers can share an application seed PDB.
• D.It can contain a single application.
• E.An application PDB can belong to multiple application containers.
• F.It can contain multiple applications.

Comment: *

Name: *

Email: *

Verification: *

Oracle Data Redaction is active on the SCOTT.EMP table. You queried the table twice. SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; Which is guaranteed to be true concerning the redaction policy?

• A.FULL redaction is active on the SAL column
• B.RANDOM redaction is active on the HIREDATE column
• C.RANDOM redaction is active on the MGR column
• D.PARTIAL redaction is active of the HIREDATE column.
• E.PARTIAL redaction is active on the MGR column.

Comment: *

Name: *

Email: *

Verification: *