1. 云栖社区>
  2. 全部标签>
  3. #052#
052

#052#

已有0人关注此标签

内容分类:
博客 | 问答 | 视频 | 资料 |

OCP-052考试题库汇总(22)-CUUG内部解答版

Which four are true about the Archive (ARCn) processes? A)They might be used during instance recovery.

Oracle 日志 LOG 数据库 Create OCP cuug 052

OCP-052考试题库汇总(21)-CUUG内部解答版

Which two are true about the Archive (ARCn) processes? A)They archive redo directly from the redo log buffer.

Oracle 日志 LOG 数据库 database OCP cuug 052

OCP-052考试题库汇总(20)-CUUG内部解答版

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 ROLLBACK occurs.

Oracle request BY Group Commit single OCP cuug 052

OCP-052考试题库汇总(18)-CUUG内部解答版

Which two events always request the LGWR to write? A)When DBWn writes dirty buffers. B)When a log switch occurs.

Oracle 日志 LOG events request Server Commit OCP cuug 052

OCP-052考试题库汇总(17)-CUUG内部解答版

Which four are true about the Automatic Workload Repository (AWR)? A)AWR data can be retained for a month.

Oracle statistics IT view OCP cuug 052

OCP-052考试题库汇总(16)-CUUG内部解答版

Which three are true about AWR snapshots? A)They are always created automatically. B)They are always created manually.

Oracle OCP cuug 052

OCP-052考试题库汇总(15)-CUUG内部解答版

Which two are true about AWR snapshots? A)They are stored in the SYSAUX tablespace. B)They are always created automatically.

Oracle BY OCP cuug 052

OCP-052考试题库汇总(14)-CUUG内部解答版

Which three are true about the Automatic Workload Repository (AWR)? A)AWR data is stored in the SYSTEM tablespace.

Oracle BY database IT OCP cuug 052

OCP-052考试题库汇总(13)-CUUG内部解答版

Which three are true about the Automatic Workload Repository (AWR)? A)AWR data is stored in the SYSTEM tablespace.

Oracle 性能 database OCP cuug 052

OCP-052考试题库汇总(12)-CUUG内部解答版

Which three are true about the Automatic Workload Repository (AWR)? A)AWR data is stored in the SYSAUX tablespace.

Oracle BY statistics IT OCP cuug 052

OCP-052考试题库汇总(11)-CUUG内部解答版

Which two are true about Optimizer Statistics? A)They are gathered by the Manageability Monitor(MMON) background process.

Oracle SQL events BY database statistics OCP cuug 052

OCP-052考试题库汇总(10)-CUUG内部解答版

Which two are true about Oracle's Optimizer statistics? A)They are automatically updated when ddl statements execute.

Oracle DML statistics OCP cuug 052

OCP-052考试题库汇总(9)-CUUG内部解答版

Which three are true about Optimizer Statistics? A)They can be gathered manually B)They are automatically updated by DML statements C)They contain the execution plan for each executed SQL statement.

Oracle SQL BY DML statistics OCP cuug 052

OCP-052考试题库汇总(8)-CUUG内部解答版

  Which two are true about PL/SQL objects?   A)They must be in an invalid state to be recompiled.   B)They can never be manually recompiled.   C)They can be manually recompiled.   D)They must be manually recompiled.   E)They can be automatically recompiled.   Answer: CE   赵:   A 译:它们必须处于要重新编译的无效状态。

函数 Oracle SQL 存储过程 OCP cuug 052

OCP-052考试题库汇总(7)-CUUG内部解答版

  Which is true about invalid PL/SQL objects?   A)They are automatically recompiled against the new definition of a referenced object when they are called.

Oracle SQL OCP cuug 052

OCP-052考试题库汇总(6)-CUUG内部解答版

  Examine these attributes for the profile assigned to USER1 whose password is oracle_4U   • PASSWORD_REUSE_MAX is 5   • PASSWORD_REUSE_TIME is 10   ...

Oracle account OCP cuug 052

OCP-052考试题库汇总(5)-CUUG内部解答版

  Examine these attributes for the profile assigned to USER1 whose password is oracle_4U.   • PASSWORD_REUSE_MAX is 5.

Oracle last OCP cuug 052

OCP-052考试题库汇总(4)-CUUG内部解答版

  Which four statements are true about truncating a table?   A)Any insert triggers for the table will be executed.

Oracle OCP cuug 052

OCP-052考试题库汇总(3)-CUUG内部解答版

  Each row in the TRANS_SUMMARY table contains details of one product.   Each row in the TRANS_MONTHLY table contains transaction details either for ...

Oracle Transaction Create update OCP 052

OCP-052考题汇总(2)-CUUG内部解答版

  Examine these commands and their output:   SQL> SELECT * FROM emp;   ENO ENAME   --- -------   100 Adam   101 Alan   SQL> INSERT INTO emp VALUES(102,'Ben');   1 row created.

Oracle SQL update Commit OCP cuug 052

4
GO