cnblogs_5359

摘要： Which three of these must be accessible to keep a database open? A)Control file. B)All members of a redo log group. C)SYSTEM tablespace. D)SYSAUX tabl 阅读全文

摘要： Which four database objects never have any segments? A)A partitioned index B)A view selecting from a populated table C)An empty index D)An Oracle Load 阅读全文

摘要： Which structure can span multiple data files? A)a bigfile tablespace B)a permanent tablespace C)a segment D)a temporary tablespace E)an extent Answer: 阅读全文

摘要： 11g版本的OCP考试持续了好几年，一直比较稳定，直到2018年4月份左右，052考试不断的出现新的考题，虽然我们收集整理了不少，但新题还是难避免，这样出现一部分新题，我们收集一部分，持续了不短的时间。 对于这些052考试新题，不仅老师给出了答案，学员也积极的找资料、查文档，形成了一份内部综合版本， 阅读全文

摘要： Which four are true about the Archive (ARCn) processes? A)They might be used during instance recovery. B)They can create archivelogs. C)They are alway 阅读全文

摘要： Which two are true about the Archive (ARCn) processes? A)They archive redo directly from the redo log buffer. B)They are used during instance recovery 阅读全文

摘要： Which two are true about LGWR? A)LGWR always writes to the redo logs each time a COMMIT occurs. B)LGWR always writes to the redo logs each time a ROLL 阅读全文

摘要： Which three events always result in a write request made to the LGWR process? A)after undo is applied by PMON during process recovery B)when dirty buf 阅读全文

摘要： Which two events always request the LGWR to write? A)When DBWn writes dirty buffers. B)When a log switch occurs. C)When a checkpoint occurs. D)When LG 阅读全文

摘要： Which four are true about the Automatic Workload Repository (AWR)? A)AWR data can be retained for a month. B)It includes statistics on the number of c 阅读全文