CUUG内部OCP题库解析-052-文档4

CUUG内部OCP题库解析-052-文档4题库新特点：oracle 11g版本的ocp认证考试题库，来自cuug整理，考试题大部分都在这里能找到，如果想考ocp认证可以参考这些文档。下面的题是052（考试-第4个文档）里的一些考题。其他题找相关文档，或者在群里讨论101-5267-481Administrator CUUG内部OCP题库解析-052-文档4 7/17/191、Your database Is configured In archivelog mode.The USERS01 tablespace Is currently online.Yo u are required to take the tablespace offline.Which clause or clauses ensure that no media recovery is requiredwhen 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:B1 offline temporary 表空间时，如果表空间中没有offline的数据文件，则online该表空间时不需要介质恢复。2 offline temporary 表空间时，不会对已经offline的数据文件执行检查点操作，仅仅对online的数据文件执行检查点操作3 offline temporary 表空间时，对于离线表空间之前已经offline的数据文件，则online该表空间时，offline数 据Adm文in件ist需rat要or 介质恢复。 CUUG内部OCP题库解析-052-文档4 7/17/19 2、Which two statements are true about tablespaces? A) A database can contain multiple undo tablespaces. B) A database can contain only a single temporarytablespace. C) A database instance stores undo data In the SYSTEMtablespace If no undo tablespace exists. D) A database instance hangs If the SYSAUX tablespacebecomes unavailable. E) A database with a locally managed SYSTEM tablespacecan have dictionary-managed user tablepaces. Answer:AEAdministrator CUUG内部OCP题库解析-052-文档4 7/17/19 3、Yo u want to Install Oracle 11g database software andcreate 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 differentORACLE_HOME. D) Both products can share the OS group assigned to theirOSDBA and OSOPER privileged groups E) Both products must be installed by using the sameORACLE_BASE. F) Both products must be of the same version. Answer:ACAdministrator CUUG内部OCP题库解析-052-文档4 7/17/194、Which is true about invalid PL/SQL objects? A) They are automatically recompiled against the new definition of a referenced object at the same time as the referenced object is modified. B) They can be manually recompiled only by using SQLcommands. C) They are automatically recompiled against the newdefinition of a referenced object when they are called. D) They must be manually recompiled before they can be used if a DDL is performed on a table that is referenced in the PL/SQL object. Answer:DAdministrator CUUG内部OCP题库解析-052-文档4 7/17/195、 Which is true about the SYSTEM and SYSAUX tablespaces? A) The SYSAUX tablespace can be made read-only but theSYSTEM tablespace cannot. B) Both tablespaces can be used for temporary storage if notemporary tablespace is defined. C) Only the SYSTEM tablespace contains data dictionarytables. D) Both tablespaces must be online for a database to beaccessible. Answer:AAdministrator CUUG内部OCP题库解析-052-文档4 7/17/196、 Which two are true about roles? A) A role can be password-protected. B) A role can be granted to another role. C) Only one default role can be granted to a user. D) A role can be granted only multiple system privileges notmultiple object privileges. E) A role can be created only by a user with the SYSDBAprivilege. Answer:ABAdministrator CUUG内部OCP题库解析-052-文档4 7/17/197、 You are planning a software installation for both Oracle Database 11g Release 1 and Release 2.You plan to have at lease one database for each release managed by GridInfrastructure for a Standalone Server.Which three are true in this scenario? A) Oracle 11g Release 1 databases must be managed by Grid Infrastructure11g Release 1. B) Both databases can be managed by Grid Infrastructure 11g Release 2. C) Both Oracle versions and Grid Infrastructure can be owned by the sameO/S account. D) Gird Infrastructure must be installed before both Oracle Databaseversions. E) Each version of the database may be managed by a separate version ofGrid Infrastructure. F) Both Oracle versions and Grid Infrastructure can be installed under thesame ORCALE_BASE. Answer:ADEAdministrator CUUG内部OCP题库解析-052-文档4 7/17/198、Which two are true about data dictionary and dynamic performance views (v$ views)? A) All database users have access to ALL_* views. B) Data dictionary view output is subject to read consistency. C) The defining queries for Oracle supplied dynamicperformance views are stored In the data dictionary. D) All v$ views display output when queries, if the instance is innomount state E) All database users have access to all v$ views. Answer:ABAdministrator CUUG内部OCP题库解析-052-文档4 7/17/199、 YOUR DB_RECOVERY_FILE_DEST_SIZE Is 8G.Currently, 5G of the space Is u