SQL -Structured Query Language - SQL Insert - Insert Record Quiz

The granting and revoking of roles by the user may cause some confusion when that user role is revoked. To overcome the above situation

• 1]

  By restricting the user access to the roles

• 2]

  The privilege must be granted only by roles

• 3]

  The privilege is granted by roles and users

• 4]

  The user role cannot be removed once given

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

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

The variables in the triggers are declared using

• 1]

  -

• 2]

  @

• 3]

  /

• 4]

  /@