Back to Top

Quiz Discussion

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

Course Name: SQL -Structured Query Language

  • 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
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

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
2
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
3
Discuss

The variables in the triggers are declared using

  • 1]

    -

  • 2]

    @

  • 3]

    /

  • 4]

    /@

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

Which join condition contains an equality operator:

  • 1]

    Equijoins

  • 2]

    Cartesian

  • 3]

    Natural

  • 4]

    Left

Solution
#Quiz
Showing 1 to 5 of 5 entries