Back to Top

Quiz Discussion

In the authorization graph, if DBA provides authorization to u1 which in turn gives to u2 which of the following is correct?

Course Name: SQL -Structured Query Language

1]
If DBA revokes authorization from u1 then u2 authorization is also revoked
2]
If u1 revokes authorization from u2 then u2 authorization is revoked
3]
If DBA & u1 revokes authorization from u1 then u2 authorization is also revoked
4]
If u2 revokes authorization then u1 authorization is revoked

Solution

No Solution Present Yet

Top 5 Similar Quiz - Based On AI&ML

Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api

Show entries

Search:

#	Quiz
1 Discuss	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; Solution
10 Discuss	Which of the following is true regarding views? 1] 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 2] 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 3] If a user creates a view on which no authorization can be granted, the system will allow the view creation request 4] A user who creates a view receives all privileges on that view Solution
2 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. 1] With grant 2] Grant user 3] Grant pass privilege 4] With grant option Solution
3 Discuss	`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 Solution
4 Discuss	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 Solution
5 Discuss	The basic datatype char (n) is a _______ length character string and varchar (n) is _______ length character. 1] Fixed, equal 2] Equal, variable 3] Fixed, variable 4] Variable, equal Solution
6 Discuss	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 Solution
7 Discuss	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 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? 1] DML(Data Manipulation Langauge) 2] DDL(Data Definition Langauge) 3] Query 4] Relational Schema Solution
9 Discuss	Which of the following is used to provide delete authorization to instructor? 1] `CREATE ROLE instructor ; GRANT DELETE TO instructor;` 2] `CREATE ROLE instructor; GRANT SELECT ON takes TO instructor;` 3] `CREATE ROLE instructor; GRANT DELETE ON takes TO instructor;` 4] All of the mentioned Solution
#	Quiz

Showing 1 to 10 of 10 entries

Social Media

Copyright © 2020 Inovatik - All rights reserved