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.(您注意到 FULL 编校继续以零编校数值数据)也就是
上面的修改还没有生效,该命令是把 number 的数据类型编辑以后默认值为-1)。
What must you do to activate the new default value for numeric full
Redaction?
Re-enable redaction policies that use FULL data redaction.
Re-create redaction policies that use FULL data redaction.
Re-connect the sessions that access objects with redaction policies defined on
Them.
Flush t he shared pool.
Be online in read/write mode.
Which two are true about using RMAN to perform an open database back up of this tablespace? (Choose two.)
Backups must be done incrementally.
Backups must be contained in backup sets.
Backups can be taken only if the database is in ARCHIVE LOG mode.
Backups can be done incrementally.
(DBCA) to clone a remote pluggable database (PDB) starting from Oracle 19c?
creating a database link from CDB$ROOT in the local database to CDB$ROOT
In the remote system that is to be cloned
creating a database link from CDB$ROOT in the local database to the PDB in
The remote system that is to be cloned
backing up the cloned PDB
opening the cloned PDB
PDB using Data Pump? (Choose two.)
Parameters.
Identify four RMAN commands that produce a multi-section Backup.
BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
BACKUP ARCHIVELOG ALL SECTION SIZE 25M;
BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;
Command in RMAN? (Choose all that apply.) choose two
It is used to change failure priority only for HIGH or LOW priorities.
It is used to execute the advised repair script.
It is used to change failure priority only for the CRITICAL priority.
It is used to explicitly close the open failures.
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 files 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?
1, 2, 4, 5, 7, 8
1, 2, 4, 6, 7, 8
1, 2, 3, 4, 5, 7, 8
1, 2, 3, 4, 5, 6, 7, 8
我来回答: