083_在线真题试卷与模拟练习_083

更新时间：试题数量：购买人数：提供作者：

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

随机练习 自定义设置练习量

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

学习资料 考试学习相关信息

搜索

题库预览

Choose three. Which three capabilities require the use of the RMAN recovery catalog?

Choose two. Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?

Choose two. Examine this command:
$ rhpctl move database -sourcehome Oracle_home_path -destinationhome Oracle_home_path For
Which two purposes can you use this command?

Choose two. Which two are true about Lockdown profiles in a container database (CDB. and its pluggable databases (PDBs)?

Choose three. Which three are true about the FLASHBACK DATABASE feature?

You are working on an Oracle Database 19c database. You enabled the Flashback Database feature.
Which two statements regarding flashback logs are true? (Choose two.)

choose two You configured the Fast Recovery Area (FRA. for your database. The database instance is in ARCHIVELOG mode.
The default location for the archived redo log files is the FRA.
Which two files are removed automatically if space is required in the FRA as per the retention policy?

Which three statements are true about Flashback Database?

Choose the best answer. How do you configure a CDB for local undo mode?

Choose two. Which two are true about unplugging an application container from a container database and plugging it into a different container database?

Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

Which two statements are true when row archival management is enabled?

Choose two. Which two statements are true when row-archival management is enabled?

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?

In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.
Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c.
Examine the table definition:
Create table employees (empno number, salary number, deptid number, name varchar2(100), period for employee_timE.;
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

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

------------

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?

You execute the following piece of code with appropriate privileges: BEGIN DBMS_REDACT.ADD_POLICY( END; object_schema object_name column_name policy_name function_type expression => 'SCOTT', => 'EMP', => 'SAL', => 'SCOTT_EMP', => DBMS_REDACT.FULL, => 'SYS_CONTEXT(''SYS_SESSION_ROLES'',''MGR'') = ''FALSE'''); END; BEGIN DBMS_REDACT.ADD_POLICY( object_schema object_name column_name policy_name function_type expression => 'SCOTT', => 'EMP_VW', => 'SAL', =>
' S C O T T _ E M P _ V W ' , = > D B M S _ R E D A C T . N O N E , = >
'SYS_CONTEXT(''SYS_SESSION_ROLES'',''MGR'') = ''FALSE''');
User SCOTT has been granted the CREATE SESSION privilege and the MGR role.
Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?

A redaction policy was added to the SAL column of the SCOTT.EMP table: BEGIN DBMS_REDACT.ADD_POLICY( object_schema object_name column_name policy_name function_type expression => 'SCOTT', => 'EMP', => 'SAL', => 'SCOTT_EMP', => DBMS_REDACT.FULL, => 'SYS_CONTEXT(''SYS_SESSION_ROLES'',''MGR'') END;
All users have their default set of system privileges.
For which three situations will data not be redacted?

Oracle Data Redaction is active on the SCOTT.EMP table. You queried the table twice.

SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30;

Which is guaranteed to be true concerning the redaction policy?

1 7 8 9 10 11 15

更多题库