Quiz Discussion

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

What type of statement is this?

• 1]

  Query

• 2]

  DML

• 3]

  Relational

• 4]

  DDL

CREATE TABLE employee (name VARCHAR, id INTEGER)

What type of statement is this?

• 1]

  DML

• 2]

  DDL

• 3]

  View

• 4]

  Integrity constraint

Updates that violate __________ are disallowed.

• 1]

  Integrity constraints

• 2]

  Transaction control

• 3]

  Authorization

• 4]

  DDL constraints

The database administrator who authorizes all the new users, modifies the database and takes grants privilege is

• 1]

  Operator of operating system

• 2]

  Administrator

• 3]

  Super user

• 4]

  All of the mentioned

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

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

An attribute A of datatype varchar(20) has the value “Avi”. The attribute B of datatype char(20) has value ”Reed”. Here attribute A has ____ spaces and attribute B has ____ spaces.

• 1]

  3, 20

• 2]

  20, 4

• 3]

  20, 20

• 4]

  3, 4

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