OCP_在线真题试卷与模拟练习_OCP_考试宝

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

有效期：个月

章节介绍：共有个章节

收藏

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

Examine the RMAN commands:
RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP";
RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP";
RMAN> DUPLICATE TARGET DATABASE TO dup_db
FROM ACTIVE DATABASE
PASSWORD FILE
SECTION SIZE 400M;
Which statement is true about the DUPLICATE command?(choose one)

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?

You must transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write.
The source and destination platforms have different endian formats. Examine this list of actions:
1 Make the UNIVERSITY tablespace read-only on the source system.
2 Export the UNIVERSITY tablespace metadata using EXPDP.
3 Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the source system.
4 Copy the UNIVERSITY tablespace data files to the destination system.
5 Copy the Data Pump dump set to the destination system.
6 Convert the UNIVERSITY tablespace data files to the destination platform format using RMAN on the destination system.
7 Import the UNIVERSITY tablespace metadata using IMPDP.
8 Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

Choose the best answer.
You want to transport the UNIVERSITY tablespace from one database to another.
The UNIVERSITY tablespace is currently open read/write.
The source and destination platforms have the same endian format. Examine this list of steps:.
1 Make the UNIVERSITY tablespace read-only on the source system.
2 Export the UNIVERSITY tablespace metadata using EXPDP.
3 Create a cross-platform backup set from the UNIVERSITY tablespace on the source system, using an RMAN command that includes the DATAPUMP clause.
4 Copy the cross-platform backup sets to the destination system.
5 Copy the Data Pump dump set from the source to the destination system.
6 Restore the cross-platform backup set on the destination system using an RMAN command that includes the DATAPUMP clause.
7 Import the UNIVERSITY tablespace metadata using IMPDP.
8 Make the UNIVERSITY tablespace read/write on the destination system.
Which are the minimum number of steps required, in the correct order, to
Transport the UNIVERSITY tablespace?

Choose the best answer.
Examine this output of an export from the current release of an Oracle
Multitenant database:
$$ sqlplus system/oracle .
SQL> col name for a10
SQL> select name, open_mode from v$$pdbs;
NAME OPEN_MODE
---------------------------------------
PDB$$SEED READ ONLY
PDB1 READ WRITE
PDB2 MOUNTED
SQL> exit
Next you execute:
$$ expdp system/oracle full=y
What is the outcome?

Choose the best answer.
Which operating system group is NOT needed to perform an Oracle Database installation?

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?

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?

In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments.
On further investigation, you find that buffer busy waits is caused by contention on data blocks.
Which option would you consider first to decrease the wait event immediately?

A user complains about poor database performance.
You want to verify if the user’s session has waited for certain types of I/O activity.
Which view displays all waits waited on by a session at least once?

Choose the best answer.
Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?

You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference. Which method or feature should you use?

You notice that the performance of your production 24/7 Oracle 12c database has significantly degraded. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance. How can you detect the cause of the degraded performance?

You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs.
How can you detect the cause of the degraded performance?

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

You are administering a multitenant container database (COB) that contains two
Pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common
User with DBA privileges.
The statistics_level parameter is PDB modifiable.
As the user sys, execute the following command on pdb2:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;
Which statement is true about the result of this command?

What is the effect of specifying the "ENABLE PLUGGABLE DATABASE" clause in a "CREATE DATABASE" statement?

Examine this configuration:

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

2 PDB$$SEED is open READ ONLY

3 PDB1 is open READ WRITE

4 PDB2 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?

Choose the best answer.
Examine this configuration:
1 CDB1 is an Oracle container database from an older release.
2 PDB1, PDB2, PDB3, and PDB4 are pluggable databases in CDB1.
A priority list UpgrdList has these entries:
1 pdb2
2 pdb1, pdb3
You execute this command:
$ /u01/app/oracle/product/18.1.0/db_1/rdbms/admin/dbupgrade -L UpgrdList
In which order will the upgrade occur?

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges.
You execute the command:
SQL>CREATE AUDIT POLICY table_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin,oe_admin;
Which statement is true?

更多题库