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

McqMate

Q.	Which of the following is used to provide privilege to only a particular attribute?
A.	grant select on employee to amit
B.	grant update(budget) on department to raj
C.	grant update(budget,salary,rate) on department to raj
D.	grant delete to amit
Answer» B. grant update(budget) on department to raj

1.9k

0

Do you find this helpful?

17

View all MCQs in

DataBase Management System (DBMS)

Discussion

No comments yet

Related MCQs

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.
The attribute name could be structured as an attribute consisting of ﬁrst name, middle initial, and last name. This type of attribute is called
Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:
The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called
An attribute in a relation is a foreign key if the key from one relation is used as an attribute in that relation.
An attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation.
A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .
The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called
The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as a primary key is called ______________
The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as primary key is called