After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:

After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.
What must you do to activate the new default value for numeric full redaction?

• A.Re-enable redaction policies that use FULL data redaction.
• B.Re-create redaction policies that use FULL data redaction.
• C.Re-connect the sessions that access objects with redaction policies defined on them.
• D.Flush the shared pool.
• E.Restart the database instance.

Comment: *

Name: *

Email: *

Verification: *

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).
The characteristics of the non-CDB are as follows:
* Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit
* Character Set: AL32UTF8
* National Character Set: AL16UTF16
* O/S: Oracle Linux 6 64-bit
The characteristics of the CDB are as follows:
* Version: Oracle Database 12c Release 1 64-bit
* Character Set: AL32UTF8
* National Character Set: AL16UTF16
* O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

• A.Transportable database
• B.Transportable tablespace
• C.Data Pump full export/import
• D.The DBMS_PDB package
• E.RMAN

Comment: *

Name: *

Email: *

Verification: *

You are the DBA for an Oracle Database 11g Release 1 data warehouse database running on Oracle Linux with little endianness.
You want to plug in a transportable tablespace with a 16K blocksize from an Oracle Database 10g database that is running on a SPARC-based Oracle Solaris system with big endianness.
The data warehouse database has the following parameters set:

The following parameters are not explicitly set:

What action must you perform on the data warehouse database to prepare it for the transportable tablespace plug in operation?

• A.Do nothing, because you cannot transport a tablespace between databases with different endian formats.
• B.Set ALTER SYSTEM SET DB_16K_CACHE_SIZE=8M and leave other parameters set to their current settings.
• C.Do nothing, because Automatic Shared Memory Management will size DB_16K_CACHE_SIZE automatically.
• D.Do nothing, because Automatic Memory Management will size DB_16K_CACHE_SIZE automatically
• E.Set ALTER SYSTEM SET DB_CACHE_SIZE=192M followed by ALTER SYSTEM SET DB_16K_CACHE_SIZE=8M;

Comment: *

Name: *

Email: *

Verification: *

An administrator account is granted the CREATE SESSION and SET CONTAINER system privileges. A multitenant container database (CDB) instant has the following parameter set: THREADED_EXECUTION = FALSE Which four statements are true about this administrator establishing connections to root in a CDB that has been opened in read only mode?

• A.You can conned as a common user by using the connect statement.
• B.You can connect as a local user by using the connect statement.
• C.You can connect by using easy connect.
• D.You can connect by using OS authentication.
• E.You can connect by using a Net Service name.
• F.You can connect as a local user by using the SET CONTAINER statement.

Comment: *

Name: *

Email: *

Verification: *

Which statement is true about Oracle Net Listener?

• A.It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.
• B.A single listener can service only one database instance and multiple remote client connections.
• C.Service registration with the listener is performed by the process monitor (PMON) process of each database instance.
• D.The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.
• E.The listener.ora configuration file must be located in the ORACLE_HOME/network/admin directly.

Comment: *

Name: *

Email: *

Verification: *