After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows: SQL> select number_value from REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE ------------0 SQL> exec DBMS_REDACT.UPDATE_FULL_REDACTION_VALUES(-1); SQL> select number_value from REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE -------------1 After changing the value, you notice that FULL redaction continues to redact numeric data with zero.What must you do to activate the new default value for numeric full redaction?

• A.Flushthesharedpool.
• B.Re-createredactionpoliciesthatuseFULLdataredaction.
• C.Re-enableredactionpoliciesthatuseFULLdataredaction.
• D.Re-connect the sessions that access objects with redaction policies defined on them.
• E.Restart the database instance. Correct

Comment: *

Name: *

Email: *

Verification: *

Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

• A.It recompiles all stored PL/SQL code by using utlrp.sql.
• B.It empties the RECYCLE BIN.
• C.It performs prerequisite checks to verify if the Oracle database is ready for upgrade.
• D.It sets all user tablespaces to "read-only" before starting the upgrade.
• E.It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles
• F.It increases tablespace size, if required, to meet upgrade requirements.

Comment: *

Name: *

Email: *

Verification: *

Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)

• A.the configuration of storage arrays
• B.using check constraints to speed up updates
• C.defining foreign keys for all tables to speed up joins
• D.defining primary keys for all tables to speed up all queries
• E.the physical data model

Comment: *

Name: *

Email: *

Verification: *

Which three are true about interpreting Recovery Manager (RMAN) error stacks returned to standard output?
(Choose three.)

• A.Media Management errors appear as a line with "sbtio".
• B.Media Management errors appear as a line with "sbtio" and a number.
• C.Media Management errors appear as a line with "Additional information" and a number.
• D.If an RMAN command fails, the output will identify the channel ID where the failure occurred.
• E.If an RMAN command fails, the output will only identify the command that failed.
• F.Some messages in the error stack are not errors.

Comment: *

Name: *

Email: *

Verification: *

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

• A.relocating a remote pluggable database in silent mode
• B.cloning a remote container database in silent mode
• C.relocating a remote pluggable database in interactive mode
• D.cloning a remote pluggable database in silent mode
• E.relocating a remote container database in silent mode
• F.cloning a remote container database in interactive mode
• G.relocating a remote container database in interactive mode

Comment: *

Name: *

Email: *

Verification: *