Catalog schema owned by the RC12C user. The RCAT11 database contains an
Oracle Database version 11g catalog schema owned by the RC11 user in
Which several databases are registered. Both the databases are open. You
Execute the RMAN commands:
RMAN> CONNECT CATALOG rcl2c/passl2c@catdbl2c
RMAN> IMPORT CATALOG rcll/pwdcatll@ractll
Which two tasks are performed as part of the import?
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.
Their collection? (Choose two.)
And Oracle Database for the first time on a server.
Examine this command and its outcome:
Which two are true? (Choose two.)
oracle will be an owner of the Oracle Inventory.
oracle must be the owner of every Oracle Database installation.
oracle can own an Oracle Database installation but not an Oracle Grid
Infrastructure installation.
oracle will be granted the SYSASM privilege when installing the Oracle
Database software.
Using Data Recovery Advisor? (Choose two.)
Using the Data Recovery Advisor LIST FAILURE command always requires that
The database for Which failures are to be listed is in MOUNT state.
A failure can be closed only when it has been repaired.
Data Recovery Advisor can be used if a database is closed.
The Data Recovery Advisor CHANGE FAILURE command can be used only to
Change failure priorities.
Recovery begins from the beginning of the CURRENT redo log group.
Recovery begins from the last checkpoint position that was calculated by the
Database Writer before instance failure.
Recovery begins from the start of any ACTIVE redo log group or the start of
The CURRENT log group if no other group is ACTIVE.
Recovery reads redo until the end of the redo thread. SMON rolls back any
Dead transactions, and then the datanase is opened.
Two.)
The Oracle Database time model should be used to find the database and
Instance areas most in need of tuning.
Tuning activities should stop once the user is satisfied with performance.
Tuning activities should stop once agreed service levels for performance have been met.
The database instance memory should always be tuned before tuning any file Systems.
Server?
It includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software.
It creates one disk group during installation.
It requires the operating system oracle_base environment variable to be predefined before installation.
It requires Oracle ASM Filter Driver (ASMFD) to manage Automatic Storage Management (ASM) disks
It requires Oracle ASMLibto manage Automatic Storage Management (ASM) disks.
(DBCA) templates? (Choose two.)
Server? (Choose two.)
Determined the backup istaking too long and suspect a performance
Bottleneck. Which three are true about diagnosing and tuning these
Problems? (Choose three.)
It obeys all hints.
It considers the filters in WHERE clauses when generating execution plans for SQL statements.
It can re-optimize execution plans after previous executions detect suboptimal plans.
It considers object statistics when generating execution plans for SQL statements.
It updates stale object statistics in the Data Dictionary.
It can only use SQL plan Directives tied to the SQL statement for which a plan is being generated.
Two.)
The Oracle Database time model should be used to find the database and
Instance areas most in need of tuning.
Tuning activities should stop once the user is satisfied with performance.
Tuning activities should stop once agreed service levels for performance have
Been met.
The database instance memory should always be tuned before tuning any file
Systems.
SQL statements should always be tuned before tuning any file systems.
The alert log should be used to find the database and instance areas most in
Need of tuning.
(DBCA) starting from Oracle Database 19c? (Choose three.)
And PDB2. The LOCAL_UNDO_ENABLED database property is set to FALSE in
The CDB. Data file 24 of PDB2 was deleted and you need to restore and
Recover it.
The only RMAN backup that exists was created with the BACKUP
DATABASE command while connected to CDB$ROOT. Which three are true?
(Choose three.)
Flashback Database feature. Which two statements regarding flashback logs
Are true? (Choose two.)
You want to install Oracle Grid Infrastructure for a Standalone Server using
Oracle Universal Installer (OUI).
There is no existing Oracle installation on the server.
Which two are prerequisites?
an operating system user to own this installation
the Oracle Inventory group oinstall
an operating system account called grid
a group called dba
the installation of Oracle ASMLIB
Oracle 18c and later releases?(Choose two.)
It can be used for both Oracle Database and Oracle Grid Infrastructure
Installation.
It can only install and configure Oracle Database software. The database has
To be created separately.
It does not require the setup wizard.
It uses a single RPM that automatically extracts and installs the Oracle
Database software.
我来回答: