nerdexam
Oracle

1Z0-144 · Question #105

You need to remove the database trigger BUSINESS_HOUR. Which command do you use to remove the trigger in the SQL*Plus environment?

The correct answer is A. DROP TRIGGER business_hour. See the full explanation below for the reasoning.

Question

You need to remove the database trigger BUSINESS_HOUR. Which command do you use to remove the trigger in the SQL*Plus environment?

Options

  • ADROP TRIGGER business_hour;
  • BDELETE TRIGGER business_hour;
  • CREMOVE TRIGGER business_hour;
  • DALTER TRIGGER business_hour REMOVE;
  • EDELETE FROM USER_TRIGGERS WHERE TRIGGER_NAME = 'BUSINESS_HOUR';

How the community answered

(32 responses)
  • A
    81% (26)
  • B
    6% (2)
  • C
    3% (1)
  • D
    9% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-144 Practice