View the exhibit and examine the structure of the products table. Examine the following code Which statement is true when the procedure DELETE_DETAILS is invoked?

Question

Exhibits

Options

• AIt executes successfully but no error messages get recorded in the DEBUG_OUTPUT table
• BIt executes successfully and any error messages get recorded in the DEBUG_OUTPUT table.
• CIt gives an error because PRAGMA AUTONOMOUS_TRANSACTION can be used only in
• DIt gives an error because procedures containing PRAGMA AUTONOMOUS_TRANSACTION

• A
  70% (14)
• B
  10% (2)
• C
  15% (3)
• D
  5% (1)

Explanation

In this case, the debug output will only occur if there is an exception.

No community discussion yet for this question.