Quiz Discussion

The variables in the triggers are declared using

Course Name: SQL -Structured Query Language

  • 1]

    -

  • 2]

    @

  • 3]

    /

  • 4]

    /@

Solution
No Solution Present Yet

Top 5 Similar Quiz - Based On AI&ML

Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api

# Quiz
1
Discuss

Which join condition contains an equality operator:

  • 1]

    Equijoins

  • 2]

    Cartesian

  • 3]

    Natural

  • 4]

    Left

Solution
2
Discuss

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

Solution
3
Discuss

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

Solution
4
Discuss

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

Solution
5
Discuss

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

Solution
# Quiz