gs gs117 SQL: Queries, Constraints and Triggers - Authorizations - Quiz No.1

gs gs117 Database Management System Quiz

This quiz belongs to book/course code gs gs117 Database Management System of gs organization. We have 92 quizzes available related to the book/course Database Management System. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic SQL: Queries, Constraints and Triggers. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.

NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.

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

Super user

Administrator

Operator of operating system

All of the mentioned

Question 2: Which of the following is a basic form of grant statement?

 Grant 'privilege list' on 'relation name or view name' to 'user/role list';

 Grant 'privilege list' on 'user/role list' to 'relation name or view name';

 Grant 'privilege list' to 'user/role list'

 Grant 'privilege list' on 'relation name or view name' on 'user/role list';

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

Grant select on employee to Amit

Grant update(budget) on department to Raj

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

Grant delete to Amit

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

Remove update on department from Amir

Revoke update on employee from Amir

Delete select on department from Raj

Grant update on employee from Amir

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

 Create role instructor ; grant delete to instructor;

 Create role instructor; grant select on takes to instructor;

 Create role instructor; grant delete on takes to instructor;

All of the mentioned

Question 6: Which of the following is true regarding views?

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

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

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

Question 7: 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.

With grant

Grant user

Grant pass privelege

With grant option

Question 8: In authorization graph, if DBA provides authorization to u1 which inturn gives to u2 which of the following is correct?

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

If u1 revokes authorization from u2 then u2 authorization is revoked

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

If u2 revokes authorization then u1 authorization is revoked