exam questions

Exam 1z0-148 All Questions

View all questions & answers for the 1z0-148 exam

Exam 1z0-148 topic 1 question 49 discussion

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

Refer to the Exhibit.

Examine this procedure created in a session where PLSQL_OPTIMIZE_LEVEL =2:

PL/SQL tracing in enabled in a user session using this command:
EXEC DBMS_TRACE.SET_PLSQL_TRACE (DBMS_TRACE.TRACE_ENABLED_LINES)
The procedure is executed using this command:

EXEC PRC_1 -
Examine the exhibit for the content of the PLSQL_TRACE_EVENTS table.
Why is tracing excluded from the PLSQL_TRACE_EVENTS table?

  • A. DBMS_TRACE.TRACE_ENABLED_LINES traces only exceptions in subprograms.
  • B. PRC_1 is not compiled with debugging information.
  • C. Tracing is not enabled with the TRACE_ENABLED_CALLS option.
  • D. PRC_1 is compiled with the default AUTHID DEFINER clause.
  • E. Tracing will be enabled only for the second execution of PRC_1.
Show Suggested Answer Hide Answer
Suggested Answer: BE 🗳️

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
Rakeshpro
2 years, 4 months ago
A program can have trace enabled using one of the following methods: ALTER SESSION SET PLSQL_DEBUG=TRUE; ALTER [PROCEDURE | FUNCTION | PACKAGE] <libunit-name> COMPILE DEBUG [BODY];
upvoted 1 times
Rakeshpro
2 years, 4 months ago
https://oracle-base.com/articles/9i/dbms_trace
upvoted 1 times
...
...
chrishillinger
2 years, 5 months ago
Selected Answer: B
B is correct, forget E
upvoted 1 times
...
CosminCof
4 years, 2 months ago
B is right
upvoted 1 times
...
DmitryPDN
5 years ago
Only B is correct answer.
upvoted 4 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago