ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2018-07-31 13:28:10
29、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.SQL>gr.........【阅读全文】
发布时间：2018-07-31 11:50:08
28、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).Correct Answer: AE.........【阅读全文】
发布时间：2018-07-30 15:06:05
27、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> c.........【阅读全文】
发布时间：2018-07-30 14:35:05
26、In which state can you back up a database in ARCHIVELOGMODE using RMAN?A. NOMOUNT, MOUNT, AND OPENB. NOMOUNT AND MOUNT ONLYC. OPEN ONLYD. MOUNT AND OPEN ONLYE. OPEN RESTRICTED ONLYCorrect Answer: D......【阅读全文】
发布时间：2018-07-27 15:19:27
25、Which is true about logical 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 segments and index segments..........【阅读全文】
