What is the difference between OF column_name and ON table_name in trigger syntax?

102. What is the difference between OF column_name and ON table_name in trigger syntax?

OF column_name specifies the column name that is needed to be updated whereas ON table_name specified the table name that is associated with the trigger.
ON table_name specifies the column name that is needed to be updated whereas OF column_name specified the table name that is associated with the trigger.
OF table_name specifies the column name that is needed to be updated whereas ON column_name specified the table name that is associated with the trigger.
ON column_name specifies the column name that is needed to be updated whereas OF table_name specified the table name that is associated with the trigger.

Answer: A) OF column_name specifies the column name that is needed to be updated whereas ON table_name specified the table name that is associated with the trigger.

Explanation:

OF column_name specifies the column name that is needed to be updated whereas ON table_name specified the table name that is associated with the trigger.

Comments and Discussions!

Load comments ↻

Recently Published MCQs