ocp认证考试052最新考试题库解析.pptx

2018年OCP 052最新考试题库解析-20180601
题库新特点：
 更加灵活，题库的顺序与考试时的顺序每场都在变化
 更加考验知识点的掌握，题库答案为二，考试时要求选择最佳一个答案
 
整理：CUUG
1
.
2018年OCP 052最新考试题库解析-20180601
1、Your database Is configured In archivelog mode.
The USERS01 tablespace Is currently online.
You are required to take the tablespace offline.
Which clause or clauses ensure that no media recovery is required
when the tablespace Is brought back online?
• ❑ A) either the NORMAL or the TEMPORARY clause
• ❑ B) only the NORMAL clause
• ❑ C) only the TEMPORARY clause
• ❑ D) either the NORMAL or the IMMEDIATE clause
• ❑ E) only the IMMEDIATE clause
• Answer:B
1 offline temporary 表空间时，如果表空间中没有offline的数据文件，则online该表空间时不需要介质恢复。
2 offline temporary 表空间时，不会对已经offline的数据文件执行检查点操作，仅仅对online的数据文件执
行检查点操作
3 offline temporary 表空间时，对于离线表空间之前已经offline的数据文件，则online该表空间时，offline数
据文件需要介质恢复。
2
.
2018年OCP 052最新考试题库解析-20180601
• 2、Which two statements are true about tablespaces?
• ❑ A) A database can contain multiple undo tablespaces.
• ❑ B) A database can contain only a single temporary tablespace.
• ❑ C) A database instance stores undo data In the SYSTEM tablespace If no undo tablespace exists.
• ❑ D) A database instance hangs If the SYSAUX tablespace becomes unavailable.
• ❑ E) A database with a locally managed SYSTEM tablespace can have dictionary-managed user tablepaces.
• Answer:AE
3
.
2018年OCP 052最新考试题库解析-20180601
• 3、You want to Install Oracle 11g database software and create a database on ASM Immediately after the Install.
Your plan is to install both Oracle database and Grid Infrastructure.
Which two are true in this scenario?
• ❑ A) Grid Infrastructure must be installed first.
• ❑ B) Both products must be Installed by the same OS user.
• ❑ C) Each product must be Installed In a different ORACLE_HOME.
• ❑ D) Both products can share the OS group assigned to their OSDBA and OSOPER privileged groups
• ❑ E) Both products must be installed by using the same ORACLE_BASE.
• ❑ F) Both products must be of the same version.
• Answ