单选题
After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows: 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?（）
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 the shared pool.
Restart the database instance
单选题
You notice that the performance of your production 24/7 Oracle database significantly degraded.Sometimes you are not able to connect to the instance because it hangs. You do not want to restart thedatabase instance.How can you detect the cause of the degraded performance?（）
Enable Memory Access Mode, which reads performance data from SGA.
Use emergency monitoring to fetch data directly from SGA analysis.
Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
Use Active Session History (ASH) data and hang analysis in regular performance monitoring.
Run ADDM in diagnostic mode.
多选题
A redaction policy was added to the SAL column of the SCOTT.EMP table: All users have their default set of system privileges. For which three situations will data not be redacted?（）
SYS sessions, regardless of the roles that are set in the session
SYSTEM sessions, regardless of the roles that are set in the session
SCOTT sessions, only if the MGR role is set in the session
SCOTT sessions, only if the MGR role is granted to SCOTT
SCOTT sessions, because he is the owner of the table
SYSTEM session, only if the MGR role is set in the session
多选题
Which four actions are possible during an Online Data file Move operation?（）
Creating and dropping tables in the data file being moved
Performing file shrink of the data file being moved
Querying tables in the data file being moved
Performing Block Media Recovery for a data block in the data file being moved
Flashing back the database
Executing DML statements on objects stored in the data file being moved
单选题
A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL: There is enough free space in the disk group for mirroring to be done. What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?（）
Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.
多选题
You execute the following piece of code with appropriate privileges: User SCOTT has been granted theCREATE SESSION privilege and the MGR role.Which two statements are true when a session logged in as SCOTT queries the SAL column in the viewand the table?（）
Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.
Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.
Data is never redacted for the EMP_V.SAL column.
Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.
Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.
单选题
What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archivingenabled?（）
It fails with the ORA-665610 Invalid DDL statement on history-tracked message
The rows in the table are truncated without being archived.
The rows in the table are archived, and then truncated.
The rows in both the table and the archive are truncated.
多选题
Which three statements are true about Flashback Database?（）
Flashback logs are written sequentially, and are archived.
Flashback Database uses a restored control file to recover a database.
The Oracle database automatically creates, deletes, and resides flashback logs in the Fast RecoveryArea.
Flashback Database can recover a database to the state that it was in before a reset logs operation.
Flashback Database can recover a data file that was dropped during the span of time of the flashback.
Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.
多选题
You want to flash back a test database by five hours.You issue this command:SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);Which two statements are true about this flashback scenario?（）
The database must have multiplexed redo logs for the flashback to succeed.
The database must be MOUNTED for the flashback to succeed.
The database must use block change tracking for the flashback to succeed.
The database must be opened in restricted mode for the flashback to succeed.
The database must be opened with the RESETLOGS option after the flashback is complete.
The database must be opened in read-only mode to check if the database has been flashed back to the correct SCN.
多选题
You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?（）
SYSTEM
SYSAUX
EXAMPLE
UNDO
TEMP
USERS
推荐考题
-
在任何情况下，伸缩调节器处轨距的要求为（）。
-
人类有两套影响学习的记忆系统：陈述性记忆和程序记忆。陈述性记忆是对事实或者词汇之类基本认识的记忆。而程序记忆，就是一个人“不劳而获”的记忆。程序记忆是人养成习惯和习得技巧的方式，比如骑自行车。在很多时候，这种学习是无意识的。人们用早期发育的程序记忆系统来学习复杂的东西，比如语法规则。帮助人们学习词汇的陈述性记忆系统，则需要更多时问完成发育。儿童拥有程序记忆系统，并且不受陈述性记忆系统的干扰。由此可以推出()。
-
宋末元初四大家
-
公平目标的实现可以通过（）实现。
-
荟萃分析
-
人员安全疏散分析的性能判定标准为：可用疏散时间（A.SET）必须（）必需疏散时间（RSET）。
-
预防HIV感染的主要措施应当为（ ）
-
简述我国混合型债券市场的发展状况。
-
造成水中某些污染物在生物体内含量大大高于水体中的浓度的生物放大作用是指（）
-
输血的适应证中，不包括（）