Oracle Database Administration II: 1Z0-083

Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)

A. Tablespaces are automatically created as neeed while importing full exports in either a non-CDB or a PDB.

B. Oracle attempts to convert conventional database users to local users when moving schemas from a non-CDB to a PDB.

C. A new PDB is automatically created when importing a non-CDB into a CDB.

D. Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.

E. Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.

F. Moving data from a non-CDB to a PDB is only possible by using conventional export and import.

Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)

A. cloning a remote container database in interactive mode

B. cloning a remote pluggable database in silent mode

C. relocating a remote pluggable database in interactive mode

D. relocating a remote container database in silent mode

E. cloning a remote container database in silent mode

F. relocating a remote pluggable database in silent mode

G. relocating a remote container database in interactive mode

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 MGR column

C. RANDOM redaction is active on the HIREDATE column

D. PARTIAL redaction is active on the MGR column.

E. PARTIAL redaction is active of the HIREDATE column.