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.
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;
Database instances. Some SQL statements perform poorly due to excessive
Hard parse activity, thereby degrading performance.
What would be your Next step? one
Run the SQL Access Advisor.
Run the Memory Advisor for the shared pool.
Run the SQL Tuning Advisor.
Run the Memory Advisor for the Program Global Area.
Run the Memory Advisor for the System Global Area.
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.
Database, you notice a high number of buffer busy waits. The database
Consists of locally managed tablespaces with free list managed segments.
On further investigation, you f ind that buffer busy waits is caused by
Contention on data blocks.
Which option would you consider first to decrease the wait event
Immediately?
Decreasing PCTUSED
Decreasing PCTFREE
Increasing the number of DBWN process
Using Automatic Segment Space Management (ASSM)
Container database CDB2.
Select three options, any one of which is required for it to execute
Successfully. (Choose three.)
1-FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');
2-SELECT * FROM customers AS OF SCN 123456;
3-FLASHBACK TABLE customers TO BEFORE DROP;
4-FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');
5-SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;
6-ALTER TABLE customers FLASHBACK ARCHIVE;
Which set of statements depends on the availability of relevant undo data in the Undo tablespace?
1,3,6
1,2,5
3,4,5
2,3,5,6
Database. You want to know what caused this performance difference.
Which method or feature should you use?
Database Replay
Automatic Database Diagnostic Monitor (ADDM) Compare Period report
Active Session History (ASH) report
SQL Performance Analyzer
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
我来回答: