《OCP最新考试题库解析之052考试原题-4-20180601》由会员分享，可在线阅读，更多相关《OCP最新考试题库解析之052考试原题-4-20180601（19页珍藏版）》请在金锄头文库上搜索。
1、052题库解析,最新15道题 052-题库解析-4-20180601,题库新特点：, 更加灵活，题库的顺序与考试时的顺序每场都在变化, 更加考验知识点的掌握，题库答案为二，考试时要求选择 最佳一个答案, 不断有新的考题出现，目前最新已经更新到130道题 每周五晚8点-直播地址： ocp考试讨论群：836361015 验证：ocp CUUG整理，官网：,1、Your database Is configured In archivelog mode. The USERS01 tablespace Is currently online. Yo u are required to take the
2、 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 cl
3、ause 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 databas
4、e 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 local
5、ly 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 scenar
6、io? 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
7、 using the same,ORACLE_BASE. F) Both products must be of the same version. Answer:AC,4、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 r
8、ecompiled only by using SQL,commands., C) They are automatically recompiled against the new,definition 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:D,5、 Whic
9、h is true about the SYSTEM and SYSAUX tablespaces? A) The SYSAUX tablespace can be made read-only but the SYSTEM tablespace cannot. B) Both tablespaces can be used for temporary storage if no temporary tablespace is defined. C) Only the SYSTEM tablespace contains data dictionary,tables., D) Both tab
10、lespaces must be online for a database to be accessible. Answer:A,6、 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 not multipl
11、e object privileges. E) A role can be created only by a user with the SYSDBA,privilege. Answer:AB,7、 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 Grid Infrastructure for a Standalone
12、Server. Which three are true in this scenario?, A) Oracle 11g Release 1 databases must be managed by Grid Infrastructure,11g 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 same,O/S account., D) Gi
13、rd Infrastructure must be installed before both Oracle Database,versions., E) Each version of the database may be managed by a separate version of Grid Infrastructure. F) Both Oracle versions and Grid Infrastructure can be installed under the same ORCALE_BASE. Answer:ADE,8、Which two are true about d
14、ata 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 dynamic performance views are stored In the data dictionary. D) All v$ views display o
15、utput when queries, if the instance is in nomount state E) All database users have access to all v$ views. Answer:AB,9、 YOUR DB_RECOVERY_FILE_DEST_SIZE Is 8G. Currently, 5G of the space Is used of which 4G consists of obsolete backups. You execute this command: SQL ALTER SYSTEM SET db_recovery_file_
16、dest_size=2G; What is the outcome? A) It changes DB_RECOVERY_FILE_DEST_SIZE to 5G. B) It changes DB_RECOVERY_FILE_DEST_SIZE to 2G without deleting valid backups. C) It falls because DB_RECOVERY_FILE_DEST_SIZE is a static,parameter., D) It changes DB_RECOVERY_FILE_DEST_SIZE to 2G and deletes,the obsolete backups. E) It fails because the new size is less than 5G. Answer:D,
