View the Exhibit to examine the PIVSQL block. Which statement is true about the output of the PL/SQL block?

Question

Exhibit

Options

• AIt executes and the Output is emprec.deptname: .
• BIt executes and the Output is emprec.deptname: Sales.
• CIt produces an error because NULL is assigned to the emprec.empid field in the record.
• DIt produces an error because the CHECK constraint is violated while assigning a value to the

• A
  72% (21)
• B
  7% (2)
• C
  17% (5)
• D
  3% (1)

Explanation

The variable emprec does dot inherits the constraints.

No community discussion yet for this question.