教学文章
Technology Exchange
Technology Exchange
热门课程
400电话
免费咨询热线
400-090-9964
2018年的时候，OCP 11g考试题库大更新，052 053出现了很多新题，
2019年，11g即将停考的前期，Oracle又出现了一次大变动，12c出现了很多新题，比如062 063题库大更新
OCP解析公开课时间：【每周五晚8点】
OCP解析公开课地址：https://ke.qq.com/course/326223
OCP解析群资料分享：1015267481 验证：ocp
-------------------------------------------------------
46题、choose two(有类似的题，但题库内容不准)
Examine this command:
SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;
Which two statements are true?
A) All DDL statements are logged in to a text file in Automatic Diagnostic Repository (ADR) home.
B) The Alert Log still contains some DDL statements.
C) Some data definition language (DDL) statements are written to the control file.
D) All data definition language (DDL) statements are written to the control file.
E) Some DDL statements are written to a text file in the ADR home.
F) Some DDL statements are written to an XML file in the ADR home.
Answer：AF
(解析： 打开 DDL 跟踪后，要通过 adrci 命令的 show log 才能够查看 DDL 日志， sys 用户的 DDL 语句也会被纪录。
adrci> show log
ADR Home = /u01/app/oracle/diag/rdbms/orcl/ORCL，在该目录下有个 log 目录，里面有ddl_ORCL.log 文本跟踪日志，同时在 log 目录下的 ddl 目录中有 log.xml 日 志文件。)
