nerdexam
Oracle

1Z0-144 · Question #64

View Exhibit1 and examine the structure of the DO table. View Exhibit2 and examine the code. The anonymous block gives an error on execution. What is the reason?

The correct answer is B. The SQL does not support the Boolean data type. See the full explanation below for the reasoning.

Question

View Exhibit1 and examine the structure of the DO table. View Exhibit2 and examine the code. The anonymous block gives an error on execution. What is the reason?

Exhibits

1Z0-144 question #64 exhibit 1
1Z0-144 question #64 exhibit 2

Options

  • AThe assignment in line 7 is not valid.
  • BThe SQL does not support the Boolean data type.
  • CA null value cannot be applied to the bind arguments In the using clause in line 10
  • DThe names of bind variables must be the same as the using clause bind arguments in line 10

How the community answered

(54 responses)
  • A
    7% (4)
  • B
    78% (42)
  • C
    13% (7)
  • D
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-144 Practice