OCP考试052最新考试题库原题40601.docx

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

2、lauses 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 表空间时，如

3、果表空间中没有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)

4、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-

5、managed user tablepaces. Answer:AE 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

6、) 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

7、 the same version. Answer:AC4、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 automatica

8、lly 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:D5、 Which is true about the SYSTEM and SYSAUX tablespaces? A) The SYSAUX

9、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:A6、 Wh

10、ich 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 SYS

11、DBAprivilege. Answer:AB7、 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 databas

12、es 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 ve

13、rsion 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:ADE8、Which two are true about data dictionary and dynamic performance views (v$ views)? A) All database users have acce

14、ss 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

15、to all v$ views. Answer:AB9、 YOUR DB_RECOVERY_FILE_DEST_SIZE Is 8G.Currently, 5G of the space Is used of which 4G consists of obsoletebackups.You execute this command:SQL ALTER SYSTEM SET db_recovery_file_dest_size=2G;What is the outcome? A) It changes DB_RECOVERY_FILE_DEST_SIZE to 5G. B) It changes

16、 DB_RECOVERY_FILE_DEST_SIZE to 2G withoutdeleting valid backups. C) It falls because DB_RECOVERY_FILE_DEST_SIZE is a staticparameter. D) It changes DB_RECOVERY_FILE_DEST_SIZE to 2G and deletesthe obsolete backups. E) It fails because the new size is less than 5G. Answer:D10、 Which is true about logi

17、cal and physical database structures? (Choose the best answer) A. An undo tablespace has a temp file instead of a data file. B. A segment can consist of extents of different sizes. C. A permanent tablespace can only contain tables segmentsand index segments. D. A tablespace can consist of data block

18、s of different sizes. E. An extent always consists of physically contiguous datablocks in storage. Correct Answer: B 11、 In which state can you back up a database inARCHIVELOGMODE using RMAN? A. NOMOUNT, MOUNT, AND OPEN B. NOMOUNT AND MOUNT ONLY C. OPEN ONLY D. MOUNT AND OPEN ONLY E. OPEN RESTRICTED

19、 ONLY Correct Answer: D12、 Examine these facts about a database: 1. USERS is the database default tablespace.2. USER1, USER2, AND USER3 have the CREATE SESSION privilege.3. They also have UNLIMITED QUOTA on the default tablespace USERS.4. They have no other privileges. Examine these commands: SQL co

20、nn / as sysdba Connected.SQL GRANT CREATE TABLE TO user1 WITH ADMIN OPTION;Grant succeeded.SQL conn user1/oracle_4U Connected.SQL GRANT CREATE TABLE TO user2;Grant succeeded.SQL GRANT CREATE TABLE TO user3 WITH ADMIN OPTION;Grant succeeded.12、 Which two are true? A. Any user with create table with a

21、dmin option can revoke create tablefrom user1. B. If SYS revokes create table from user1, it is revoked from user2 but notfrom user3. C. Only SYS and USER1 can revoke CREATE TABLE from USER3. D. Only SYS CAN REVOKE CREATE TABLE FROM USER1. E. If SYS revokes create table from user1, it is not revoked

22、 from USER2 andUSER3. Correct Answer: AE13、Which two are true about external tables? A. They support the ORACLE_DATAPUMP access driver. B. They have extents. C. They support all DML operations. D. They can always be updated using SQL. E. They can be stored in an ASM Cluster File System (ACFS). Corre

23、ct Answer: AE14、In one of your databases:* The database default tablespace is EXAMPLE.* Deferred_segment_creation is false.Examine these commands:SQL create user user1 identified by oracle_4u password expire;User created.SQL alter user user1 account unlock;User altered.SQLgrant create session to use

24、r1;Grant succeeded.SQL grant create table to user1 with admin option;Grant succeeded.14、Which three are true? A. user1 can log in to the database instance. B. user1 can grant the create table privilege to other users. C. user1 can create tables in the example tablespace. D. user1 must change it s pa

25、ssword at first login. E. user1 can create indexes in example tablespace. Correct Answer: ABD15、Which is true when a database instance is shut down? A. Only transactional and normal modes wait for all uncommitted transactions to commit or rollback and then close the database. B. Immediate, transactional, and normal modes all result in acheckpoint. C. Neither the immediate nor the abort mode rolls backuncommitted transactions. D. Immediate, transactional, and normal modes wait for all uncommitted transactions either to commit or rollback and then close the database. Correct Answer: AB