没有合适的资源？快使用搜索试试~ 我知道了~

首页Oracle 12C OCP题库

Oracle 12C OCP题库

OCP题库

Oracle

5星 · 超过95%的资源需积分: 5 145 下载量 100 浏览量更新于2023-03-16 评论 8 收藏 2.83MB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

试读

130页

Oracle 12c OCP题库，Oracle OCP考试复习，OCP题库下载

资源详情

资源评论

资源推荐

s@lm@n

Oracle

Exam 1z0-060

Upgrade to Oracle Database 12c

Version: 8.6

[ Total Questions: 150 ]

Your multitenant container (CDB) contains two pluggable databases (PDB), HR_PDB and

ACCOUNTS_PDB, both of which use the CDB tablespace. The temp file is called

temp01.tmp.

A user issues a query on a table on one of the PDBs and receives the following error:

ERROR at line 1:

ORA-01565: error in identifying file ‘/u01/app/oracle/oradata/CDB1/temp01.tmp’

ORA-27037: unable to obtain file status

Identify two ways to rectify the error.

A. Add a new temp file to the temporary tablespace and drop the temp file that that

produced the error.

B. Shut down the database instance, restore the temp01.tmp file from the backup, and then

restart the database.

C. Take the temporary tablespace offline, recover the missing temp file by applying redo

logs, and then bring the temporary tablespace online.

D. Shutdown the database instance, restore and recover the temp file from the backup, and

then open the database with RESETLOGS.

E. Shut down the database instance and then restart the CDB and PDBs.

Answer: A,E

Explanation: * Because temp files cannot be backed up and because no redo is ever

generated for them, RMAN never restores or recovers temp files. RMAN does track the

names of temp files, but only so that it can automatically re-create them when needed.

* If you use RMAN in a Data Guard environment, then RMAN transparently converts

primary control files to standby control files and vice versa. RMAN automatically updates

file names for data files, online redo logs, standby redo logs, and temp files when you issue

RESTORE and RECOVER.

Examine the following commands for redefining a table with Virtual Private Database (VPD)

policies:

Question No : 1

Question No : 2

Oracle 1z0-060 : Practice Test

Which two statements are true about redefining the table?

A. All the triggers for the table are disabled without changing any of the column names or

column types in the table.

B. The primary key constraint on the EMPLOYEES table is disabled during redefinition.

C. VPD policies are copied from the original table to the new table during online

redefinition.

D. You must copy the VPD policies manually from the original table to the new table during

online redefinition.

Answer: A,C

Explanation: The triggers cloned to the interim table are disabled until the redefinition is

completed. Once the redefinition is complete, all cloned objects are renamed to the original

names used by they objects they were cloned from.

Ref: http://www.oracle-base.com/articles/10g/online-table-redefinition-enhancements-

10gr1.php

Which two statements are true about the use of the procedures listed in the

v$sysaux_occupants.move_procedure column?

A. The procedure may be used for some components to relocate component data to the

Question No : 3

Oracle 1z0-060 : Practice Test

SYSAUX tablespace from its current tablespace.

B. The procedure may be used for some components to relocate component data from the

SYSAUX tablespace to another tablespace.

C. All the components may be moved into SYSAUX tablespace.

D. All the components may be moved from the SYSAUX tablespace.

Answer: A,B

Explanation:

http://www.dba-oracle.com/t_v_sysaux_contents_tips.htm

Which statement is true about Oracle Net Listener?

A. It acts as the listening endpoint for the Oracle database instance for all local and non-

local user connections.

B. A single listener can service only one database instance and multiple remote client

connections.

C. Service registration with the listener is performed by the process monitor (LREG)

process of each database instance.

D. The listener.ora configuration file must be configured with one or more listening protocol

addresses to allow remote users to connect to a database instance.

E. The listener.ora configuration file must be located in the

ORACLE_HOME/network/admin directly.

Answer: C

You are administering a database stored in Automatic Storage Management (ASM). You

use RMAN to back up the database and the MD_BACKUP command to back up the ASM

metadata regularly. You lost an ASM disk group DG1 due to hardware failure.

In which three ways can you re-create the lost disk group and restore the data?

A. Use the MD_RESTORE command to restore metadata for an existing disk group by

passing the existing disk group name as an input parameter and use RMAN to restore the

Question No : 4

Question No : 5

Oracle 1z0-060 : Practice Test

data.

B. Use the MKDG command to restore the disk group with the same configuration as the

backed-up disk group and data on the disk group.

C. Use the MD_RESTORE command to restore the disk group with the changed disk group

specification, failure group specification, name, and other attributes and use RMAN to

restore the data.

D. Use the MKDG command to restore the disk group with the same configuration as the

backed-up disk group name and same set of disks and failure group configuration, and use

RMAN to restore the data.

E. Use the MD_RESTORE command to restore both the metadata and data for the failed

disk group.

F. Use the MKDG command to add a new disk group DG1 with the same or different

specifications for failure group and other attributes and use RMAN to restore the data.

Answer: C,D,F

Your multitenant container database, CDB1, is running in ARCHIVELOG mode and has

two pluggable databases, HR_PDB and ACCOUNTS_PDB. An RMAN backup exists for

the database.

You issue the command to open ACCOUNTS_PDB and find that the USERDATA.DBF

data file for the default permanent tablespace USERDATA belonging to ACCOUNTS_PDB

is corrupted.

What should you do before executing the commands to restore and recover the data file in

ACCOUNTS_PDB?

A. Place CDB1 in the mount stage and then the USERDATA tablespace offline in

ACCOUNTS_PDB.

B. Place CDB1 in the mount stage and issue the ALTER PLUGGABLE DATABASE

accounts_pdb CLOSE IMMEDIATE command.

C. Issue the ALTER PLUGGABLE DATABASE accounts_pdb RESTRICTED command.

D. Take the USERDATA tablespace offline in ACCOUNTS_PDB.

Answer: D

Explanation: * You can take an online tablespace offline so that it is temporarily

unavailable for general use. The rest of the database remains open and available for users

to access data. Conversely, you can bring an offline tablespace online to make the schema

objects within the tablespace available to database users. The database must be open to

Question No : 6

Oracle 1z0-060 : Practice Test

剩余129页未读，继续阅读

zhb_DD

2018-12-03

不知道这个题库的答案正确率怎么样

12cOCP题库

feilong000

粉丝: 5
资源: 7

上传资源快速赚钱

我的内容管理收起

我的资源快来上传第一个资源

我的收益

登录查看自己的收益

我的积分登录查看自己的积分

我的C币登录后查看C币余额

我的收藏

我的下载

下载帮助

会员权益专享

Oracle 12C OCP题库

评论10

会员权益专享

最新资源

Oracle 12C OCP题库

评论10

OCP 12C最新题库.zip

12cOCP题库

oracle升级OCP到12c考试题库 Oracle-1z0-060

oracle 12c OCP

oracle12c chm中文

Oracle 18c 与Oracle 12c的区别

ORacle12c在linux环境安装

oracle12c的终极版

linux oracle 12c r2 依赖

oracle 12c 数据仓库

oracle 12c linux 下载

linux系统安装oracle12c

oracle linux 8上安装oracle 12c rac

oracle 12c 64位

docke-compose oracle12c

oracle 12c linux单机

oracle12c 修改scn值6,Oracle 12c SCN推进方法汇总（一）之GDB

oracle12c client下载链接

linux安装oracle12c

oracle12c安装详解

会员权益专享

最新资源