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

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

有效期：个月

章节介绍：共有个章节

我的练习

我的错题
(0道)

我的收藏
(0道)

我的斩题
(0道)

我的笔记
(0道)

专项练习

顺序练习 0 / 0

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

题型乱序 按导入顺序练习

模拟考试 仿真模拟

题型练习 按题型分类练习

易错题 精选高频易错题

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

搜索

题库预览

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:
1SHUTDOWN ABORT
2STARTUP NOMOUNT
3STARTUP MOUNT
4ALTER DATABASE MOUNT
5RESTORE DATABASE
6RECOVER DATABASE NOREDO
7RECOVER DATABASE UNTIL AVAILABLE REDO
8RESTORE ARCHIVELOG ALL
9ALTER DATABASE OPEN
10ALTER DATABASE OPEN RESETLOGS
Choose the minimum required steps in the correct order to recover the database.

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?

Your CDB has two regular PDBs as well as one application container with two application PDBs and an application seed.
No changes have been made to the standard PDB$SEED.
How many default temporary tablespaces can be assigned in the CDB?

Choose the best answer.
Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application.
Examine these steps:
1 Install the SALES_APP application, including the common tables, in the application root.
2 Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root.
3 Create an application seed.
4 Install the SALES_APP application in the application seed.
5 Create the SALES_APP1 and SALES_APP2 application PDBs.
6 Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.
7 Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.
8 Sync the application seed with the application root.
Which are the minimum required steps in the correct sequence?

Choose the best answer.

Examine this configuration:

1 CDB1 is a container database.

2 COMMON_USER_PREFIX is set to an empty string.

3 PDB1 is a pluggable database in CDB1.

4 APP1_ROOT is an application container in CDB1.

5 APP1_PDB1 is an application PDB in APP1_ROOT.

You execute these commands:

Sqlplus sys/oracle@localhost:1521/cdb1 as sysdba

SQL> CREATE ROLE role1 CONTAINER=CURRENT;

Which is true?

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/cdb1 as sysdba
SQL> ALTER SYSTEM SET DEFAULT_SHARING=DATA;
System altered.
SQL> ALTER SESSION SET CONTAINER=app_root;
Session altered.
SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp BEGIN UPGRADE ‘1.0’ TO ‘2.0’;
Pluggable database altered.
SQL> ALTER TABLE emp ADD (sal NUMBER NOT NULL);
Table altered.
SQL> ALTER PLUGGABLE DATABASE APPLICATION companyapp END UPGRADE TO ‘2.0’;
Pluggable database altered.
SQL> ALTER SESSION SET CONTAINER=app_pdb1;
Session altered.
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?

Choose the best answer.
Examine this configuration:
1 CDB1 is a container database.
2 APP_ROOT is an application root in CDB1.
3 APP_PDB1 is an application PDB in APP_ROOT.
4 FLASHBACK DATABASE is ON.
You execute these commands:
$$ sqlplus sys/orac1e_4U@localhost:1521/cdb1
SQL> SELECT current_scn FROM v$$database;
CURRENT_SCN
-----------------------
2074756
SQL> CREATE TABLE cdb1_tab(c1 NUMBER);
Table created.
SQL> ALTER SESSION SET CONTAINER=app_root;
Session altered.
SQL> CREATE TABLE app_root_tab(c1 NUMBER);
Table created.
SQL> ALTER SESSION SET CONTAINER=app_pdb1;
Session altered.
SQL> CREATE TABLE app_pdb1_tab(c1 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?

Choose the best answer.
Examine this configuration:
1 CDB1 is an Oracle Database 12c Release 2 container database (CDB).
2 PDB1 and PDB2 are two pluggable databases (PDBs) in CDB1.
After successfully performing all the preupgrade tasks, you execute these commands from the Oracle Database 18c environment:
$$ export ORACLE_SID=cdb1
$$ sqlplus / as sysdba
SQL> STARTUP UPGRADE;
SQL> SHOW pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------------------------------------------------------------
2 PDB$$SEED MIGRATE YES
3 PDB1 MOUNTED YES
4 PDB2 MOUNTED YES
SQL> ALTER PLUGGABLE DATABASE pdb1 OPEN UPGRADE;
Pluggable database altered.
SQL> exit
$$ $ORACLE_HOME/perl/bin/perl catctl.pl -C 'PDB2'
What is the outcome?

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?

Choose the best answer.
Examine this configuration:
1 CDB1 is a container database.
2 There are several pluggable databases (PDBs) in CDB1.
5 Each PDB has several tables with referential integrity constraints.
6 FLASHBACK DATABASE is ON.
7 UNDO RETENTION GUARANTEE is enabled.
Multiple undesired multitable changes were made in all the PDBs. Which method can be used to undo the changes using a single command?

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.
3 LISTENER is the listener for ORCL.
4 The database ,listener, ASM instance, and ASM disk groups are managed by Oracle Restart.
5 All components are currently shut down.
You execute this command:
$ srvctl start database –d ORCL
What is the outcome?

Examine the RMAN command:
RMAN> RUN {
ALLOCATE CHANNEL c1 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?

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?

Examine the RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which prerequisite must be met before accomplishing the backup?

Choose the best answer.
On the 10th of August, you implement an incremental database backup strategy and configure a recovery window of five days.
Level 0 backups are taken on the 10th, 17th, and 24th of August.
Differential level 1 incremental backups are taken daily between the level 0 backups. Today is the 26th of August.
Which backups will be obsolete?

A schema owner truncated a table in error and must recover the data. Which Oracle Flashback feature could be used to recover the data?

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?

Examine the statements that use flashback technologies:
1 FLASHBACK TABLE customers TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');
2 SELECT * FROM customers AS OF SCN 123456;
3 FLASHBACK TABLE customers TO BEFORE DROP;
4 FLASHBACK DATABASE TO TIMESTAMP TO_TIMESTAMP('2013-02-04 09:30:00', 'YYYY-MM-DD HH:MI:SS');
5 SELECT * FROM customers VERSIONS BETWEEN SCN 123456 AND 123999;
6 ALTER TABLE customers FLASHBACK ARCHIVE;
Which set of statements depends on the availability of relevant undo data in the undo tablespace?

RMAN is connected to a target database instance and an auxilary instance. You execute the command:
RMAN> DUPLICATE TARGET DATABASE TO dupdb
FROM ACTIVE DATABASE
SECTION SIZE 1G;
What is the outcome?

Choose the best answer
You want to create a duplicate database DUP_DB from your production database PROD on the same host. The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog. You create an auxiliary instance and want to execute the command:
RMAN> DUPLICATE TARGET DATABASE TO dup_db
FROM ACTIVE DATABASE;
What is a prerequisite for the successful execution of this command

1 2 3 4 5 6 15

更多题库