Exam 1z0-062 topic 2 question 13 discussion

Actual exam question from Oracle's 1z0-062

Question #: 13
Topic #: 2

[All 1z0-062 Questions]

Examine this command:
SQL> ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;
Which two statements are true? (Choose two.)

A. All data definition language (DDL) statements are written to the control file
B. Some DDL statements are written to an XML file in the ADR home
C. All DDL statements are logged in to a text file in Automatic Diagnostic Repository (ADR) home
D. Some 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. The Alert Log still contains some DDL statements

Show Suggested Answer

Suggested Answer: BE 🗳️

by sherifelia at Nov. 23, 2019, 12:49 p.m.

Comments

Submit Cancel

sherifelia

Highly Voted 5 years, 6 months ago

BE is correct

upvoted 15 times

...

taiyang

Highly Voted 5 years, 2 months ago

BE is correct,too

upvoted 8 times

...

dfabac

Most Recent 2 years, 11 months ago

Selected Answer: BE

Answer is BE

upvoted 1 times

...

ENABLE_DDL_LOGGING enables or disables the writing of a subset of data definition language (DDL) statements to a DDL log. The DDL log is a file that has the same format and basic behavior as the alert log, but it only contains the DDL statements issued by the database. The DDL log is created only for the RDBMS component and only if the ENABLE_DDL_LOGGING initialization parameter is set to true. When this parameter is set to false, DDL statements are not included in any log. The DDL log contains one log record for each DDL statement issued by the database. The DDL log is included in IPS incident packages. There are two DDL logs that contain the same information. One is an XML file, and the other is a text file. The DDL log is stored in the log/ddl subdirectory of the ADR home.

upvoted 2 times

...

jobao

4 years, 4 months ago

Correct Answer: BC