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.Restart the database instance. Correct
• C.Re-enableredactionpoliciesthatuseFULLdataredaction.
• D.Re-createredactionpoliciesthatuseFULLdataredaction.
• E.Re-connect the sessions that access objects with redaction policies defined on them.

Comment: *

Name: *

Email: *

Verification: *

Which two are true about server-generated alerts? (Choose two.)

• A.Stateful alerts must be created by a DBA after resolving the problem.
• B.Stateless alerts can be purged manually from the alert history.
• C.Stateless alerts can be cleared manually.
• D.Stateless alerts are automatically cleared.
• E.Stateful alerts are purged automatically from the alert history.

Comment: *

Name: *

Email: *

Verification: *

Examine this configuration:
1. CDB1is an Oracle Database 12c Release 2 database containing pluggable databases PDB$SEED, PDB1, and PDB2.
2. PDB$SEEDis open READ ONLY
3. PDB1is open READ WRITE
4. PDB2 is MOUNTED.
5. ORACLE_HOMEis /u01/app/oracle/product/18.1.0/dbhome_1.
You execute these commands before upgrading the database to the current release:

For which databases will fixup scripts be created?

• A.CDB1, PDB1, and PDB2only
• B.CDB1, PDB$SEED, and PDB1 only
• C.CDB1and PDB$SEEDonly
• D.CDB1, PDB$SEED, PDB1, and PDB2
• E.PDB$SEED, PDB1, and PDB2only

Comment: *

Name: *

Email: *

Verification: *

Choose the best answer You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog. You create an auxiliary instance and want to execute the command: RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE; What is a prerequisite for the successful execution of this command

• A.Flashback must be enabled for the PROD database.
• B.RMAN must be connected to the target database instance and the auxiliary instance.
• C.A most recent backup set of the PROD database must exist.
• D.The target database must be in MOUNT state.

Comment: *

Name: *

Email: *

Verification: *

You must transport the UNIVERSITY tablespace from one database to another.
The UNIVERSITY tablespace is currently open read/write.
The source and destination platforms have different endian formats. Examine this list of actions:
1.Make the UNIVERSITY tablespace read-only on the source system.
2.Export the UNIVERSITY tablespace metadata using EXPDP.
3.Convert the UNIVERSITY tablespace data fies to the destination platform format using RMAN on the source system.
4.Copy the UNIVERSITY tablespace data files to the destination system.
5.Copy the Data Pump dump set to the destination system.
6.Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.
7.Import the UNIVERSITY tablespace metadata using IMPDP.
8.Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

• A.1, 2, 4, 5, 7, 8
• B.1, 2, 3, 4, 5, 6, 7, 8
• C.2, 4, 5, 6, 7
• D.1, 2, 3, 4, 5, 7, 8
• E.1, 2, 4, 6, 7, 8

Comment: *

Name: *

Email: *

Verification: *