Quiz Time
SQL -Structured Query Language

Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?

• 1]

  DML(Data Manipulation Langauge)

• 2]

  DDL(Data Definition Langauge)

• 3]

  Query

• 4]

  Relational Schema

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

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

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 ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.

• 1]

  Where, from

• 2]

  From, select

• 3]

  Select, from

• 4]

  From, where