OCP考试052必威体育精装版考试题库原题-4-20180601.pdf

052 题库解析 OCP 考试 052 必威体育精装版考试题库原题 -4 题库新特点： 更加灵活，题库的顺序与考试时的顺序每场都在变化 更加考验知识点的掌握，题库答案为二，考试时要求选择 最佳一个答案 不断有新的考题出现，目前必威体育精装版已经更新到 130 道题 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 、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 、Yo u 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