nerdexam
Oracle

1Z0-071 · Question #109

Examine these SQL statements that are executed in the given order: What will be the status of the foreign key EMP_MGR_FK?

The correct answer is C. It will remain disabled and can be re-enabled manually. See the full explanation below for the reasoning.

Question

Examine these SQL statements that are executed in the given order:

What will be the status of the foreign key EMP_MGR_FK?

Exhibit

1Z0-071 question #109 exhibit

Options

  • AIt will be enabled and immediate.
  • BIt will be enabled and deferred.
  • CIt will remain disabled and can be re-enabled manually.
  • DIt will remain disabled and can be enabled only by dropping the foreign key constraint and re-

How the community answered

(29 responses)
  • A
    10% (3)
  • B
    7% (2)
  • C
    79% (23)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice