Quiz Discussion

Which join condition contains an equality operator:

• 1]

  Equijoins

• 2]

  Cartesian

• 3]

  Natural

• 4]

  Left

A __________ is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.

• 1]

  Procedures

• 2]

  Triggers

• 3]

  Functions

• 4]

  None of the mentioned

The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTER INSERT trigger.

• 1]

  For insert, on

• 2]

  Both a and c

• 3]

  For, insert

• 4]

  On, for insert

The variables in the triggers are declared using

• 1]

  -

• 2]

  @

• 3]

  /

• 4]

  /@

What are the after triggers?

• 1]

  Triggers generated after a particular operation

• 2]

  These triggers run after an insert, update or delete on a table

• 3]

  These triggers run after an insert, views, update, or delete on a table

• 4]

  Both b and c