nerdexam
Oracle

1Z0-147 · Question #10

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

(55 responses)
  • A
    82% (45)
  • B
    2% (1)
  • C
    5% (3)
  • D
    9% (5)
  • E
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-147 Practice