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. Data Pump full database export and import
• B. the DBMS_PDB package
• C. Data Pump transportable tablespaces
• D. replication using GoldenGate
• E. cloning the non-CDB as a PDB
• F. Data Pump full transportable database

Which are the three steps in the SQL tuning process for Oracle Database environments?

• A. Test the application as a whole using tuned SQL statements.
• B. Identify poorly tuned SQL statements using Automatic Database Diagnostic Monitor.
• C. Tune individual SQL statements using the SQL Tuning Advisor.
• D. Tune SQL statements as a group using the SQL Tuning and SQL Access Advisors.
• E. Test tuned SQL statements one at a time for all statements in the application.
• F. Identify poorly tuned SQL statements using the SQL Tuning Advisor.

Which two are true about SQL Performance Analyzer (SPA)? (Choose two.)

• A. It is integrated with the SQL Access Advisor.
• B. It predicts the impact of system changes on SQL workload response time.
• C. SQL statements that were originally run concurrently are run concurrently by SPA.
• D. It offers fine-grained analysis of all the SQL statements in the analysis task as a group.
• E. It provides before and after execution statistics for each SQL statement in the analysis task

Oracle Data Redaction is active on the SCOTT.EMPtable.
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. RANDOM redaction is active on the HIREDATE column
• B. RANDOM redaction is active on the MGR column
• C. FULL redaction is active on the SAL column
• D. PARTIAL redaction is active on the MGR column.
• E. PARTIAL redaction is active of the HIREDATE column.

For which two requirements can you use the USER_TABLESPACEclause with the CREATE PLUGGABLE DATABASEcommand? (Choose two.)

• A. to include specific user tablespaces only when relocating a PDB
• B. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMP when plugging in a PDB
• C. to specify the list of tablespaces to include when creating a PDB from the CDB seed
• 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 specify the list of user tablespaces to include when moving a non-CDB to a PDB