Quiz Discussion

INSERT INTO instructor VALUES (10211, ’Smith’, ’Biology’, 66000);

What type of statement is this?

• 1]

  Query

• 2]

  DML

• 3]

  Relational

• 4]

  DDL

Updates that violate __________ are disallowed.

• 1]

  Integrity constraints

• 2]

  Transaction control

• 3]

  Authorization

• 4]

  DDL constraints

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

SELECT * FROM employee

What type of statement is this?

• 1]

  DML

• 2]

  DDL

• 3]

  View

• 4]

  Integrity constraint

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

To remove a relation from an SQL database, we use the ______ command.

• 1]

  Delete

• 2]

  Purge

• 3]

  Remove

• 4]

  Drop table

Which of the following is used to provide privilege to only a particular attribute?

• 1]

  Grant update(budget,salary,Rate) on department to Raj

• 2]

  Grant update(budget) on department to Raj

• 3]

  Grant select on employee to Amit

• 4]

  Grant delete to Amit

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

CREATE TABLE employee (name VARCHAR, id INTEGER)

What type of statement is this?

• 1]

  DML

• 2]

  DDL

• 3]

  View

• 4]

  Integrity constraint

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