Quiz Discussion

Which of the following is used to provide delete authorization to instructor?

• 1]

  CREATE ROLE instructor ;
  GRANT DELETE TO instructor;

   

• 2]

  CREATE ROLE instructor;
  GRANT SELECT ON takes
  TO instructor;

   

• 3]

  CREATE ROLE instructor;
  GRANT DELETE ON takes
  TO instructor;

   

• 4]

  All of the mentioned

CREATE TABLE employee (name VARCHAR, id INTEGER)

What type of statement is this?

• 1]

  DML

• 2]

  DDL

• 3]

  View

• 4]

  Integrity constraint

SELECT * FROM employee

What type of statement is this?

• 1]

  DML

• 2]

  DDL

• 3]

  View

• 4]

  Integrity constraint

In the authorization graph, if DBA provides authorization to u1 which in turn gives to u2 which of the following is correct?

• 1]

  If DBA revokes authorization from u1 then u2 authorization is also revoked

• 2]

  If u1 revokes authorization from u2 then u2 authorization is revoked

• 3]

  If DBA & u1 revokes authorization from u1 then u2 authorization is also revoked

• 4]

  If u2 revokes authorization then u1 authorization is revoked

If we wish to grant a privilege and to allow the recipient to pass the privilege on to other users, we append the __________ clause to the appropriate grant command.

• 1]

  With grant

• 2]

  Grant user

• 3]

  Grant pass privilege

• 4]

  With grant option

Which of the following is used to avoid cascading of authorizations from the user?

• 1]

  Granted by the current role

• 2]

  Revoke select on the department from Amit, Satoshi restrict;

• 3]

  Revoke grant option for select on the department from Amit;

• 4]

  Revoke select on the department from Amit, Satoshi cascade;

DELETE FROM r;   /* r - relation  */

This command performs which of the following action?

• 1]

  Remove relation

• 2]

  Clear relation entries

• 3]

  Delete fields

• 4]

  Delete rows

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

Which of the following is true regarding views?

• 1]

  The user who creates a view cannot be given update authorization on a view without having update authorization on the relations used to define the view

• 2]

  The user who creates a view cannot be given update authorization on a view without having update authorization on the relations used to define the view

• 3]

  If a user creates a view on which no authorization can be granted, the system will allow the view creation request

• 4]

  A user who creates a view receives all privileges on that view

Which of the following statement is used to remove the privilege from the user Amir?

• 1]

  Remove update on department from Amir

• 2]

  Revoke update on employee from Amir

• 3]

  Delete select on department from Raj

• 4]

  Grant update on employee from Amir