OCP-083下-280（2次）

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 练习进度 0 / 0

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

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

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

Automatic Shared Memory Management is disabled for one of your database instances. Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance.
What would be your next step?

Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)

Examine these queries and their output:

（含图）

After a system crash, an instance restart and an attempted opening of the PDBs result in:

Which two are true? (Choose two.)

Which two are true about RMAN duplexed backup sets? (Choose two.)

choose three
Which three are true about RMAN duplexed backup sets or image copies?

Which two statements are true about RMAN duplexed backups?

Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)

choose three
Which three RMAN persistent settings can be set explicitly?

Which three RMAN persistent settings can be set for a database?

The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup.

The CATDB12c database contains an Oracle Database version 12c catalog schema owned by the RC12C user. The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open. You execute the RMAN commands:
RMAN> CONNECT CATALOG rcl2c/passl2c@catdbl2c
RMAN> IMPORT CATALOG rcll/pwdcatll@ractll
Which two tasks are performed as part of the import?

choose one
You take regular backups of one of your production databases by using RMAN with a recovery
Catalog. You have added two new tablespaces to this database which must be included in future
Backups.
Which process occurs which allows the new backups to contain the new datafiles?

Which three are true about Optimizer Statistics Advisor? (Choose three.)

You issued this command: RMAN> BACKUP RECOVERY FILES;
Which two are true? (Choose two.)

Which two are true about the Oracle database methodology? (Choose two.)

While backing up to the Oracle Fast Recovery Area (FRA), you determined the backup is taking too long and suspect a performance bottleneck.
Which three are true about diagnosing and tuning these problems? (Choose three.)

Choose two.
You are managing this configuration:
1 CDB1 is a container database.
2PDB1 and PDB2 are two pluggable databases in CDB1.
3USER1.EMP is a table in PDB1 and USER2.DEPT is a table in PDB2 .
CDB1 user SYS executes these commands after connecting successfully to PDB2:
SQL> ALTER SESSION SET CONTAINER=pdb1;
Session altered.
SQL> INSERT INTO user1.emp VALUES (100, 'Alan' ,1) ;
1 row created.
SQL> INSERT INTO user1.emp VALUES (101, 'Ben' ,1) ;
1 row created.
SQL> ALTER SESSION SET CONTAINER=pdb2;
Session altered.
SQL> INSERT INTO user2.dept VALUES(1, 'IT');
Which two are true?
Which two are true? (Choose two.)

Examine this configuration:

1CDB1 is an Oracle Database 12c Release 2 database containing pluggable databases PDB$$SEED,

PDB1, and PDB2.

2PDB$$SEED is open READ ONLY

3 PDB1 is open READ WRITE

4PDB2 is MOUNTED.

5 ORACLE_HOME is /u01/app/oracle/product/18.1.0/dbhome_1.

You execute these commands before upgrading the database to the current release:

（含图）

For which databases will fixup scripts be created?

Which two are true about Oracle Flashback features? (Choose two.)

1 2 3 4 5 6 14