cnblogs_5359

摘要： When does an incremental checkpoint occur ? A)when an online redo log switch occurs. B)when DBWn writes dirty buffers as part of its normal processing 阅读全文

摘要： Archivelog mode is enabled for your database and DB_CREATE_FILE_DEST is set to ‘/u01/oracle/db01’. The parameters, DB_CREATE_ONLINE_LOG_DEST_n and DB_ 阅读全文

摘要： Which two of these must be available READ/WRITE to keep a database open? A)all copies of the control file. B)the password file. C)all members of the c 阅读全文

摘要： 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 阅读全文