cuug-北京神脑咨询,专注于oracle dba就业培训和ocp、ocm高端认证培训,甲骨文授权合作wdp中心,oracle评选的金牌名师亲自讲课,ocp讨论3组:101-5267-481,验证:ocp
能力说明:
具备数据库基础知识,了解数据库的分类,具备安装MySQL数据库的能力,掌握MySQL数据类型知识,基本了解常用SQL语句,对阿里云数据库产品有基本认知。
暂时未有相关云产品技术能力~
阿里云技能认证
详细说明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.
-------------------------