OCP_在线真题试卷与模拟练习_OCP

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

choose one You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years.
You execute the following command to change the requirement:
SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR:
What is the outcome?

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

Examine the RMAN command:
RMAN> RUN {
ALLOCATE CHANNEL cI DEVICE TYPE sbt:
ALLOCATE CHANNEL c2 DEVICE TYPE sbt:
ALLOCATE CHANNEL c3 DEVICE TYPE sbt:
BACKUP INCREMENTAL LEVEL =0 (DATAFILE 1.4.5 CHANNEL c1. (DATAFILE 2.3,9 CHANNEL c2. (DATAFILE 6,7,8 CHANNEL c3.:
SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
}
Which statement is true about the command?

Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?

Choose the best answer. Examine this output of an export from the current release of an Oracle multi tenant database：

$$ sqlplus system/oracle

SQL> col name for alO

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. SQL Performance Analyzer (SPA) has reported several regressed SQL statements for one of your databases. Which action could help in the performance management of these regressed SQL statements?

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 format4 Examine this list of steps：
1)Make the UNIVERSIRY tablespace read-only on the source system
2)Export the UNIWRSIRY 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 DAMAPUMP 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 pamapump clause
7)Import the UNIVERSIRY tablespace metadata using IMPDP
8)Make the UNIVERSIRY tablespace read/write on the destination system
Which are the minimum number of steps required, in the correct order, to transport the UNIVERSIRY tablespace?

Choose the best answer. Examine this configuration:
1)CDB1 is a container database.
2)DEFAULT.SHARING is METADATA.
3)APP_ROOT is an application root contained in CDB1.
4)APP_PDB1 is an application PDB contained in APP_ROOT.
5)COMPANYAPP is an application contained in APP_ROOT.
6)EMP is a common table created in APP_ROOT and all its application PDBs, created when version 1.0 of COMPANYAPP was installed.
You execute these commands： $ sqlplus sys/oracle@localhost：1521/cdbl sysdba
SQL> ALTER SYSTEM SET DEFAULT.SHAR I NODATA
System altered.
SQL> ALTER SESSION SET CONTAINER=app_root:
Session altered.
SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp BEGIN UPGRADE 1.0 TO 2.0；
SQL> DESC emp:
Name . Null? Type
ENO NUMBER
ENAME VARCHAR2 (20)
SQL> SELECT * FROM emp：
ENO ENAME
100 Alan
200 Ben
SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp SYNC；
What will be the outcome and why?

examine this configuration
SQL> SELECT current_scn FROM v$database：
CURRENT SCN 2074756
SQL> CREATE TABLE cdbl_tab(cl NUMBER)； Table created.
SQL> ALTER SESSION SET CONTAINER=app.root； Session altered*
SQL> CREATE TABLE app.root.tab (cl NUMBER): Table created.
SQL> ALTER SESSION SET CONTAINER=app_pdbl； Session altered*
SQL> CREATE TABLE app_pdbl_tab (cl NUMBER)； Table created.
SQL> conn / as sysdba Connected.
SQL> ALTER PLUGGABLE DATABASE app.root CLOSE;
Pluggable database altered.
SQL> FLASHBACK PLUGGABLE DATABASE app_root TO SCN 2074756： Flashback complete.
Which table or set of tables will exist after the Flashback operation has completed?

Which two are true about reclaiming space used by Flashback logs

In Oracle Database 19c and later releases?

Which three are true about Recovery Manager (RMAN)in Oracle Database 19c and later releases?(Choose three.）

Which two are true about server-generated alerts?

Which three conditions must be met before you create a Virtual

Private Catalog (VPC)?（3）

Which three are true about upgrading Oracle Grid Infrastructure?

Which three are true in Oracle 19c and later releases?(Choose

Three.

Which two are true about the Program Global Area(PGA) and its management in an Oracle database instance?

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?

You plan to perform cross-platform PDB transport using XTTS.Which two are true?

Which three statements are true about Automatic Workload Repository (AWR)?

Which two are true about the automatic execution of operating system scripts when performing silent mode installation starting from Oracle Database 19c?

1 2 3 4 5 6 7