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

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Choose three
Which three are true about unified auditing in full mode?

Choose two

Which two are benefits of unified auditing in full mode?

Identify three benefits of Unified Auditing.

You have configured RMAN SBT channels to write backups to media.
You then take an RMAN backup by using this command:
Which three are true? (Choose three.、

The USERS tablespace consists of data files 3 and 4 and must always 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.、

.Which four are true about RMAN backup sets? (Choose four.、

Which two are true about creating RMAN backups for an Oracle container database? (Choose two.、

Which three can be done using Oracle Database Configuration Assistant (DBCA、 starting from
Oracle Database 19c? (Choose three.、

Examine these queries and their output:
An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You
Want to recover PDB1 to Restore Point R1.
How do you achieve this?

Which two are true about diagnosing Oracle Database failure situations using Data Recovery

Advisor?

(Choose two.、

Which statement describes the significance of the CHANGE FAILURE command in RMAN? (Choose
All that apply.、

Choose two.
Which two are true about poorly performing SQL statements and their tuning in Oracle database
Instances?

Choose three.
Which three are true about Automatic Workload Repository (AWR、 and Automatic Database
Diagnostic Monitor (ADDM、 in an Oracle multitenant environment?

Choose three.
Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB、
Target connection in Oracle Database 19c and later releases?

Choose three.
In a single-instance, multitenant container database (CDB、, which three are only ever defined in or
Part of CDB$ROOT?

Choose two.

When backing up to the Oracle Fast Recovery Area (FRA、, you determine that the backup takes

Too long and suspect a performance bottleneck.

Which two are true about diagnosing and tuning these problems?

Choose two.
Which two are true about a read-only Oracle home?

Choose three.
Which three are true about the Oracle Optimizer?

Choose two.
Which two are true about the execution of operating system scripts starting from Oracle Database
19c?

Choose the best answer.

Examine this configuration:

1 CDB1 is a container database running in ARCHIVELOG mode.

2 Multiple uncommitted transactions are running in CDB1 .

3 Redo log groups 1 and 2 are INACTIVE.

4 Redo log group 3 is the CURRENT group.

All members of redo log group 3 are lost before it is archived.

Examine these possible steps:

1 SHUTDOWN ABORT

2 STARTUP NOMOUNT

3STARTUP MOUNT

4 ALTER DATABASE MOUNT

5 RESTORE DATABASE

6 RECOVER DATABASE NOREDO

7RECOVER DATABASE UNTIL AVAILABLE

8 RESTORE ARCHIVELOG ALL

9ALTER DATABASE OPEN

10 ALTER DATABASE OPEN RESETLOGS

Choose the minimum required steps in the correct order to recover the database.

1 5 6 7 8 9 14