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
Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api
# | Quiz |
---|---|
1
Discuss
|
Which of the following is true regarding views?
Solution |
2
Discuss
|
The basic datatype char (n) is a _______ length character string and varchar (n) is _______ length character.
Solution |
3
Discuss
|
In the authorization graph, if DBA provides authorization to u1 which in turn gives to u2 which of the following is correct?
Solution |
4
Discuss
|
Which of the following is used to provide privilege to only a particular attribute?
Solution |
5
Discuss
|
Which of the following is used to avoid cascading of authorizations from the user?
Solution |
6
Discuss
|
Updates that violate __________ are disallowed.
Solution |
7
Discuss
|
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.
Solution |
8
Discuss
|
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?
Solution |
9
Discuss
|
What type of statement is this?
Solution |
10
Discuss
|
The database administrator who authorizes all the new users, modifies the database and takes grants privilege is
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved