OCP-083下-280（2次）

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 练习进度 0 / 0

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

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Examine this configuration:

While CDB1 is open, ‘/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl’is

Accidentally deleted.

To recover from this critical failure, you execute these commands:

（含图）

What will be the outcome?

Examine these actions:
1 Create a new database for a recovery catalog.
2 Create a tablespace with sufficient space in the catalog database for the recovery catalog.
3Configure ARCHIVE LOG mode for the catalog database.
4Create a user to own the recovery catalog schema with quota on the tablespace that will contain
The catalog.
5 Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner.
6 Grant the SYSBACKUP privilege to the recovery catalog schema owner.
Which are the minimum actions that must be performed before executing the CREATE CATALOG
Command?

Which two are true about creating pluggable databases (PDBs) using snapshots in Oracle 19c and
Later releases? (Choose two.)

Which two are true about Oracle Database Configuration Assistant (DBCA.templates? (Choose
Two.)

choose one
You want to create a test database as a replica of your production database with minimum
Intervention from a DBA.
Which method would you use?

Which two statements are true about the Database Configuration Assistant (DBCA)?

You plan to create a database by using the Database Configuration Assistant (DBCA), with the
Following specifications:
Applications will connect to the database via a middle tier.
The number of concurrent user connections will be high.
The database will have mixed workload, with the execution of complex BI queries scheduled at
Night.
Which DBCA option must you choose to create the database?

Your SALES_ROOT application container has two application PDBs. The SALES_APP application has

A common table, FIN.REVENUE, in the two PDBs.

Examine this query and its output:

（含图）

Which two are true? (Choose two.)

Your container database, CDB1, has an application container, HR_ROOT, with an application PDB,
HR_PDB1.
You have the required privilege to clone HR_PDB1 to container database CDB2, which does not
Contain HR_ROOT.
Which two are always true? (Choose two.)

Which three are true about backup, restore, and recovery operations done without using Recovery
Manager (RMAN)? (Choose three.)

Examine this configuration:

1CDB1 is a container database.

2PDB1 and PDB2 are pluggable databases in CDB1.

You execute these commands successfully:

（含图）

Which two are true? (Choose two.)

Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)

A database is configured in ARCHIVE LOG mode.

A full RMAN backup exists but no control file backup to trace has been taken.

A media failure has occurred.

In which two scenarios is incomplete recovery required? (Choose two.)

Which two are true about instance recovery? (Choose two.)

.Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

A container database (CDB.contains two pluggable databases PDB1 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.)

Which two are true about data movement between a non-CDB and a PDB using Data Pump?
(Choose two.)

.Which three methods can be used for heap table data migration after upgrading a database?
(Choose three.)

Which two are true about Oracle instance recovery? (Choose two.)

Examine this configuration:

1 The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group

+DATA.

2 ORCL uses disk group +FRA for the Fast Recovery Area.

3LISTENER is the listener for ORCL.

4The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart.

5All components are currently shut down.

You execute this command:

（含图）

What is the outcome?

1 3 4 5 6 7 14