USER AND DATABASE PRIVILEGES 1 Aug,2023 boomtecho2@gmail.comLeave a comment Please enter your email: 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 above 2. 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 3. 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 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 4. 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 5. The granting and revoking of roles by the user may cause some confusions when that user role is revoked. To overcome the above situation The privilege must be granted only by roles The privilege is granted by roles and users The user role cannot be removed once given By restricting the user access to the roles 6. Authorization can be granted to user as All privilege No privilege Combination of privileges All of the above 7. Authorizations on data have different forms of 2 type 3 type 4 type 5 type 8. What is database user ? it should only have access to the database resources Database users own the objects they create in a database both A and B are True none of the above 9. The database manager who authorizes all the new users, modifies database and takes grants privilege is, is known to be Administrator Authorizer Author Authentication 10. Each of the types of authorizations is called a/an Grant Access Privilege Access Assignment 11. Privileges are granted over some specified parts of a database, such as a Relation or view Schema Environment Query statement 12. How many types of user privilege ? 2 3 1 4 13. Names of user privileges_ System Privilege Objective Privilege Data Privilege Both A and B 14. What is system privilege ? a user to perform standard administrator tasks in the database quite powerful set of rights therefore when in wrong hands they could result in catastrophic events Both A and B none of the above 15. Objective Privilege term_ Object privilege is the permission to access specific database objects Object privilege entails performing a specific action on a particular table, function, or package. Both A and B none of the above 16. The privilege list allows the granting of 1 command only 2 command only Multiple commands No commands 17. The basic form for assigning access statement is create assign define grant 18. The responsibility of the database administrator includes Authorize users structure database Restructure database All of the above 19. In the authorization graph, the node representing the database administrator, is known to be root node child node leaf node Neighboring node 20. The current role associated with a session can be set by executing set role define role select role grant role Loading …
