cuug-北京神脑咨询,专注于oracle dba就业培训和ocp、ocm高端认证培训,甲骨文授权合作wdp中心,oracle评选的金牌名师亲自讲课,ocp讨论3组:101-5267-481,验证:ocp
能力说明:
具备数据库基础知识,了解数据库的分类,具备安装MySQL数据库的能力,掌握MySQL数据类型知识,基本了解常用SQL语句,对阿里云数据库产品有基本认知。
暂时未有相关云产品技术能力~
阿里云技能认证
详细说明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_RECOVERY_FILE_DEST, and not specified.
Which two of these must be available READ/WRITE to keep a database open? A)all copies of the control file.
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 tablespace. E)spfile Answer: ABC 赵: 1 nomount:实例已经启动,进程和内存已经分配。
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 Loader type external table E)An empty table F)A view selecting from an empty table G)An Oracle Data Pump type external table Answer: BDFG 赵:视图和外部表不存在段。
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考试不断的出现新的考题,虽然我们收集整理了不少,但新题还是难避免,这样出现一部分新题,我们收集一部分,持续了不短的时间。
Which four are true about the Archive (ARCn) processes? A)They might be used during instance recovery.
Which two are true about the Archive (ARCn) processes? A)They archive redo directly from the redo log buffer.
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.
Which two events always request the LGWR to write? A)When DBWn writes dirty buffers. B)When a log switch occurs.
Which four are true about the Automatic Workload Repository (AWR)? A)AWR data can be retained for a month.
Which three are true about AWR snapshots? A)They are always created automatically. B)They are always created manually.
Which two are true about AWR snapshots? A)They are stored in the SYSAUX tablespace. B)They are always created automatically.
Which three are true about the Automatic Workload Repository (AWR)? A)AWR data is stored in the SYSTEM tablespace.
Which three are true about the Automatic Workload Repository (AWR)? A)AWR data is stored in the SYSTEM tablespace.
Which three are true about the Automatic Workload Repository (AWR)? A)AWR data is stored in the SYSAUX tablespace.
Which two are true about Optimizer Statistics? A)They are gathered by the Manageability Monitor(MMON) background process.
Which two are true about Oracle's Optimizer statistics? A)They are automatically updated when ddl statements execute.
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.
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 译:它们必须处于要重新编译的无效状态。
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.
Examine these attributes for the profile assigned to USER1 whose password is oracle_4U • PASSWORD_REUSE_MAX is 5 • PASSWORD_REUSE_TIME is 10 ...
Examine these attributes for the profile assigned to USER1 whose password is oracle_4U. • PASSWORD_REUSE_MAX is 5.
Which four statements are true about truncating a table? A)Any insert triggers for the table will be executed.
Each row in the TRANS_SUMMARY table contains details of one product. Each row in the TRANS_MONTHLY table contains transaction details either for ...
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.
USER1.EMP has a referential integrity constraint defined on EMP.DNO that references USER1.DEPT.DNO.