Oracle OCP 052最新考试题库解析-20180608
更新时间:2024-04-05 09:10:02 阅读量: 综合文库 文档下载
- oracle推荐度:
- 相关推荐
2018年OCP 052最新考试题库解析-20180608
题库新特点:
更加灵活,题库的顺序与考试时的顺序每场都在变化
更加考验知识点的掌握,题库答案为二,考试时要求选择最佳一个答案
整理:CUUG
1、Which three are true about undo segments and undo tablespaces in the same database and instance?
? A. Multiple transactions run by the same Oracle user can share a single undo segment. ? B. Multiple transactions run by different Oracle users can share a single undo segment. ? C. A serial transaction can use multiple undo segments.
? D. Undo segments are automatically dropped shortly after transactions that use them commit. ? E. A new undo segment is always created for each transaction. ? F. A database can have multiple undo tablespaces. ? Correct Answer: ABF
2、Which two are true about the Data Recovery Advisor?
? A. It can be used only for databases that are running in ARCHIVELOG mode. ? B. It can be used when the database is closed.
? C. It can be used to validate database recovery strategies. ? D. It provides intelligent database problem analysis. ? E. It can be used to validate database backup strategies.
? F. It can be used only for databases with FLASHBACK enabled. ? Correct Answer: CD
3、Which two are true about Oracle Data Pump in Oracle Database 11g Release 2?
? A. If the directory used in the export operation has existing dump files, it overwrites them. ? B. It allows encryption to be performed without using a password. ? C. It supports the renaming of tables during import. ? D. It supports the export of specific views as tables.
? E. It allows compression levels to be defined for the export. ? Correct Answer: BE
4、 For your ORCL database.
1. The instance is started using an spfile. 2. The database is opened. 3. It is in ARCHIVELOG mode.
4. CONTROL FILE AUTOBACKUP IS ON. Examine this command:
RMAN> backup as copy datafile ‘users01.dbf’,’example01.dbf’; Which four files are backed up? ? A. spfile
? B. undo01.dbf ? C. users01.dbf ? D. archivelogs ? E. sysaux01.dbf ? F. control file ? G. system01.dbf ? H. example01.dbf Correct Answer: ACFH
5、 When does an incremental checkpoint occur?
? A. when DBWn writes dirty buffers as part of its normal process ? B. when the alter system checkpoint statement is executed. ? C. when a user tablespace is taken offline ? D. when an online redo log switch occurs ? Correct Answer: A
6、 Examine this query and its output: SQL> select sid,event,blocking_session from v$session
where blocking_session is not null; SID EVENT BLOCKING_SESSION --- ----------------------------------- --------------------------- 105 enq:TX – row lock contention 15
Which two are true?
? A. The blocked session is waiting on a shared table lock. ? B. The blocked session is waiting on an enqueue. ? C. The blocking session is waiting on a row-level lock. ? D. Session 105 is blocked by session 15. ? E. Session 105 is blocking session 15. ? Correct Answer: BD
? 7、 In one of your databases:
1. USER1 and USER2 have no system privileges. 2. ROLE1 only has these privileges: * create session * create table * create view
Examine these commands: SQL> conn / as sysdba Connected
SQL> GRANT create table,role1 to user1 with admin option; grant successed
SQL> conn user1/oracle_4u Connected
SQL> GRANT role1 to user2; grant successed
7、Which command would you execute and as which user, to revoke the create table privilege from USER2?
? A. Revoke create table from user2 as user1 ? B. Revoke create table from user1 as sys ? C. Revoke create table from role1 as user1 ? D. Revoke create table from role1 as sys ? E. Revoke create table from user2 as sys ? Correct Answer: D
如果用user1回收角色的权限,会报错: SQL> revoke create session from role1; revoke create session from role1 *
ERROR at line 1:
ORA-01031: insufficient privileges
8、 Which two are true about server-generated alerts? ? A. Stateful alerts must always be cleared manually.
? B. They are visible in Oracle Enterprise Manager by default. ? C. All stateful alerts can be found in DBA_ALERT_HISTORY. ? D. They can be based only on database metrics.
? E. Stateless alerts cannot be found in DBA_OUTSTANDING_ALERTS. ? F. They can be based only on instance metrics. ? Correct Answer: BE
9、 Your database instance is in NOMOUNT state.
Your select the delete option in the database configuration assistant (DBCA) for your database. What is the outcome?
? A. DBCA is able to delete the data files but not the services. ? B. DBCA shuts down the instance and deletes the database. ? C. DBCA is able to delete the services but not the data files.
? D. DBCA prompts you to open the database, and then proceeds with the deletion. Correct Answer: D
10、 Which is true when a database instance is shut down?
? A. IMMEIATE, TRANSACTIONAL, and NORMAL modes wait for all uncommitted transactions either to commit or rollback and then close the database
? B. IMMEIATE, TRANSACTIONAL, and NORMAL modes all result in a checkpoint
? C. Only TRANSACTIONAL, and NORMAL modes wait for all uncommitted transactions to commit or rollback and then close the database
? D. Neither the IMMEDIATE nor the ABORT mode rolls back uncommitted transactions. Correct Answer: B
11 、 The ORCL database has CONTROL FILE AUTOBACKUP and BACKUP OPTIMIZATION enabled. USER1.EMP is a table in tablespace TBS1. There are no existing backups of the database. Examine these commands: $rman target /
RMAN> BACKUP DATABASE RMAN> exit
$sqlplus / as sysdba
SQL>UPDATE USER1.EMP set SAL=5000 WHERE eno=10;
1 row updated SQL>COMMIT Commit Complete SQL>exit
RMAN>CONFIGURE EXECUTE FOR TABLESPACE tbs1; RMAN>BACKUP INCREMENTAL LEVEL 1 DATABASE; ? What is the outcome?
? A. It takes a level 0 incremental backup of ORCL with TBS1. ? B. It takes a level 1 incremental backup of ORCL without TBS1. ? C. It takes a level 0 incremental backup of ORCL without TBS1. ? D. It takes a level 1 incremental backup of ORCL with TBS1. ? Correct Answer: C
12、 Which two statements are true about dispatchers used by the Oracle shared server? ? A. Multiple user processes can connect to a single dispatcher.
? B. They return completed requests to the appropriate user processes. ? C. A dispatcher is created for each user process.
? D. Multiple dispatchers can connect to a single server process.
? E. They pull requests from the requests queue and process them until they are complete. ? Correct Answer: AB
13、 Examine this session output: SQL>connect scott/tiger Connected
SQL>select name,value from v$parameter where name =’audit_trail’; NAME VALUE -------- -------- audit_trail DB SQL>audit all on emp; Audit succeeded
Which two will generate an audit record?
? A. every DDL statement executed by SCOTT that affects SCOTT.EMP
? B. every UPDATE statement executed by SCOTT that updates SCOTT.EMP
? C. only the first SELECT statement executed by SCOTT is a session on SCOTT.EMP ? D. only the first DML statement executed by SYSTEM in a session on SCOTT.EMP ? E. every UPDATE statement executed by SCOTT that updates HR.EMP ? F. any DML statement executed by SYS on SCOTT.EMP
? Correct Answer: AB
14、In which two cases is a consistent database backup created?
? A. when the RMAN BACKUP command is used while the database is OPEN READ ONLY
? B. when the RMAN BACKUP AS COPY command is used while the database is OPEN RESTRICTED
? C. when the RMAN BACKUP AS COPY command is used while the database is OPEN
? D. when O/S commands are used to copy database files after a database instance is shut down normally
? E. when the RMAN BACKUP command is used while the database is mounted Correct Answer: AD
只读表空间下用rman备份时没有发生检查点,无需更改数据文件头部,所以可以 备份数据库。
15、 Which two are true about UNDO data? ? A. Inactive UNDO is never written to disk. ? B. Active UNDO is always kept in memory ? C. Only DML statements generate UNDO. ? D. Active UNDO can never be overwritten.
? E. It can be used to restore a table by using FLASHBACK TABLE.
? F. Inactive UNDO cannot be overwritten until the elapsed time since becoming inactive exceeds UNDO RETENTION. Correct Answer: DE
16、 You successfully executed these commands: CONNECT scott/tiger@prod1
CREATE DATEBASE LINK db_prod2 CONNECT TO scott IDENTIFIED BY tiger USING ‘PROD2’
Which type of database link is created? ? A. private current user database link. ? B. public current user database link
? C. private fixed user database link ? D. public connected user database link ? E. public fixed user database link Correct Answer: C
Create database link connect to current …
正在阅读:
Oracle OCP 052最新考试题库解析-2018060804-05
初中学生自我评价【精选3篇】03-26
上海市金融办、上海工商局、国税局、地税局关于本市股权投资企业04-21
社会实践报告(精选47篇)03-31
电大终结性《地域文化(本)》04-28
实习报告苏嵌09-27
关于暑假社会实践报告(精选7篇)03-31
工厂打工社会实践报告【优秀10篇】03-26
大学生工厂打工社会实践报告03-10
- 多层物业服务方案
- (审判实务)习惯法与少数民族地区民间纠纷解决问题(孙 潋)
- 人教版新课标六年级下册语文全册教案
- 词语打卡
- photoshop实习报告
- 钢结构设计原理综合测试2
- 2014年期末练习题
- 高中数学中的逆向思维解题方法探讨
- 名师原创 全国通用2014-2015学年高二寒假作业 政治(一)Word版
- 北航《建筑结构检测鉴定与加固》在线作业三
- XX县卫生监督所工程建设项目可行性研究报告
- 小学四年级观察作文经典评语
- 浅谈110KV变电站电气一次设计-程泉焱(1)
- 安全员考试题库
- 国家电网公司变电运维管理规定(试行)
- 义务教育课程标准稿征求意见提纲
- 教学秘书面试技巧
- 钢结构工程施工组织设计
- 水利工程概论论文
- 09届九年级数学第四次模拟试卷
- 考试题库
- 20180608
- 解析
- Oracle
- 最新
- OCP
- 052
- XXX县地名普查项目实施方案
- 文献综述
- cadence - FlowPlan操作
- 电动公交汽车项目可行性研究报告 - 图文
- 2013秋浙大远程管理统计学在线作业答案(最新)
- 鄂教版三年级品德下册书本知识总复习
- 医院信息科考试试题大全
- 《广州市建设项目安全生产管理资料目录(2014年版)》-20140828x
- 重庆市国有资产监督管理委员会关于印发《重庆市市属国有重点企业
- 电工学(I)电子教案
- 招标目录
- 00 解析柏拉图的理念爱情观0000
- 民用建筑施工图节能设计和审查要点
- 综合布线系统改造方案
- 青府办发(2008)84号2009124111917 青白江区地震后购房补贴政策
- 山东省国土资源厅
- CPSM M1模拟试题(3)
- 关于发布《证券投资基金会计核算业务指引》的通知
- 社会工作概论(补修课)选择判断答案
- 达州市第三次党代会工作报告