ExamTopics Logo
Mail Us[email protected]
Menu
Oracle Discussions
exam questions

Exam 1z0-062 All Questions

View all questions & answers for the 1z0-062 exam
Go to Exam

Exam 1z0-062 topic 1 question 142 discussion

Actual exam question from Oracle's 1z0-062
Question #: 142
Topic #: 1
[All 1z0-062 Questions]

Examine the following command;
ALTER SYSTEM SET enable_ddl_logging = TRUE;
Which statement is true?

  • A. Only the data definition language (DDL) commands that resulted in errors are logged in the alert log file.
  • B. All DDL commands are logged in the alert log file.
  • C. All DDL commands are logged in a different log file that contains DDL statements and their execution dates.
  • D. Only DDL commands that resulted in the creation of new segments are logged.
  • E. All DDL commands are logged in XML format in the alert directory under the Automatic Diagnostic Repository (ADR) home.
Show Suggested Answer Hide Answer
Suggested Answer: E 🗳️
by euler at Aug. 24, 2019, 1:25 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
luizyto
2 years, 1 month ago
Selected Answer: E
.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 1 times
...
Ray520
2 years, 10 months ago
https://docs.oracle.com/database/121/REFRN/GUID-6FBA6147-D545-4E7D-94F0-A97EC1C721AE.htm#REFRN10302 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 1 times
...
bigswole
3 years, 4 months ago
it would appear that none are correct when oracle docs reads a subset of DDL is logged not "ALL" "ENABLE_DDL_LOGGING enables or disables the writing of a subset of data definition language (DDL) statements to a DDL log." -https://docs.oracle.com/database/121/REFRN/GUID-6FBA6147-D545-4E7D-94F0-A97EC1C721AE.htm#REFRN10302 C would be the closet to being correct.
upvoted 2 times
...
katetel
3 years, 5 months ago
E is correct, it's different. #297 is another question
upvoted 1 times
...
Modasser
3 years, 9 months ago
C is correct. DDL command are loged in separate log files 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. https://docs.oracle.com/database/121/REFRN/GUID-6FBA6147-D545-4E7D-94F0-A97EC1C721AE.htm#REFRN10302
upvoted 2 times
...
NorthKorean
4 years, 10 months ago
#297 see
upvoted 1 times
NorthKorean
4 years, 10 months ago
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. So E is incorrect
upvoted 2 times
yosiw96816
4 years, 1 month ago
E is correct. #297 - D is "All DDL commands are logged in to a trace file in ADR home." which is incorrect (trace file).
upvoted 3 times
...
...
...
euler
5 years, 5 months ago
I think C is the right answer.
upvoted 4 times
rcgenilo27
5 years, 5 months ago
E is correct https://docs.oracle.com/database/121/REFRN/GUID-6FBA6147-D545-4E7D-94F0-A97EC1C721AE.htm#REFRN10302
upvoted 6 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago