ocp考试资料群:569933648 验证码:ocp OCP 12c 19c考试题库解析与资料群:钉钉群号:35277291
全部博文(487)
发布时间: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..........【阅读全文】
发布时间:2018-07-27 15:00:21
24、 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_dest_size=2G;What is the outcome?A) It changes DB_RECOVERY_FILE_DEST_SIZE to 5G.B) It chan.........【阅读全文】
发布时间:2018-07-26 11:07:52
23、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 dynamic performance views are stored In the.........【阅读全文】